DEV Community

#sqlite

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
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
Your Agent's Memory Is a Lie: A Durable, Queryable Memory Layer for Local LLM Agents

Your Agent's Memory Is a Lie: A Durable, Queryable Memory Layer for Local LLM Agents

1
Comments
7 min read
SQLite FTS5 quietly ANDs your search terms

SQLite FTS5 quietly ANDs your search terms

Comments
4 min read
Your isolated test lab isn't isolated: 3 rows, 8 daemons

Your isolated test lab isn't isolated: 3 rows, 8 daemons

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