SQLite has an option to create an in-memory database that doesn't rely on an on-disk database file. This avoids the complexity I just mentioned, but can also provide dramatically improved performance.

create table Hens ( Id int primary key, Name text ) What might not be so obvious is that all rows within SQLite tables include a 64-bit signed integer key, uniquely identifying the row within its ...