Back to Cube

SQLite

docs-mintlify/admin/connect-to-data/data-sources/sqlite.mdx

1.6.441.4 KB
Original Source
<Warning>

The driver for SQLite is community-supported and is not maintained by Cube or the database vendor.

</Warning>

Prerequisites

Setup

Manual

Add the following to a .env file in your Cube project:

dotenv
CUBEJS_DB_TYPE=sqlite
CUBEJS_DB_NAME=my_sqlite_database

Environment Variables

Environment VariableDescriptionPossible ValuesRequired
CUBEJS_DB_NAMEThe name of the database to connect toA valid database name
CUBEJS_DB_MAX_POOLThe maximum number of concurrent database connections to pool. Default is 8A valid number
CUBEJS_CONCURRENCYThe number of concurrent queries to the data sourceA valid number

SSL

SQLite does not support SSL connections.