SQLite
The driver for SQLite is community-supported and is not supported by Cube or the vendor.
Prerequisites
Setup
Manual
Add the following to a .env file in your Cube project:
CUBEJS_DB_TYPE=sqlite
CUBEJS_DB_NAME=my_sqlite_databaseEnvironment Variables
| Environment Variable | Description | Possible Values | Required |
|---|---|---|---|
CUBEJS_DB_NAME | The name of the database to connect to | A valid database name | ✅ |
CUBEJS_DB_MAX_POOL | The maximum number of concurrent database connections to pool. Default is 8 | A valid number | ❌ |
CUBEJS_CONCURRENCY | The number of concurrent queries to the data source | A valid number | ❌ |
SSL
SQLite does not support SSL connections.