Thread: BI Temporality in PostgreSQL

BI Temporality in PostgreSQL

From

Jean Baro

Date:

23 November 2021, 18:17:17

Hi there,

After PostgreSQL, Datomic is my favorite Database concept/vision (I have never worked with it, though). IMO, the most interesting capability is the time travel capability, which would be helpful in a large set of companies and PostgreSQL users.

https://blog.dbi-services.com/temporal-tables-for-postgresql-15/

Is there anything discussed to support Bitemporality natively in PostgreSQL?

Thanks

Re: BI Temporality in PostgreSQL

From

Tom Lane

Date:

23 November 2021, 18:37:37

Jean Baro <jfbaro@gmail.com> writes:
> Is there anything discussed to support *Bi*temporality natively in
> PostgreSQL?

There are people working on the SQL-standard temporality features [1].
Not sure if that's exactly what you have in mind.

            regards, tom lane

[1] https://www.postgresql.org/message-id/flat/CA+renyUApHgSZF9-nd-a0+OPGharLQLO=mDHcY4_qQ0+noCUVg@mail.gmail.com