3 ms·
Bitemporalism a la SQL:2011 has been partly or wholly implemented by several RDBMSes at this point. Off the top of my head SQL Server, Oracle and MariaDB have i
by jacques_chester 6y ago
Bitemporalism a la SQL:2011 has been partly or wholly implemented by several RDBMSes at this point. Off the top of my head SQL Server, Oracle and MariaDB have it as well as DB2.
I'm looking forward to seeing it in PostgreSQL.
- phonon 6y agoCheck out https://github.com/arkhipov/temporal_tables https://github.com/arkhipov/temporal_tables or https://github.com/scalegenius/pg_bitemporal https://github.com/scalegenius/pg_bitemporal
- jacques_chester 6y agoI'm familiar with these and they are useful, but I would greatly prefer mainline support using the SQL standard. A mainline implementation is far more likely to lead to optimisations being made to the query planner, indices, disk formats etc.
- phonon 6y agoI am in vehement agreement!
- gurjeet 6y agoYou may be pleased to know that someone is actively working on this. There was a presentation [1] by the author Paul A. Jungwirth at this year's PGCon last week. [1]: https://www.pgcon.org/events/pgcon_2020/schedule/session/100-progress-adding-sql2011-valid-time-to-postgres/ https://www.pgcon.org/events/pgcon_2020/schedule/session/100...