SQLite as LakeXpress DB

SQLite needs no server: the LakeXpress DB is a single file. It is the quickest way to try LakeXpress. SQLite can only be used as the LakeXpress DB, not as a source database.

1. Add it to the credentials file

There is nothing to create beforehand: LakeXpress creates the file, and any missing folder in its path, on first use.

{
  "lxdb_sqlite": {
    "ds_type": "sqlite",
    "auth_mode": "filesystem",
    "info": {
      "filepath": "/var/lib/lakexpress/lakexpress_log.sqlite"
    }
  }
}

Parameter	Required	Description
ds_type	Yes	Must be "sqlite"
auth_mode	Yes	Must be "filesystem"
filepath	Yes	Path to the SQLite file

Use an absolute path. A relative path is resolved against the directory LakeXpress is run from, so running it from another directory would create a new, empty LakeXpress DB there.

2. Create the LakeXpress tables

./LakeXpress lxdb init -a credentials.json --lxdb_auth_id lxdb_sqlite

When to use SQLite

Good for: trying LakeXpress, development, single-user setups without a database server.

Avoid for: several users or machines sharing configurations, syncs running in parallel.

Troubleshooting

Unable to open database file: The user running LakeXpress cannot write to the file or to its folder. Check the permissions of the path in filepath, and the free disk space.