db

Each site lists its SQLite databases by NAME only — the file location is fixed: db/<name>.db inside the site folder, created on first start. One file = one database = one writer; a dedicated database keeps high-write tables away from your content.

"db": [
  { "name": "main" }
]
keydescription
nameidentifier referenced from tables.<t>.db and by /soe sign-in

Reserved names: tables users and sys_keys are created by the system in the site’s FIRST database when the cms block is present, and the table name media belongs to uploads; the database name log belongs to the node’s request log (see access_log) — a site does not declare it. Letter case does not make a name free: SQLite compares table names case-insensitively, so Users or SyS_KeYs is refused as the system table it would bind to, and names starting with sqlite_ belong to SQLite itself. Database files are chmod 600, they contain key material.

Backup = the site folder’s db/ plus media/.

← All articles in this group