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
Comments
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
Comments
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
Comments
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

Comments
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

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

Edge Read Slices: Take Read Load Off Your Central Database

Comments
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

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

sqlite3 .dump forgets user_version: test your restore

Comments
4 min read
Rust solved the compatibility trap with editions

Rust solved the compatibility trap with editions

Comments
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

Comments
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

Comments
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.

Comments
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

Comments
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

Comments
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

Comments
6 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.