Temporal Tables PostgreSQL Extension

• temporal_tables

  16 896 4.2 C

  Temporal Tables PostgreSQL Extension

• periods

  5 235 2.4 PLpgSQL

  PERIODs and SYSTEM VERSIONING for PostgreSQL

• InfluxDB

  www.influxdata.com sponsored

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

• temporal_tables

  6 576 4.9 PLpgSQL

  Postgresql temporal_tables extension in PL/pgSQL, without the need for external c extension. (by nearform)

  

I was part of a team at NearForm using this for a project on an EC2 instance. In order to move to AWS RDS we had to recreate the functionality of temporal_tables as a PostgreSQL function, rather than extension.

When we switched, we found that although there were minor bugs, 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 solution.

Suggest a related project