Hacker News new | ask | show | jobs
by muhaaa 1427 days ago
Always use a temporal database (datomic, postgres with temporal_tables extension). You get out of the box the full history of your data. That is really helpful for business intelligence and analytics, auditing / audit log (security, accountability), live sync & real-time features and as a bonus easy recovery after application fails.

If disk gets to full, project the latest time slice into a new database and move the old database onto a cold storage.

1 comments