Hacker News new | ask | show | jobs
by vjvjvjvjghv 146 days ago
I guess that works well with NoSQL. In a relational database it gets harder to move record out if they have relationships with other tables.
1 comments

Eh you could implement this pretty simply with postgres table partitions
Ah, that's an interesting idea! I had never considered using partitions. I might write a followup post with these new ideas.
There are a bunch of caveats around primary keys and uniqueness but I suspect it could be made to work depending on your data model.