Five Million Rows Show Where SQLite and DuckDB Split

A reproducible five-million-row comparison explains how SQLite’s row storage and DuckDB’s columnar engine behave under different workloads. It covers scans, indexed lookups, planning, transactions, and file size, tying large analytical gaps back to physical layout.

🔗 diogoribeiro7.github.io

#SQLite #DuckDB #databases