SQLite Is the Most Deployed Database in the World
Every iPhone has it. Every Android has it. Every browser has it. It handles trillions of transactions daily.
But SQLite has always had one limitation: it is a local file. You cannot share it between servers.
Turso: SQLite Goes Global
Turso takes SQLite and makes it work like a distributed database. Your data lives at the edge, close to your users.
Free Tier
- 500 databases (not a typo)
- 9GB total storage
- 25 billion row reads/month
- Unlimited locations for replication
- No credit card required
How It Works
Turso uses libSQL, their open-source fork of SQLite. It adds:
- HTTP API — query from anywhere, not just local processes
- Replication — data syncs to edge locations worldwide
- Embedded replicas — sync a full copy to your app for zero-latency reads
Connect in 3 Lines
import { createClient } from '@libsql/client'
const db = createClient({
url: 'libsql://your-db-turso.turso.io',
authToken: 'your-token'
})
const result = await db.execute('SELECT * FROM users WHERE active = 1')
Embedded Replicas (The Killer Feature)
const db = createClient({
url: 'libsql://your-db-turso.turso.io',
authToken: 'your-token',
syncUrl: 'libsql://your-db-turso.turso.io' // sync from cloud
})
// Reads are LOCAL (microseconds, not milliseconds)
const users = await db.execute('SELECT * FROM users')
// Writes go to cloud and sync back
await db.execute('INSERT INTO users (name) VALUES (?)', ['Alice'])
await db.sync() // Pull latest changes
Reads from a local SQLite file. Writes sync to the cloud. Best of both worlds.
Turso vs Other Databases
| Feature | Turso (Free) | Supabase (Free) | Neon (Free) |
|---|---|---|---|
| Databases | 500 | 2 | 1 |
| Storage | 9GB | 500MB | 512MB |
| Read latency | ~1ms (edge) | ~50ms | ~30ms |
| Embedded mode | Yes | No | No |
| SQLite compatible | Yes | No (Postgres) | No (Postgres) |
When to Use Turso
- Edge applications on Cloudflare Workers, Vercel Edge
- Read-heavy workloads where latency matters
- Mobile/desktop apps that need offline-first with sync
- Personal projects — 500 databases on free tier is absurd
When to Use Postgres Instead
- Complex joins across large tables
- Full-text search at scale
- Existing Postgres ecosystem tools
- Team already knows Postgres
Get Started
brew install tursodatabase/tap/turso
turso db create my-app
turso db tokens create my-app
Need web data for your database? Check out 88+ production scrapers on Apify — Reddit, Trustpilot, Google News, and more. Custom solutions: spinov001@gmail.com
Top comments (0)