So from talking with my friends, and my own experience, what I've realised and know is that - my bass downtuned to B standard and having a standard fender scale length of 34'' makes standard strings pretty floppy, so I use a set of .135 (I don't really remember, but I think these are what is on my bass) to compensate for the slack with string thickness. Maybe I haven't worded my question well enough, but I do get that part. The lower you go, the less tension there is, so you have to use thicker strings, but at a certain point it becomes unplayable. I don't want to use a ridiculous set of strings that are .3000 thick for it to somewhat work, and so to barely achieve playability i have to make the neck longer so it kind of balances out. At least that's how I understand this has to go.
And this is where I get lost really. If I were to use a 5 string bass scale length it would come out to be just 35'', and I don't think that will work for E0 (I'm not actually sure, at least not with reasonably thick strings, might be wrong about it), so I think it would need to be longer, but how long actually. Is there a way to get the needed scale length in relation to string tension needed to play it, and what kind of strings would work the best? I'm lost on this part. I want it somewhat playable, but just enough. I don't think there would even be an amp, or a speaker that could produce such low notes but, I believe its still a fun and silly project to do.
Also my friend that I've mentioned earlier suggested that it possibly would have to have a scale length of over 40'' for it to be feasible, don't actually quote me on that.