Topic Tag

#databases

Showing 3 articles in this topic

Glowing digital data points connecting into search index networks
Software • 5 min read

Building Instant Search with SQLite FTS5: Why You Don't Need Elasticsearch

Elasticsearch and Algolia add massive operational complexity to simple blogs. How SQLite's native FTS5 extension gives you sub-2ms BM25 ranking on zero budget.

Daniel Dano Read article →
Analytics dashboard displaying data visualizations on high tech monitor
Software • 5 min read

Columnar Databases for Web Analytics: ClickHouse vs Postgres Group By

Why running aggregations on 50 million event logs in Postgres grinds your server to a halt, and how columnar storage computes averages in 3 milliseconds.

Daniel Dano Read article →
Server rack network indicators glowing cleanly in a modern data center
Software • 5 min read

Why We Migrated 50,000 Active Users to SQLite

Ditching a managed cloud PostgreSQL instance saved us hundreds of dollars a month and dropped query latency from 35ms to under 1ms.

Daniel Dano Read article →