Databases in 2025: A Year in Review

kept by eddie jan 12

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.

SQLite JSON at full index speed using generated columns
SQLite can index JSON fields at full B-tree speed by creating virtual generated columns with json_extract and indexing them.
also on DuckDB, PostgreSQL, SQLite, #open-source, #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, #open-source, #developer-tools
Craft Agents - Open Source Agent Orchestration
Craft Agents is an open-source agent orchestration platform that connects to any API, MCP server, or local file via natural language, with a built-in browser, multimodal model support, and session-based workflows.
also on PostgreSQL, MCP, #ai-agents, #open-source, #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, #open-source, #developer-tools
How OpenAI Codex Works - ByteByteGo Newsletter
OpenAI's Codex agent relies on an orchestration layer handling prompt assembly, context management, and a custom protocol for multi-surface support.
also on MCP, #ai-agents, #open-source, #software-engineering, #developer-tools