SQLite

Connect to a SQLite database

Setup

The following credentials keys are accepted:

• instance (required) -> The local file path, HTTP or S3 url of the database file

• access_key_id (optional) -> The Access Key ID to access the bucket (if providing a S3 url)

• secret_access_key (optional) -> The Secret Key to access the bucket (if providing a S3 url)

• endpoint (optional) -> The S3 endpoint hostname for non-AWS providers (if providing a S3 url). Examples: nyc3.digitaloceanspaces.com, a345678c73f3e8bddd084cb125876543.r2.cloudflarestorage.com, etc.

Here is an example of setting a connection named SQLITE:

# URL format
export SQLITE='sqlite:///path/to/file.db'

# YAML format
export SQLITE="{type: sqlite, instance: /path/to/file.db}"

export SQLITE="{type: sqlite, url: 's3://<bucket>/<key>', access_key_id: '<access_key_id>', secret_access_key: '<secret_access_key>}'"