DEV Community

Chris King
Chris King

Posted on

I Built a Hosted SQLite SaaS That's Free to Use 🚀

Now Open to Free Signups

SQLite is magical. S3 is cheap. I combined them.

LiteLoft is a hosted database service built on
distributed-sqlite
— SQLite backed by S3, with a full provisioning layer,
auth, and monetization baked in.

Why this exists

I was already running SQLite on S3 with Litestream for a
production app. Then I built distributed-sqlite — a
SQLAlchemy dialect that treats S3 as the storage layer
with concurrent write support.

The next logical step? Host it.

How it works

  • Your DB lives in S3 as SQLite files + manifests
  • We issue short-lived STS credentials scoped to your tenant prefix — zero standing IAM access, ever
  • Connect with one line of Python via our client SDK
with connect(api_key=API_KEY, api_base_url=BASE) as engine:
    with engine.begin() as conn:
        conn.execute(
            text("CREATE TABLE IF NOT EXISTS hello (id INTEGER PRIMARY KEY, msg TEXT)")
        )
Enter fullscreen mode Exit fullscreen mode

The Stack

  • distributed-sqlite — S3-backed SQLAlchemy dialect
  • AWS STS AssumeRole — per-tenant isolated creds
  • App Runner — lightweight provisioning layer
  • S3 — the actual database storage

Two Ways to Use It

☁️ Use Our Cloud (Free Tier Available)

Sign up → get a DB → connect. Done.

👉 liteloft.dev

🛠️ BYO Bucket — Self Host in Your AWS Account

One-click CloudFormation deploy. Your data never
leaves your account.

Launch Stack

Install

Server (self-host):

pip install db-host-api
Enter fullscreen mode Exit fullscreen mode

👉 pypi.org/project/db-host-api

Client:

pip install db-host-client
Enter fullscreen mode Exit fullscreen mode

👉 pypi.org/project/db-host-client

Open Source

MIT licensed. Contributions welcome.

👉 github.com/chrisk60331/distributed-sqlite-host


🆓 Free signups open now. No credit card. No infra.
Just a DB that lives in the cloud and costs almost
nothing to run.

Drop a comment if you have questions or want to
collaborate. Building in public — follow along. 🔷

opensource #sqlite #aws #database #python #buildinpublic

webdev #cloudcomputing

Top comments (0)