News for hackers. Stuff that matters.
Re:Perf Is Not Enough by swasheck on Sunday March 10, 2024 @08:14PM (#39663569)
- each version breaks previous format and renders it unusable
Re:Perf Is Not Enough by 1egg0myegg0 on Sunday March 10, 2024 @08:45PM (#39663760)
We heard your feedback! Backward compatibility was just implemented! Version 0.9 is actually fully readable by 0.10. With version 1.0 coming in a few months, this will be readable for several years' worth of version updates.
Re:Perf Is Not Enough by eyegor on Monday March 11, 2024 @02:18AM (#39665341)
> readable for several years

Why not just make shims to migrate dbs for future compatibility? So you could read db 1.0 in v2.0 but only insofar as to migrate it to v2. The implication that you don't want to promise backwards read compatibility feels antithetical to a db driver.

For example, if I have an ancient mssql db that was started in 2001, I'm confident that I can grab the latest mssql driver and still use it. I don't have to track down mssql 2007 to migrate incrementally. Not sure about postgres or mysql but I assume it's the same there. Sqlite is definitely backwards read compatible.

Re:Perf Is Not Enough by plugin-baby on Monday March 11, 2024 @02:29AM (#39665387)
Postgres:

> Major versions usually change the internal format of system tables and data files. These changes are often complex, so we do not maintain backward compatibility of all stored data.

https://www.postgresql.org/support/versioning/

Re:Perf Is Not Enough by lmz on Monday March 11, 2024 @05:55AM (#39666271)
You're confusing a network protocol client (the MSSQL "driver") with an on-disk format. You can't upgrade the MSSQL server from 2001 to current in-place: https://learn.microsoft.com/en-us/sql/database-engine/instal...
Re:Perf Is Not Enough by Tarq0n on Monday March 11, 2024 @04:31AM (#39665862)
That seems entirely fair for pre-1.0 software.