Postgres, a battle-tested and scalable software, is highly valued by the author despite its slower speed in introducing new features and limitations with adding plugins and migrating to new versions. One notable missing feature is data versioning, which the author has had to add manually multiple times in different ways. After exploring alternatives and considering using Git for versioning, the author opts for a simple implementation within Postgres. This implementation involves storing everything in a global object storage, with each update creating a new blob that contains the entire object. The author acknowledges potential issues with schema migration and discusses alternative versioning methods in Postgres.
https://www.specfy.io/blog/7-git-like-versioning-in-postgres