DEV Community

#sqlite

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
SQLite 3.54 stops rewriting an expression index when the indexed value hasn't changed

SQLite 3.54 stops rewriting an expression index when the indexed value hasn't changed

1
7 min read
My Cursor state.vscdb was 8.9 GB. You can work out how much VACUUM will save before you run it

My Cursor state.vscdb was 8.9 GB. You can work out how much VACUUM will save before you run it

2
4 min read
Your Kindle remembers every word you looked up. Here is how to get them out.

Your Kindle remembers every word you looked up. Here is how to get them out.

1
6 min read
Building a Resilient Telegram Bot in Python: Idempotent Updates, SQLite Job Queue, Retries, Graceful Shutdown

Building a Resilient Telegram Bot in Python: Idempotent Updates, SQLite Job Queue, Retries, Graceful Shutdown

15 min read
Using node:sqlite in Node 24 to Build a Tiny Express Service Without a Separate Database Server

Using node:sqlite in Node 24 to Build a Tiny Express Service Without a Separate Database Server

4 min read
Edge Read Slices: Take Read Load Off Your Central Database

Edge Read Slices: Take Read Load Off Your Central Database

2 min read
SQLite Says 'database is locked' at 4 Writers: WAL, busy_timeout and BEGIN IMMEDIATE

SQLite Says 'database is locked' at 4 Writers: WAL, busy_timeout and BEGIN IMMEDIATE

9 min read
sqlite3 .dump forgets user_version: test your restore

sqlite3 .dump forgets user_version: test your restore

4 min read
Rust solved the compatibility trap with editions

Rust solved the compatibility trap with editions

3 min read
48-Hour Field Notes: My Latency Numbers Were Wrong Because I Started the Clock in the Wrong Place

48-Hour Field Notes: My Latency Numbers Were Wrong Because I Started the Clock in the Wrong Place

7 min read
Weekend Build Log: A Human Gate Between the Model and Your Database

Weekend Build Log: A Human Gate Between the Model and Your Database

6 min read
My Hosting Platform Runs on Two SQLite Files. Here's How I Back Them Up and Bring Them Back.

My Hosting Platform Runs on Two SQLite Files. Here's How I Back Them Up and Bring Them Back.

9 min read
Room 3 froze on a suspending @Transaction: the SQLite driver you pass picks your connection pool

Room 3 froze on a suspending @Transaction: the SQLite driver you pass picks your connection pool

16 min read
48-Hour Field Notes: I Crash-Tested My Resumable Batch Job Before Trusting a Free Box

48-Hour Field Notes: I Crash-Tested My Resumable Batch Job Before Trusting a Free Box

6 min read
48-Hour Field Notes: My Queue Drained to Zero and the Work Wasn't Done

48-Hour Field Notes: My Queue Drained to Zero and the Work Wasn't Done

6 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.