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
Where to Find VillageSQL Next Week
We're on the road next week with three Bay Area events across the MySQL community. If you're at any ...
Why the World's Most Popular Database Is at a Crossroads
MySQL still runs a remarkable share of the internet — 42% of the web is WordPress alone, plus many t...
Village News: MySQL/Database News + Events (13 May 2026)
As part of building the MySQL Community, we are going to publish a curated overview of MySQL and dat...
MySQL in N-Dimensions: High-Complexity Data with vsql-cube
MySQL stores numbers well. What it can't do is treat a row's values as a multi-dimensional point in ...
Village News: MySQL/Database News (1 May 2026)
As part of building the MySQL Community, we are going to publish a curated overview of MySQL and dat...
MySQL with AI Inside
Most AI integrations with a database follow the same pattern: your application fetches rows, ships t...
Bringing External Data into MySQL with the vsql-http Extension
Every second, your database rows change: a new customer, a successful payment, a fresh sign-up. But ...
The Extensibility Tax: Decisions, Principles, & Lessons in Teaching MySQL New Tricks
On April 20, 2026, VillageSQL’s CTO Steve Schirripa gave a talk to Carnegie Mellon's (CMU) Database ...