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. -- D. Richard Hipp drh at sqlite.org