SQLite Cloud

Connecting to a Cluster

SQLite databases in SQLite Cloud are distributed across a cluster of nodes. Each cluster comes with a multi-region load balancer that routes traffic to the nearest appropriate node.

Click “Connect” in the bottom left-hand corner of your dashboard to get your connection string to use with a SQLite Cloud client library.

Connecting with JavaScript

Here’s an example of how you can connect to your cluster using the @sqlitecloud/drivers JavaScript client library:

First, install the client library:

npm install @sqlitecloud/drivers

Then, connect to your cluster using the connection string:

import { Database } from '@sqlitecloud/drivers';

const db = new Database('sqlitecloud://<your-project-id>.sqlite.cloud:<your-host-port>?apikey=<your-api-key>')

const fetchAlbums = async () => await db.sql`USE DATABASE chinook.sqlite; SELECT * FROM albums;`;

fetchAlbums().then((albums) => console.log(albums));

// [{ Title: 'For Those About To Rock We Salute You', ... }, ...]

Connecting with Python

Install the Python client library:

pip install sqlitecloud

Then, connect to your cluster using the connection string:

import sqlitecloud

# Open the connection to SQLite Cloud
# Note: Include your target database in the url to skip the USE DATABASE command
conn = sqlitecloud.connect("sqlitecloud://<your-project-id>.sqlite.cloud:<your-host-port>?apikey=<your-api-key>")

cursor = conn.execute("SELECT * FROM albums WHERE AlbumId = ?", (1, ))
result = cursor.fetchone()

print(result)

conn.close()

# (1, 'For Those About To Rock We Salute You', 1)

Next Steps