DEV Community

#sqlite

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
Why SQLite refuses your ALTER TABLE, and the twelve-step rebuild it wants instead

Why SQLite refuses your ALTER TABLE, and the twelve-step rebuild it wants instead

5
Comments
3 min read
LISTENing but Connection Reset by Peer: A SQLite Connection Leak That Exhausted 255 of 256 File Descriptors

LISTENing but Connection Reset by Peer: A SQLite Connection Leak That Exhausted 255 of 256 File Descriptors

Comments 1
4 min read
Building VALYVRA: two authentication lessons from a Web3 prototype

Building VALYVRA: two authentication lessons from a Web3 prototype

Comments
4 min read
I turned my website directory into an offline Android app. Here's the one SQL trick that made it work

I turned my website directory into an offline Android app. Here's the one SQL trick that made it work

Comments 2
3 min read
My AI audit tool was merging Claude and Cursor sessions. The bug was one UNIQUE constraint.

My AI audit tool was merging Claude and Cursor sessions. The bug was one UNIQUE constraint.

Comments
5 min read
Why We Built an Offline-First Architecture for Temporary Emails on Android

Why We Built an Offline-First Architecture for Temporary Emails on Android

Comments 1
2 min read
How to Give Your AI Coding Agent Infinite Memory

How to Give Your AI Coding Agent Infinite Memory

1
Comments
3 min read
Build, Adopt, Build Again: Seven Months of Search in a Personal AI Tool

Build, Adopt, Build Again: Seven Months of Search in a Personal AI Tool

Comments
12 min read
I built a local memory layer for AI agents: no vector DB, one SQLite file

I built a local memory layer for AI agents: no vector DB, one SQLite file

Comments
4 min read
Only 11.8% of insider trades are actual purchases: lessons from polling SEC EDGAR

Only 11.8% of insider trades are actual purchases: lessons from polling SEC EDGAR

Comments
4 min read
What's actually inside Apple Mail's Envelope Index

What's actually inside Apple Mail's Envelope Index

1
Comments
3 min read
SQLite FTS5 vs Whoosh: when to reach for a pure-Python search library

SQLite FTS5 vs Whoosh: when to reach for a pure-Python search library

Comments
3 min read
SQLite 3.53's self-healing index only repairs the rows you write to

Comments debate integrity check behaviors

SQLite 3.53's self-healing index only repairs the rows you write to

13
Comments 5
9 min read
A read-only offline mirror in op-sqlite: network first, upsert-MERGE, never delete-then-insert

A read-only offline mirror in op-sqlite: network first, upsert-MERGE, never delete-then-insert

Comments
7 min read
Idempotent, budget-bounded AI queries on a single SQLite writer

Idempotent, budget-bounded AI queries on a single SQLite writer

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