Y
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
tempest_
146 days ago
Eh you could implement this pretty simply with postgres table partitions
link
buchanae
146 days ago
Ah, that's an interesting idea! I had never considered using partitions. I might write a followup post with these new ideas.
link
tempest_
146 days ago
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.
link