SQLite setup and configuration
ConnectorsSQLite
Install and configure the connector through the interactive CLI:
Code
For direct use, install it with npm install form0-connector-sqlite.
| Environment variable | Purpose | Default |
|---|---|---|
FORM0_CONNECTOR_SQLITE_PATH | Relative or absolute database path | ./form0.db |
FORM0_CONNECTOR_SQLITE_TABLE_NAME | Main table | form0_submissions |
FORM0_CONNECTOR_SQLITE_CHILD_TABLE_NAME | Nested-record table | form0_submissions_children |
FORM0_CONNECTOR_SQLITE_DEBUG | Verbose connector logging | false |
Relative database paths are resolved from the process working directory. The connector creates the parent directory and database file when necessary, so the process needs suitable write access.
The package requires Node.js 22 or newer and a platform supported by its better-sqlite3 native
dependency. It is not intended for React Native or Expo; use platform-native mobile storage such
as expo-sqlite there.
Do not place a submission database inside a public web directory or commit it to source control.
Last modified on