On 10/7/15, Simon Slavin <slavins at bigfraud.org> wrote: > (B) The product itself is called SQLite3 so the '3' has to be fixed. Major > rewrites to SQLite to, for example, introduce WAL mode, can't change the > '3'.
The "3" is the file format. SQLite1 and SQLite2 used different and incompatible file formats. SQLite 3.8.12 can read and write any database made by any prior version of SQLite. SQLite 3.0.0 can read and write any database made by any subsequent version of SQLite, as long as no new features (ex: common table expressions, partial indexes) are used. (In practice, so many new features have been added since 3.0.0 that it will be difficult to find a real database that 3.0.0 can read and write, but it is possible in theory.) -- D. Richard Hipp drh at sqlite.org
