skeema

See the Skeema v1.14 release announcement blog post for a summary of the most important changes in this release.

• MySQL 9.7 support (b2f241f, 23b85cd)
  • This is the latest MySQL LTS version series, supported by Oracle for 8 years
  • JSON Duality Views, which are supported in Skeema Premium, can now be made writable
• MariaDB 12.3 support (53b75d1, 831a1d1)
  • This is the latest MariaDB LTS version series, supported by MariaDB for 3 years
  • New column type XMLTYPE for storing XML data
  • Tables partitioned by KEY or LINEAR KEY now support additional ALGORITHM clause values
• Aurora MySQL 8.4 support
  • This is the latest major version of Aurora, released last month
  • Skeema Premium is tested against all major versions of Aurora
  • Aurora 8.4 strictly requires TLS for all connections, so Skeema's SSH tunnel functionality no longer auto-disables TLS when using flavor=aurora:8.4 or when the flavor isn't known yet
• The password and user options now support the ability to shell out to external commands, capturing the STDOUT for use as the password or user value (#101, 9a2b471, f55d539)
  • To enable this functionality, wrap the value in backticks, for example password=`aws secretsmanager get-secret-value --secret-id YOUR_SECRET_ID --query SecretString --output text | jq -r '.password'`
  • The command-line can make use of variables such as {ENVIRONMENT}, {HOST}, etc. See option reference links above for full list.
• The host option now supports the ability to directly shell out to an external command (9617edc)
  • To enable this functionality, wrap the value in backticks, for example host=`/opt/bin/my_custom_lookup_script.sh {ENVIRONMENT}`
  • This is a simpler alternative to host-wrapper for cases where there's no need for lookup keys or a top-level/generic command line
• Additional deprecations ahead of Skeema v2 as per our March blog post (e22f1a9, ba8a923, 8bf1810)
  • MySQL 5.6-5.7 and MariaDB 10.2-10.3 are now deprecated (but still supported in Skeema v1)
  • Support for legacy Intel Macs will be dropped in Skeema v2
  • Mac builds of Skeema v2 will only be supplied as zip files, not tar.gz or dmg
• Flavor detection fallback logic has been improved, to avoid any future conflict around detection of MySQL >9 vs MariaDB 10.x (f453422, 6a76243)
• Skeema Premium bug fix: if the SELECT statement of a view references another view which uses a non-default DEFINER, attempting to use workspace=docker would fail with an error. This now works properly.
• Various internal cleanups, including removal of the sqlx dependency (3277076, 049a284, 7677594, bf0ac07, 1a85ed5)

An installation guide and full documentation are available on our website skeema.io.