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, I’ll provide in-depth guidance on this tricky subject, and show how Skeema 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!
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.
Skeema’s documentation has received a major overhaul, including a brand new command reference.
Join Skeema’s creator, Evan Elias, for a video discussion on August 11 at 8am PT! The session is part of the DB AMA series, and will include live demos and Q&A.
