DEV Community

#sqlite

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
From a Pile of Office Files to a Searchable Local Knowledge Base: I Built an Open-Source Skill

From a Pile of Office Files to a Searchable Local Knowledge Base: I Built an Open-Source Skill

Comments
5 min read
Why SQLite WAL Still Raises "database is locked" in Python

Why SQLite WAL Still Raises "database is locked" in Python

Comments
8 min read
Real range from a scooter's battery readings: sum the kilometres, sum the percent, then divide

Real range from a scooter's battery readings: sum the kilometres, sum the percent, then divide

Comments
3 min read
Self-Hosted WhatsApp E-Commerce & Automated Client Proposals in Pure Python + SQLite (Zero SaaS Fees)

Self-Hosted WhatsApp E-Commerce & Automated Client Proposals in Pure Python + SQLite (Zero SaaS Fees)

Comments
6 min read
Offline-first mobile: SQLite and a sync queue

Offline-first mobile: SQLite and a sync queue

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

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

9
Comments
7 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
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.