public inbox for [email protected]  
help / color / mirror / Atom feed
BI Temporality in PostgreSQL
2+ messages / 2 participants
[nested] [flat]

* BI Temporality in PostgreSQL
@ 2021-11-23 15:17  Jean Baro <[email protected]>
  0 siblings, 1 reply; 2+ messages in thread

From: Jean Baro @ 2021-11-23 15:17 UTC (permalink / raw)
  To: [email protected]

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 *Bi*temporality natively in
PostgreSQL?

Thanks


^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: BI Temporality in PostgreSQL
@ 2021-11-23 15:37  Tom Lane <[email protected]>
  parent: Jean Baro <[email protected]>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2021-11-23 15:37 UTC (permalink / raw)
  To: Jean Baro <[email protected]>; +Cc: [email protected]

Jean Baro <[email protected]> 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....





^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2021-11-23 15:37 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-11-23 15:17 BI Temporality in PostgreSQL Jean Baro <[email protected]>
2021-11-23 15:37 ` Tom Lane <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox