DEV Community

#sqlite

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
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
Keep SQLite data in a private child directory, not at the Docker volume root

Keep SQLite data in a private child directory, not at the Docker volume root

Comments
3 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
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
Queryable Executables: Revolutionizing Software with Embedded Intelligence

Queryable Executables: Revolutionizing Software with Embedded Intelligence

1
Comments
4 min read
I've Built RAG Infrastructure Several Times. Last Week Was the First Time I Actually Benchmarked It.

I've Built RAG Infrastructure Several Times. Last Week Was the First Time I Actually Benchmarked It.

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