SQLite (LakeXpress DB Only)

SQLite can be used as the LakeXpress DB — the internal database where LakeXpress stores its configuration, tracks sync state, and logs pipeline runs. It is not supported as a source database.

Because SQLite is file-based and requires no server, it is the simplest option to get started with.

Connection Parameters

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

Example

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

When to Use SQLite

Good for: single-user setups, development, testing, deployments without a database server.

Avoid for: multi-user environments, high-concurrency production, distributed systems.

Troubleshooting

Unable to open database file: Check file path, verify directory exists with write permissions, use absolute paths, check disk space.

See Also

• Database Connections Overview - Auth file format, security best practices