sqlalchemy-libsql 0.2.0

SQLAlchemy dialect for libSQL

Turso + SQLAlchemy (experimental)

This package is experimental, which means it is not consider to be production grade. Furthermore, the package currently only supports Linux and macOS.

SQLite for Production. Powered by libSQL.

Turso · Quickstart · Examples · Docs · Discord · Blog & Tutorials

---

Examples

Embedded Replica

import os
from sqlalchemy import create_engine

engine = create_engine(
     "sqlite+libsql:///embedded.db",
     connect_args={
         "auth_token": os.getenv("TURSO_AUTH_TOKEN"),
         "sync_url": f"{os.getenv("TURSO_DATABASE_URL")}",
     },
)

Remote Database

import os
from sqlalchemy import create_engine

engine = create_engine(
    f"sqlite+libsql://{os.getenv("TURSO_DATABASE_URL")}?secure=true",
    connect_args={
        "auth_token": os.getenv("TURSO_AUTH_TOKEN"),
    },
)

In-Memory Database

from sqlalchemy import create_engine

engine = create_engine("sqlite+libsql://")

Local Database

from sqlalchemy import create_engine

engine = create_engine("sqlite+libsql:///local.db")

Documentation

1. Turso Quickstart — Learn how create and connect your first database.
2. SDK Quickstart — Learn how to install and execute queries using the libSQL client.
3. SDK Reference — Dive deeper with the libSQL SDK reference and examples.

What is Turso?

Turso is a SQLite-compatible database built on libSQL, the Open Contribution fork of SQLite. It enables scaling to hundreds of thousands of databases per organization and supports replication to any location, including your own servers, for microsecond-latency access.

Learn more about what you can do with Turso:

• Embedded Replicas
• Platform API
• Branching
• Point-in-Time Recovery