» Tag
duckdb
6 postsDuckDB vs SQLite: 100x more rows on the same $16.49 server
On the same $16.49/month server, DuckDB writes 4x-15x faster than SQLite and serves dashboards at 100x the row count. Full Traceway benchmark results.
DuckDB Parquet Paging: file_row_number vs OFFSET, and a Correctness Trap
DuckDB Parquet paging compared: file_row_number vs OFFSET performance, plus a hidden data-correctness risk in parallel scans.
Generating the database from the answer key in text-to-SQL benchmarks
A UIUC audit found over half of BIRD and Spider 2.0 annotations wrong. One developer inverted the process: declare the answer first, then generate a database that satisfies it.
CommitBrief — AI code reviews, right in your terminal
A provider-agnostic, local-first CLI that reviews your staged changes, a historic range, or a whole GitHub pull request. Zero telemetry, no server. Free and open source.
commitbrief.comSynnoDB: Accelerating SQL with Custom Engines for DuckDB
SynnoDB accelerates SQL queries for DuckDB using custom C++ engines.
Database Comparison: SQLite, DuckDB, PostgreSQL, and More
Explore features of SQLite, DuckDB, PostgreSQL, MariaDB, ClickHouse, and MongoDB. Essential insights for engineers.
DuckDB v2.0: Your Database Deserves a Better Parser
DuckDB v2.0 enhances user experience by replacing the PostgreSQL parser with a PEG-based parser for better extensibility and easier query writing.