Back to articles
I Built a Hosted SQLite SaaS That's Free to Use 🚀
How-ToSystems

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

via Dev.to TutorialChris King

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) " ) ) The Stack distributed-sqlite — S3-backed SQLAlchemy dialect AWS STS AssumeRole — per-tenant isolated creds App Runne

Continue reading on Dev.to Tutorial

Opens in a new tab

Read Full Article
1 views

Related Articles