Design Considerations for a simple Extension Framework For MySQL
summary
Village SQL shows a working extension framework that adds custom MySQL types with minimal boilerplate, demonstrated by a ROT13 example that stores and compares rotated strings. The framework exposes a C++ SDK to register types with from/to/compare hooks, and keeps an escape hatch API for varargs, printf-style parsing, and stateful per-statement init/deinit. Preview capabilities include background threads and in-extension queries. Current gaps: varargs, printf semantics, and index integration are planned but not fully implemented; core plumbing is open source.
AI-written summary · about
chapters (9)
- 0:00MySQL extension framework intro
- 2:57Design goals
- 4:42VDF argument processing
- 9:00Simplicity vs flexibility
- 12:46Happy path vs escape hatches
- 15:37Edge cases & feedback
- 17:22Parameterized types
- 19:09Preview & future-proofing
- 20:47Q&A
related talks
27mEating an Elephant Converting PostgreSQL extensions to MySQL
33mPlugins in MariaDB and MySQL — So What’s in It for Me?
01h 05m“A modern database interface for C++"
44mAdventures in MySQL
52mAnarchy in the Database: A Survey and Evaluation of Database Management System Extensibility
49mNew Client Tool for Developers and DBAs
39mDuckDB Extension Development Workshop – Part 1
42mPostgreSQL Extensions: A Deep Dive