Choose DuckDB rather than SQLite

kept by eddie aug 01

The article argues DuckDB outperforms SQLite for analytical queries due to its columnar storage and vectorized execution, recommending it for data analysis tasks over SQLite's transactional strengths.

Databases in 2025: A Year in Review
Andy Pavlo's 2025 database review covers PostgreSQL's continued dominance, emerging trends like vibe coding, and commentary on SQLite, DuckDB, and MCP security risks.
also on DuckDB, SQLite, #data-extraction, #developer-tools
GitHub - posit-dev/ggsql: A SQL extension for declarative data visualisation based on the Grammar of Graphics.
ggsql is a SQL extension that enables declarative data visualization within SQL queries using the Grammar of Graphics, currently supporting DuckDB and SQLite.
also on DuckDB, SQLite, #developer-tools
birdclaw — Local Twitter memory in SQLite
Birdclaw is a local-first Twitter workspace that imports archives and caches live reads into a single SQLite database, accessible via CLI and web app.
also on SQLite, #data-extraction, #developer-tools
pi + ghostty running entirely in a cloudflare workers durable object. sqlite based file system + js code exec + cron support. The best part
pi and ghostty run inside a Cloudflare Workers durable object, using SQLite for file storage and supporting JS execution, cron, and worker site deployment.
also on SQLite, #infrastructure, #developer-tools
[2602.02361] SWE-Universe: Scale Real-World Verifiable Environments to Millions
SWE-Universe automatically constructs 807,693 real-world software engineering environments from GitHub PRs via iterative self-verification and in-loop hacking detection.
also on #data-extraction, #infrastructure