» Tag
duckdb
7 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.
Importing Data Using Java Table Functions
The significance of Java table functions in transferring data from MongoDB to DuckDB. Performance challenges and solutions.
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.