Tag: sqlite
Reducing Ambiguity in a SQL Agent using a domain glossary and RAG
A domain glossary can give an LLM agent context it needs to finish a task, but when that is not enough to understand importance, RAG can reduce ambiguity
Replace SQLite with Bolt
Use Bolt for IO internal storage and general data persistence.
Building a SQLite context sidecar for my-pi
Right, so, this started with me looking at , seeing a 98% context reduction claim, and immediately thinking: bull shite. Not because the idea is bad. The idea is good. The bit that made me twitch was the shape of the claim. If you compare a huge...
Add telemetry to my-pi
keeps growing in the direction of whatever annoyed me most that week. It is the coding agent harness I’ve been building on top of the excellent pi-coding-agent from badlogic, and I keep bolting things onto it as I need them for real work. Last time...
Migrating Off Of Fathom Analytics
This is the follow-up to Local Analytics with SQLite and SvelteKit. That post covered the infrastructure - batched writes, heartbeat-based live visitors, the production meltdown and rebuild. This one’s about actually removing the Fathom API...
Local Analytics with SQLite and SvelteKit
I’ve been using Fathom Analytics for years and it’s great, but I wanted something more integrated. Something that could power live visitor counts and popular posts without external API calls. This is what I learned building self-hosted analytics...
Use CGO, libc, and pure SQLite
Since Envoy will always depend on libc, it seems reasonable for IO to also.
Use SQLite
Use SQLite for IO internal storage and general data persistence.
Glauber Costa - Forking SQLite and Building a Distributed Database with Turso
Glauber Costa explains how Turso forks SQLite into libSQL to create a distributed database, drawing from his Linux kernel development experience.
Jess Martin - DXOS
Jess Martin explains DXOS, a framework for local-first multiplayer apps where users own their data and carry identity across applications.
Script to Remove Core Data's SQLite Database File During Development Cycles
During development of applications that uses Core Data on the iPhone, I find myself often wanting to delete the SQLite database file. This is