2016-04-14 21:46 GMT+02:00 Richard Hipp <drh at sqlite.org>: > On 4/14/16, Cecil Westerhof <cldwesterhof at gmail.com> wrote: > > For example a database with partial tables can not be read with a > > SQLite before 3.8.0. So why is SQLite not changed so primary keys can not > > have the value NULL? > > You fail to distinguish between "forwards compatible" and "backwards > compatible". > > Upgrading your program from version X to version Y (with Y>X) should > never cause your historical data to become unreadable. That's what > "backwards compatible" means. Upgrading does not break stuff. SQLite > is backwards compatible. >
?Yes that makes sense. But could not a type of PRAGMA be used? So if the PRAGMA is not defined the old functionality and your historical data is save. And if the PRAGMA is defined the new functionality. -- Cecil Westerhof