Homebrew Formulas for Sqitch
Switch branches/tags
Nothing to show
Clone or download
Permalink
Failed to load latest commit information.
Formula
requirements Require Homebrew Perl. Oct 3, 2018
.gitignore
.travis.yml v0.9998 released, so can test tarball. Oct 3, 2018
README.md

README.md

Sqitch Homebrew Tap

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/sqitch

Now you can install Sqitch with your choice of database support:

brew install sqitch --with-postgres-support --with-sqlite-support

Supported Database Engines

Mix and match support as you prefer via the following options:

--with-postgres-support

brew install sqitch --with-postgres-support
brew install sqitch --with-postgres-support --without-postgresql

Support for managing PostgreSQL databases. This feature optionally depends on the Homebrew PostgreSQL server, both to build the necessary database driver at build time, and to use psql client to manage databases at runtime. If you have your own PostgreSQL install and don't need the Homebrew instance, pass --without-postgresql to prevent Homebrew from installing it.

--with-sqlite-support

brew install sqitch --with-sqlite-support
brew install sqitch --with-sqlite-support --without-sqlite

Support for managing SQLite databases. This feature optionally depends on the Homebrew SQLite build for the use of the sqlite3 client at runtime. If you have your own install or just want to rely on the macOS system-provided SQLite, pass --without-sqlite to prevent Homebrew from installing it.

--with-mysql-support

brew install sqitch --with-mysql-support
brew install sqitch --with-mysql-support --without-mysql

Support for managing MySQL databases. This feature optionally depends on the Homebrew MySQL server, both to build the necessary database driver at build time, and to use the mysql client to manage databases at runtime. If you have your own MySQL install and don't need the Homebrew instance, pass --without-mysql to prevent Homebrew from installing it.

--with-firebird-support

brew install sqitch --with-firebird-support

Support 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.

--with-oracle-support

export HOMEBREW_ORACLE_HOME=/oracle/instantclient_12_2
brew install sqitch --with-oracle-support

Support 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_HOME

--with-vertica-support

brew install sqitch --with-vertica-support
brew install sqitch --with-vertica-support --without-libiodbc

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. If you have your own build of iODBC or unixODBC that you'd rather use, pass --without-libiodbc to prevent Homebrew from installing it.

--with-exasol-support

brew install sqitch --with-exasol-support
brew install sqitch --with-exasol-support --without-libiodbc

Support 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. f you have your own build of iODBC or unixODBC that you'd rather use, pass --without-libiodbc to prevent Homebrew from installing it.

--with-snowflake-support

brew install sqitch --with-snowflake-support
brew install sqitch --with-snowflake-support --without-libiodbc

Support 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. f you have your own build of iODBC or unixODBC that you'd rather use, pass --without-libiodbc to prevent Homebrew from installing it.

Other Options

--HEAD

brew install sqitch --HEAD

Just 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 master branch.

--devel

brew install sqitch --devel

Sometimes a pre-release version of Sqitch might be available for installation. If so, the --devel option will build and install it.

License

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.

Author

David E. Wheeler