Eating an Elephant Converting PostgreSQL extensions to MySQL
summary
VillageSQL builds a stable VAF extension framework for MySQL that implements about 12 of ~50 Postgres extension capabilities and ships 22 extensions (12 internal, ~10 community). It provides a Rust SDK and two OpenAI skills that auto-port Postgres extensions and install servers, and offers three binaries (MySQL 8.4, Percona 8.4, MySQL 9.7) with a stable ABI. New extensions include an MCP server, ClickHouse stats sync, OAuth2 auth, and a preview vector index (HNSW) that is 50x faster than full scans and scales ~13x from 1 to 32 threads on 60k-vector inserts.
AI-written summary · about
chapters (8)
- 0:00Introduction
- 1:29Village SQL framework
- 3:14MySQL extensibility needs
- 5:19New distributions and compatibility
- 6:22MCP server and telemetry
- 8:48Vector search in MySQL
- 10:34Live demo
- 16:25Q&A
related talks
30mDriving Innovation in MySQL with Extensions
27mDesign Considerations for a simple Extension Framework For MySQL
16mWhy PostgreSQL took the crown from MySQL and what lies ahead
28mBeyond Postgres: Insights about the PostgreSQL Extensibility
31mBuild scalable and secure enterprise apps on OSS databases Q&A
22mState of the Elephant
06mScaling your applications with Cloud SQL for MySQL
26mState of the Postgres Extension Ecosystem