On 20 May 2015, at 8:52pm, Kees Nuyt <k.nuyt at zonnet.nl> wrote: > The autoincrement clause causes an entry in the sqlite_sequence > table.
It's interesting that SQLite uses tables inside the user database for private purposes like this. A certain wall is broken when the designers choose this option. SQLite does it for sqlite_master, sqlite_sequence, sqlite_stat*, and probably others I've forgotten. SQLite is handicapped by having no permanent data storage location. It has nowhere to store configuration information apart from inside the user's databases or as compilation settings. This is very unusual but, I think, contributes a lot to how portable SQLite is: no need to understand folder structure or safe places to keep configuration information; increased startup-speed; reduced code size, fewer file handles, slightly reduced memory. Simon.
