🪶

SQLite

Perfect for embedded analytics and local development

Connection Settings

Field	Description	Example
File Path	Path to SQLite database file	/data/analytics.db
Mode	Read-write or read-only access	Read Only

Features

File-Based

Simply point to any .db or .sqlite file

In-Memory Mode

Create temporary databases for testing

Zero Config

No server setup required, just connect

Read-Only Support

Safe mode to prevent accidental modifications

Use Cases

1Local development and testing with sample data

2Analyzing exported data from other systems

3Embedded analytics for desktop applications

4Quick data exploration without server setup

5CI/CD pipelines with test databases

In-Memory Database

For temporary testing, use the special in-memory path:

File Path: :memory:

# This creates a temporary database that exists
# only for the duration of the connection.
# Perfect for testing and experimentation.