nearform/temporal_tables
View on GitHub ↗ ★ 766 PLpgSQL
Postgresql temporal_tables extension in PL/pgSQL, without the need for external c extension.
6 mentions on Hacker News by 6 people: 1 story, 5 comments · first 2021-04-11 · latest 2024-08-17
20082026
-
…of is a trigger-based system which moves the deleted record into an entirely new table. I've used https://github.com/nearform/temporal_tables before for that, has been pretty solid. Still need to manually keep the schema in sync, though.
comment by pikdum · 2024-08-17 · in Soft Deletes with Ecto and PostgreSQL -
▲ 2
PostgreSQL temporal_tables extension in PL/pgSQLstory by todsacerdoti · 2023-12-06 · 0 comments
-
It was reimplemented in pure SQL here https://github.com/nearform/temporal_tables for this purpose
comment by l-vincent-l · 2023-10-20 · in Versioning data in Postgres? Testing a Git like approach -
…at 11:55pm last night?" - "Show me the diff on feature flags between now and a week ago" [1]: https://github.com/nearform/temporal_tables
comment by PaulMest · 2023-09-22 · in Ways to capture changes in Postgres -
…Postgres-based implementations of SQL:2011's temporal versioning might get you close enough: - https://github.com/nearform/temporal_tables - https://github.com/xocolatl/periods - https://github.com/scalegenius/pg_bitemporal -…
comment by refset · 2022-10-23 · in Show HN: I made a CMS that uses Git to store your data -
…we didn't have any noticeable loss of performance and we have used it ever since for many projects. https://github.com/nearform/temporal_tables If you're also limited by cloud services and the extensions limitations, this is a great…
comment by Codesleuth · 2021-04-11 · in Temporal Tables PostgreSQL Extension