Access to MariaDB

What This Book Will Cover

MariaDB is the community-driven fork of MySQL, free from Oracle's ownership and increasingly popular as a cost-effective database choice. This book covers migrating from Access to MariaDB, leveraging MySQL compatibility while taking advantage of MariaDB-specific improvements.

If you've considered MySQL but want to avoid Oracle's licensing model, or if your Linux distribution ships MariaDB by default, this guide covers the specific differences you'll encounter and how to handle them.

Planned Contents

• MariaDB vs. MySQL: what's the same, what's different, and why it matters
• Installation and configuration (Linux and Windows)
• Migration using MySQL-compatible tools and workflows
• Manual migration with Python (pymysql works for both)
• Data type mapping: Access to MariaDB
• MariaDB-specific features useful for Access migrations (sequences, system-versioned tables)
• ODBC Connector setup for Access front-end
• When MariaDB diverges from MySQL — the gotchas
• Performance tuning and storage engine choices
• Community support and long-term viability