On 2 Jul 2017, at 12:15am, 積丹尼 Dan Jacobson <jida...@jidanni.org> wrote:
> This tells me that sqlite3 is storing schemas in some inefficient wrong way! SQLite stores the statements needed to create the schema. For example, the structure of a table is not stored in any structured way, instead the "CREATE TABLE" command is stored. When you use an "ALTER TABLE" command, SQLite parses and modifies the "CREATE TABLE" command to fake a new one representing the new structure. This means that major changes can be made to how SQLite works internally without needing to revise the file format, which has remained almost unchanged since 2004. This is incredibly useful to SQLite’s users who can use completely up-to-date tools to manipulate ancient databases. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
