Comment by vjvjvjvjghv
16 hours 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.
16 hours 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.
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.