Typical for 70s and 80s.
Honestly, designing a 21st century database is a different thing if compared to back then.
You can use 128 bit integers, provided that you really want to use integers. And maybe you put a timestamp along.
and maybe put a 32bit timestamp along and pretend it can somehow store more than a 32bit integer can.
You don’t often expect to have two billion of something until you do.
Its defaults are also either a 18-character ID, or a 32bit integer. So, unless you take the effort to actually fight Apex, you're gonna hit this problem sooner or later.
This kind of workload cheerfully “scales” to your disk capacity.
You can shard them between 2 tables. Then migrate them to a single one later.
But what about my good night's sleep? How can I go to bed without reading about my favorite blorbos?
Real ones back them up in a single .txt file
And that's perfect. Blame the wall too, because it was running just fine. It's a site to write (mostly porn), with better uptime and more daily users than most of the companies posted on HN daily.
4,247,583: Teen And Up Audiences
4,173,082: General Audiences
2,816,083: Explicit
2,271,446: Mature
1,676,061: Not RatedAnd then I pulled apart PT-OSC to make it more... less incredibly stupid about resource use, so it wouldn't cause too much load while it backfilled. And let it run for about 6 weeks.
Good luck! It's a fun problem to have - excess success, and a light puzzle to solve :)
It's Dead Dove though.
That's much more of a "kick the can down the road" solution to only double your usable range, but if all positive the values in the rows shouldn't actually have to change, just the column metadata, so it could theoretically be more or less instantaneous. I guess in practice this doesn't happen; the server would rather use its generic "rebuild the table" alter method for changing a column type.
But it seems like you could reasonably do it if it's a signed-to-unsigned change and there's no negative values and there's an index on the column to make checking that fact fast. Or one of those third-party/lower-level type tools could let you do it without any checking.
it's interesting that some people are on the internet but is very well insulated! AO3 is very well known for me...
Not sure I'd call it "insulated", the internet is just very, very vast, even when considering "just" the English-speaking web. Then you have all the other "versions" out there too that are kind of hidden to most people :)
Anecdotal, but also first time I heard about AO3, and I'd consider myself having broad interests and generally well-read, although my interests doesn't include fanfiction so maybe not so weird I haven't heard about it before.
FWIW the vast majority of writing on there is decidedly mediocre. There is also an even more inferior alternative called Wattpad.
Funnily enough you learn that in general we aren't all that different in our tastes, it's just that what men like to watch, women like to read / imagine.
Edit: to paint the picture, this[0] was sent to me a while back :-)
[0]https://www.tiktok.com/@alexarowe11/video/746846214634761757...
I don't think it's as gendered as you paint it, but I'd also acknowledge it depends a lot on geographic location, probably looks different where I am compared to where you are, I agree with that we probably aren't all that different in tastes in general :)
Having been an active internet user for longer than most AO3 users have been alive, the first time I heard about it was a few years ago in a student radio show about the fanfic genre and culture. Poorly written smut featuring popular culture characters has just never been my thing. Probably because I’m not that much of a fan of any given fictional setting or franchise.
schoen•5h ago
https://arstechnica.com/information-technology/2014/12/gangn...
wging•4h ago