DEV Community

#sqlite

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
SQLite 3.53's self-healing index only repairs the rows you write to

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

11
Comments 3
9 min read
Agent memory that commits the write before it tries to embed

Agent memory that commits the write before it tries to embed

Comments
2 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
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
Hybrid search in one file with node:sqlite, FTS5 and zero dependencies

Hybrid search in one file with node:sqlite, FTS5 and zero dependencies

Comments 1
3 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
Stop Installing MongoDB for This: SQLite Is Already a Document Database

Stop Installing MongoDB for This: SQLite Is Already a Document Database

Comments
6 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
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
LatticeDB vs SQLite: I Ran the Graph Traversal Benchmarks. The Gap Is Real but the Fine Print Matters

LatticeDB vs SQLite: I Ran the Graph Traversal Benchmarks. The Gap Is Real but the Fine Print Matters

Comments
8 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
One SQLite query took Apple Mail automation from 10s to 0.1ms

One SQLite query took Apple Mail automation from 10s to 0.1ms

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