Learn MySQL
Practical guides for developers building on VillageSQL
MySQL Indexes
How to speed up queries with the right index strategy
JSON in MySQL
Store, query, and manipulate JSON documents natively
Window Functions
Running totals, rankings, and moving averages
Primary Key Strategies
Auto-increment, UUIDs, and when to use each
Password Hashing
Bcrypt and Argon2 for secure credential storage
Postgres to MySQL
A practical migration guide for common patterns
MySQL on Docker
Run MySQL in containers for local and production
Stored Procedures
Encapsulate and reuse SQL logic in the database
Joins
How to combine rows from multiple tables with INNER, LEFT, and other JOINs
Transactions
Keep your data consistent with ACID-compliant transactions
CTEs in MySQL
Write readable, recursive queries with common table expressions
Slow Query Log
Find and fix the queries slowing down your database
From the blog
How VillageSQL does documentation
How VillageSQL writes its docs: a public repo, an AI agent that runs every example it writes on a li...
Village News: MySQL News + Events (13 November 2026)
Welcome back to Village News, our curated roundup of MySQL and database news. This week, PostgreSQL ...
How Oracle changed the future of MySQL: Dominic Preuss on Inside the Silicon Mind
An interview of Dominic Preuss from VillageSQL by Firas Sozan from Silicon Mind.
Village News: MySQL News + Events (5 November 2026)
Welcome back to Village News, our curated roundup of MySQL and database news. This week, AWS contrib...
How VillageSQL does open source
VillageSQL plans and builds VillageSQL Server, the open source MySQL fork that adds an extension fra...
Village News: MySQL News + Events (29 October 2026)
Welcome back to Village News, our curated roundup of MySQL and database news. This week, plans for F...
Crafting an Extension Framework for MySQL: a talk from MySQL BR Conf 2026
The design choices behind the VillageSQL Extension Framework, from simpler functions to parameterize...
Benchmarking vector indexes in MySQL with vector-dev-bench
PostgreSQL has a rapidly evolving vector ecosystem. MySQL is earlier on that road, but the community...