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 challenging due to identifier case sensitivity differences. 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 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.
Announcing the Premium CLI
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!
Skeema v1.5.0 released
Skeema v1.5.0 has been released! This new version adds diff support for tables with check constraints, and also includes major enhancements to Skeema’s internal connection and query behaviors.