×
Login Register an account
Top Submissions Explore Upgoat Search Random Subverse Random Post Colorize! Site Rules
3

Size of database

submitted by ilikeskittles to TalkDev 2.8 yearsAug 2, 2021 12:44:40 ago (+3/-0)     (TalkDev)

Anybody know how much space this site takes?


6 comments block


[ - ] GloryBeckons 1 point 2.8 yearsAug 2, 2021 13:14:37 ago (+1/-0)

No way of knowing, but an educated guess would be on the order of 10s to 100s of MB at most.

It's just text and votes. Maybe the thumbnails, if they're not stored on disk separately. But they're tiny too, in any case. If it got to more than 1 gig I'd be very surprised.

The access logs are probably bigger than the database, unless they went out of their way to disable them. Those filling up the hard drive brought the old Voat down a couple of times. But this place has far less traffic for now.

[ - ] ilikeskittles [op] 0 points 2.8 yearsAug 2, 2021 13:45:47 ago (+0/-0)

For some reason I don't think the thumbnails are in the database. But I have no idea for sure.

[ - ] GloryBeckons 0 points 2.8 yearsAug 2, 2021 14:40:47 ago (+0/-0)

I don't think they are, either.

The filenames (or what looks like a filename in the URL) look like hashes. And have different file extensions. Neither of those things exclude the possibility of them being in a DB, but they also don't make a whole lot of sense, if they are. In general, putting files in a DB is not a good idea.

In any case, the thumbs probably average 4 kB or so. And not all posts have one. So if we ballpark guess that there might be 100,000 posts with thumbnails, that would be about 400 MB? I think that's an overestimate, if anything.

[ - ] ilikeskittles [op] 0 points 2.8 yearsAug 2, 2021 14:42:52 ago (+0/-0)

I know the old code is at github, it's from 2017, if I read it correctly. Does anyone know where the current code is???

[ - ] GloryBeckons 0 points 2.8 yearsAug 2, 2021 14:51:53 ago (+0/-0)

The original Voat was .NET and this is PHP. So it's a completely different codebase, likely written from scratch and just made to look like Voat. I doubt the code is public.

[ - ] ilikeskittles [op] 0 points 2.8 yearsAug 2, 2021 14:54:40 ago (+0/-0)

I'm more comfortable with PHP, but would be a lot of work to create that out of scratch. Ugh.