Skeema 1.11 released
Skeema v1.11 has been released! This new version includes spatial index support, safe trigger DDL operations with table locking, new options to ignore some types of table differences, and additional safety guardrails.
MySQL vs MariaDB: Tables and DDL
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 released
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 released
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.
Understanding MySQL's lower_case_table_names
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 released
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.
Exploring AWS Aurora v3 for MySQL 8
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 released
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 released
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.
Safely switching MySQL charsets using Skeema
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.