Tag
DuckDB has spent two or three years quietly working its way into data architectures. It is no longer just the embedded database for local analytics: in 2025 it keeps turning up in concrete enterprise cases where it replaces far pricier pieces. A tour of the real patterns.
DuckDB is an embedded, columnar, vectorized SQL engine that runs inside your own process and queries Parquet, CSV, JSON, S3, and URLs in place. For DuckDB analytics up to a hundred gigabytes it beats pandas on speed and a cloud warehouse on friction cost. It is not a transactional engine. Version 1.0 landed in June 2024.
SQLite and DuckDB are both embedded databases that work from a single file, no server needed. Their architecture differs: SQLite stores rows and excels at short transactions (OLTP); DuckDB stores columns and shines at large-scale analytics (OLAP). Choosing the right one, or combining both, delivers a genuine technical edge.
