Although MySQL and MariaDB share a common ancestry, their functionality has diverged in subtle ways over the years. In this post, we’ll explore the differences in DDL and schema-related features of these two database servers, as well as operational concerns when performing schema changes.
Skeema v1.10.0 is now available! Our latest release adds support for managing seed data in the Premium CLI, as well as several linter enhancements and more.
Skeema v1.9.0 has been released! This new version includes support for environment variables in option files, temp-schema workspace offloading in Premium CLI, improved ignore regex options, and support for this month’s new MariaDB releases including MariaDB 10.10.
When running database servers on multiple operating systems, data and schema portability can be a challenge, due to differences in identifier case sensitivity. The lower_case_table_names server variable in MySQL and MariaDB can help, but it is often misunderstood. In this post, we’ll provide in-depth guidance on this tricky subject, and show how Skeema’s linter can assist.
Skeema v1.8.0 is now available! This new release adds support for non-Linux database servers, SSH tunnels in the Premium CLI, and MariaDB 10.8 support.
AWS unveiled Aurora v3 a couple months ago, finally including support for MySQL 8 in their premium database-as-a-service offering. In this post, we’ll review some of its functionality, with a focus on DDL functionality and schema design.
Skeema v1.7.0 has been released! This new version adds support for Aurora MySQL 8 and MariaDB 10.7, 64-bit Linux ARM builds, self-update functionality in the Premium CLI, and more.
Skeema v1.6.0 is now available! This release adds new SSL / TLS options; premium improvements for routines, views, and triggers such as definer stripping; and new builds for M1 Macs and packages for Alpine Linux.
Converting your database to a different character set can be a difficult and perilous process. In this post, we’ll cover several ways that Skeema can help simplify this task.
We are pleased to announce the release of the Premium edition of the Skeema CLI, with support for views, triggers, AWS Aurora, native Windows build, and more!
