8 ms·

Is DB2 dead ?

• Smeevy 6y ago
  My company uses it all the time. It's an absolutely rock-solid database and I've never had any issues with it. They just released their new containerized version a few months back and have recently simplified their licensing rather significantly. One of my favorite features is the "time travel" query. If you enable this feature on one or more tables you can essentially say "give the results of this query as it would have been at time x". I don't know if anyone else provides that, but it's pretty great stuff.
  • amaura 6y ago
    Oracle does since version 10 at least. It’s actually available by default.
  • 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 ago
      Check 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 ago
        I'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 ago
          I am in vehement agreement!
        • gurjeet 6y ago
          You 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...