For a summary of the most important changes in this release, see our blog post.
- Premium CLI now includes the ability to offload the temp-schema workspace to a different database host, via the new temp-schema-environment option. The option value is set to the name of an environment (.skeema file section) which can override some or all connectivity options (host, port, socket, user, password, host-wrapper, SSH options, SSL options, etc) for determining what host to place the temp-schema workspace on. (#94)
- Connectivity-related options (user, password, host, schema, etc) now support use of environment variables as option values in .skeema option files, permitting flexible dynamic configuration. (16b54e4, #101)
- Improvements to the various ignore-* options (ignore-table, ignore-proc, ignore-func, ignore-view, ignore-trigger)
- The ignore-proc and ignore-func options, which previously were only available in the Premium edition (since v1.6.0-premium one year ago), are now available in the Community edition as well. (0de3c57)
- These options now take effect earlier in the processing flow for all commands. This improves performance, and ensures that any SQL errors from an ignored statement do not affect the execution of the command in any way. (b35f065)
- Several MariaDB-specific improvements and fixes
- MariaDB 10.10 is now fully supported, including special conversion logic for the new
inet4column type. (53de093) - MariaDB's November 2022 point releases (MariaDB 10.3.37, 10.4.27, 10.5.18, 10.6.11, 10.7.7, 10.8.6, 10.9.4) are now supported by Skeema. These MariaDB releases unexpectedly changed the output logic for collations in SHOW CREATE TABLE, which broke compatibility with a core safety check in Skeema. (f2dcaf8, #193, #194, #195)
- When modifying existing procs/funcs in MariaDB, atomic CREATE OR REPLACE syntax is now used. This functionality was originally introduced in Skeema v1.6.0-premium one year ago, but is now present in the Community Edition as well. (412a326)
- MariaDB 10.10 is now fully supported, including special conversion logic for the new
- When interacting with multiple hosts (running
skeemafrom a parent directory), it is now possible to interactively prompt for different passwords for each host, by configuring the bare password option with no=valuein the same .skeema file as the host. (ab4a84c, 5e35143, b004616)- Previously, bare password option with no
=valuewas only supported in global option files. This still works, and still prompts for a single "global" password rather than host-specific ones. - For an alternative mechanism for passing different passwords to each host, also see the new ENV variable support, mentioned above.
- Previously, bare password option with no
- When using workspace=docker with MySQL 8, whenever Skeema creates a new ephemeral containerized DB, binary logging will be disabled automatically, despite MySQL 8 normally defaulting to enabling binlogging. This improves workspace performance, and prevents potential issues with non-deterministic CREATE FUNCTION definitions. (2804a44)
An installation guide and full documentation are available on our website skeema.io.