News Score: Score the News, Sort the News, Rewrite the Headlines

Implementing System-Versioned Tables in Postgres

I like Postgres, but there are things I really wish they would implement. For example, the SQL:2011 spec adds support for system-versioned tables. Unfortunately, Postgres and SQLite are basically the only SQL databases that don’t yet support it. While it has been discussed in length at the postgreqsl-hackers’ mailing list, it seems like the discussion and implementation efforts have been silent in all of 2023. Now, there are extensions out there that implement versioning – temporal_tables being ...

Read more at hypirion.com

© News Score  score the news, sort the news, rewrite the headlines