Small. Fast. Reliable.
Choose any three.

Rowid Tables

1.0 Definition

A "rowid table" is any table in an SQLite schema that

Most tables in a typical SQLite database schema are rowid tables.

Rowid tables are distinguished by the fact that they all have a unique, non-NULL, signed 64-bit integer rowid that is used as the access key for the data in the underlying B-tree storage engine.

2.0 Quirks