4 ms·

I've found SQL Server Temporal Tables are a good alternative to get the benefits of soft-deletes without some of the drawbacks. https://docs.microsoft.com/en-u

I've found SQL Server Temporal Tables are a good alternative to get the benefits of soft-deletes without some of the drawbacks. https://docs.microsoft.com/en-us/sql/relational-databases/tables/temporal-tables https://docs.microsoft.com/en-us/sql/relational-databases/ta...

tfigment 4y ago
Mysql also has this now. I've wanted to rewrite out apps to use it but haven't gotten around to it. Postgres has it as an addon but feels like it wouldn't work for us until its first class supported.
- evanelias 4y ago
  MariaDB has this -- called system-versioned tables -- but MySQL actually does not. Although they share a common lineage, MySQL and MariaDB are somewhat distinct databases at this point, with each one having a number of features that the other lacks.
- nicoburns 4y ago
  I believe first-class support is in development for Postgres. The article I read made it sound like it would probably land in either the next major version, or the one after that.