GizmoData Homebrew Tap

This is the official Homebrew tap for GizmoData tools.

Installation

brew tap gizmodata/tap
brew install gizmosql
brew install gizmosql-odbc
brew install gizmosql-ui
brew install gizmosqlline

Or install directly:

brew install gizmodata/tap/gizmosql
brew install gizmodata/tap/gizmosql-odbc
brew install gizmodata/tap/gizmosql-ui
brew install gizmodata/tap/gizmosqlline

Available Formulas

Formula	Description
gizmosql	High-performance SQL server built on DuckDB/SQLite with Arrow Flight SQL
gizmosql-odbc	ODBC driver for GizmoSQL (Arrow Flight SQL)
gizmosql-ui	Web-based SQL interface for GizmoSQL servers
gizmosqlline	Flight SQL command-line client (SQLLine with Arrow Flight SQL driver)

Usage

gizmosql

Start the server:

GIZMOSQL_PASSWORD=tiger gizmosql_server --database-filename /path/to/database.duckdb --username scott

Connect with the client:

gizmosql_client --host localhost --port 31337 --username scott --password tiger --command Execute --query "SELECT 1"

For TLS and authentication options, run gizmosql_server --help or gizmosql_client --help.

gizmosql-odbc

Install the driver:

brew install gizmodata/tap/gizmosql-odbc

The driver library is installed to $(brew --prefix)/lib/libgizmosql-odbc.dylib. Configure it in your ODBC driver manager (iODBC or unixODBC) odbcinst.ini:

[GizmoSQL]
Driver = /opt/homebrew/lib/libgizmosql-odbc.dylib

gizmosql-ui

gizmosql-ui

This starts a local web server at http://localhost:3000 and opens your browser.

gizmosqlline

Interactive mode:

gizmosqlline

Connect directly:

gizmosqlline -u "jdbc:arrow-flight-sql://localhost:31337" -n user -p password

Type !help for available SQLLine commands.

License

Apache-2.0