Hacker News Reader

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/ta...

View on HN

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.

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.

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.

Reply on news.ycombinator.com