📰 sqlite

A faster way to copy SQLite databases between computers

I store a lot of data in SQLite databases on remote servers, and I often want to copy them to my local machine for analysis or backup.

weeklyfoo #83 / 2025-05-05

Open

sqlitedatabases

Bluesky SQLite

Each user uses its own sqlite database locally

weeklyfoo #6 / 2023-11-12

Open

blueskysqlite

Gotchas with SQLite in Production

Read the seven gotchas if you’re thinking about using sqlite.

weeklyfoo #42 / 2024-07-22

Open

sqlitedatabases

JSONB has landed

More performant json functions for SQLite dbs

weeklyfoo #10 / 2023-12-13

Open

sqlitejson

Why does SQLite (in production) have such a bad rep?

SQLite, like any other database, has its pros and cons. For the majority of applications and scales, it is perfect. You always have PostgreSQL for anything else.

weeklyfoo #38 / 2024-06-24

Open

sqlite

Zero-latency SQLite storage in every Durable Object

Using SQLite in Durable Objects

weeklyfoo #52 / 2024-09-30

Open

cloudflaresqlite