Turso Has a Free API — Edge SQLite Database With 9GB Storage and 500M Rows Read

#database #api #tutorial #webdev

SQLite at the Edge, For Free

Turso gives you a managed SQLite database that runs at the edge (35+ locations). Free tier: 9GB storage, 500M rows read/month, 25M rows written/month.

Setup

# Install CLI
curl -sSfL https://get.tur.so/install.sh | bash
turso auth login
turso db create my-app-db
turso db tokens create my-app-db

JavaScript Client

import { createClient } from "@libsql/client";

const db = createClient({
  url: "libsql://my-app-db-username.turso.io",
  authToken: "your-token"
});

// Create table
await db.execute("CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY, name TEXT, email TEXT)");

// Insert
await db.execute({ sql: "INSERT INTO users (name, email) VALUES (?, ?)", args: ["John", "john@example.com"] });

// Query
const result = await db.execute("SELECT * FROM users");
result.rows.forEach(row => console.log(row));

Python Client

import libsql_experimental as libsql

conn = libsql.connect("my-app-db-username.turso.io", auth_token="your-token")
cursor = conn.cursor()

cursor.execute("SELECT * FROM users WHERE name LIKE ?", ("%John%",))
for row in cursor.fetchall():
    print(row)

Embedded Replicas (Offline-First)

const db = createClient({
  url: "file:local-replica.db",
  syncUrl: "libsql://my-app-db-username.turso.io",
  authToken: "your-token"
});

// Sync with remote
await db.sync();

// Now queries hit local file - instant!
const result = await db.execute("SELECT * FROM users");