Local First
Posts tagged “Local First”.
- The Row Count Was the Wrong Way to Choose Between SQLite and JSONL
At 10,000 records SQLite already beat unindexed JSONL on lookup, aggregate and update, while append stayed close. The operations decided it, not the row count.
- The Data Was Already in the Browser
WireData turns JSON responses and page tables into local SQL datasets, but the real design problem was preserving consent, bytes, and lineage.
- Why I Self-Host
Privacy, cost, and resilience matter, but the honest reason I self-host is enjoying the work, even when it means drivers and firewall lockouts.
- They Took the Jack
The headphone jack was universal and zero-configuration, yet disappeared because most people did not miss it—the cost of designing for the average.
- Everything With a Battery Cooks in a Parked Car
Heat, cold, and a rule against using the starter battery eliminated most parking-mode recorders and led to a battery-less 4G build.
- The Missing Middle in Data Tooling
Between enterprise platforms and one-off query tools lies a missing class of focused utilities for reconciliation, schema drift, and file comparison.
- I Have Four Edit Histories for the Same Photo
Non-destructive photo editors preserve the original but scatter edit history across proprietary catalogs whose long-term readability is not guaranteed.