This Homebrew tap provides a formula for Sqitch, a database schema development and change management system. If you'd like to try Sqitch and use Homebrew, this will be the simplest way to get it installed so you can get to work.
First, use this command to set up the Sqitch Homebrew tap:
brew tap sqitchers/sqitchNow you can install Sqitch with your choice of database support:
brew install sqitch --with-postgres-support --with-sqlite-supportIf you see an error about missing headers on Mojave, like
fatal error: 'EXTERN.h' file not found, install the headers like so and try
again:
sudo installer -pkg /Library/Developer/CommandLineTools/Packages/macOS_SDK_headers_for_macOS_10.14.pkg -target /Mix and match support as you prefer via the following options:
brew install sqitch --with-postgres-supportSupport for managing PostgreSQL,
CockroachDB, and
YugabyteDB databases. This feature
optionally depends on the Homebrew libpq formula, both to build the
necessary database driver at build time, and to use psql client to manage
databases at runtime. It does not install the Homebrew PostgreSQL server.
If you have your own PostgreSQL client library install and don't need the Homebrew instance, you might need to tell the installer where to find things. To quote from the DBD::Pg README:
By default Makefile.PL uses App::Info to find the location of the PostgreSQL library and include directories. However, if you want to control it yourself, define the environment variables
POSTGRES_INCLUDEandPOSTGRES_LIB, or define justPOSTGRES_HOME. Note that if you have compiled PostgreSQL with SSL support, you must define thePOSTGRES_LIBenvironment variable and add "-lssl" and "-lcrypto" to it, like this:export POSTGRES_LIB="/usr/local/pgsql/lib -lssl -lcrypto"
If, for example, you use pgenv to install PostgreSQL on your system, you'd need to export something like:
export POSTGRES_LIB="$HOME/.pgenv/pgsql/lib -lssl -lcrypto"
export POSTGRES_INCLUDE="$HOME/.pgenv/pgsql/include"Then build with --with-std-env to ensure that Homebrew will use the
environment variables:
brew install sqitch --with-std-env --with-postgres-supportbrew install sqitch --with-sqlite-supportSupport for managing SQLite databases. This feature
optionally depends on the Homebrew SQLite build for the use of the sqlite3
client at runtime.
brew install sqitch --with-mysql-supportSupport for managing MySQL databases. This feature
optionally depends on the Homebrew mysql-client formula, both to build the
necessary database driver at build time, and to use the mysql client to
manage databases at runtime. It does not install the Homebrew MySQL server.
brew install sqitch --with-firebird-supportSupport for managing Firebird databases. This
feature depends on the presence of a Firebird database installation, both to
build the necessary database driver at build time, and to use the isql client
to manage databases at runtime. Alas, there appears to be no Homebrew formula
for Firebird, so you'll have to manually
download and install it
before installing Sqitch with Firebird support. If no Firebird driver library is
found, the build will fail.
export HOMEBREW_ORACLE_HOME=/oracle/instantclient_12_2
brew install sqitch --with-oracle-supportSupport for managing Oracle databases. This feature depends on the presence of the Oracle Instant Client Basic and SDK packages to build the necessary database driver at build time, plus the SQL*Plus package to manage databases at runtime. If no Instant Client files are found, the build will fail.
Sadly, System Integrity Protection
must be disabled in order to build Sqitch with Oracle support. This is to allow
the setting of the $DYLD_LIBRARY_PATH environment variable, which is required
for Oracle support in Sqitch.
Here's how.
With SIP disabled, set $HOMEBREW_ORACLE_HOME to the full path to the directory
for Instant Client. This will allow the build to find the libraries necessary to
complete the build with Oracle support. To use Sqitch with Oracle, you will
need to set the $ORACLE_HOME and $DYLD_LIBRARY_PATH variables to point to
the Instant Client, something like:
export ORACLE_HOME=/usr/local/instantclient_12_2
export DYLD_LIBRARY_PATH=$DYLD_LIBRARY_PATH:$ORACLE_HOMEbrew install sqitch --with-vertica-support
Support for managing Vertica databases. This
feature depends on the presence of the Vertica ODBC driver and the vsql
client in order to manage Vertica databases. You will need to
download and
install the ODBC and vsql packages for macOS prior to using Sqitch to
manage Vertica databases.
Furthermore, the Sqitch Vertica build optionally requires the Homebrew
libiodbc package to build the ODBC driver.
brew install sqitch --with-exasol-supportSupport for managing Exasol databases. This feature
depends on the presence of the Exasol ODBC driver and the EXAplus client in
order to manage Exasol databases. You will need to
download and install the ODBC
and EXAplus packages for macOS prior to using Sqitch to manage Exasol databases.
Furthermore, the Sqitch Exasol build optionally requires the Homebrew libiodbc
package to build the ODBC driver.
brew install sqitch --with-snowflake-supportSupport for managing Snowflake databases. This
feature depends on the presence of the Snowflake ODBC driver and the snowsql
client in order to manage Snowflake databases. You will need to download,
install and configure the
ODBC driver and
SnowSQL
client prior to using Sqitch to manage Snowflake databases.
Furthermore, the Sqitch Snowflake build optionally requires the Homebrew
libiodbc package to build the ODBC driver.
brew install sqitch --with-std-envPrefer versions of dependencies found in the path, even if they're not installed by Homebrew. Essential if you want to use a library or database client that is not installed by Homebrew and does not come with the system.
brew install sqitch --HEADJust want the latest from Git? Use the --HEAD option to clone Sqitch, install
configure-time dependencies in a temporary directory, and build Sqitch from the
main branch.
brew install sqitch --develSometimes a pre-release version of Sqitch might be available for installation.
If so, the --devel option will build and install it.
brew install sqitch --verboseTurn on verbosity. Useful to get additional information in the event of installation issues.
Turn off most output.
The Sqitch Homebrew Tap formula is distributed as public domain software. Anyone is free to copy, modify, publish, use, compile, sell, or distribute the original Sqitch Homebrew Tap formulas, either in source code form or as a compiled binary, for any purpose, commercial or non-commercial, and by any means.