An Arrow Flight SQL Server with DuckDB or SQLite back-end execution engines
a year ago
- #database
- #arrow-flight-sql
- #duckdb
- GizmoSQL is an Apache Arrow Flight SQL server implementation using DuckDB or SQLite as backend databases.
- Supports authentication via middleware and encrypted connections via TLS.
- Originally forked from sqlflite, now evolved under the Apache 2.0 License.
- Docker image available with pre-setup configurations, including TLS and password settings.
- Can mount custom DuckDB database files; requires DuckDB CLI version 1.3.0.
- Supports initialization SQL commands upon container startup.
- JDBC driver available for connecting to the Flight SQL server.
- ADBC Python Flight SQL driver offers performance advantages over JDBC.
- CLI tool (gizmosql_client) available for connecting and executing commands.
- Supports connecting via Ibis and SQLAlchemy.
- Standalone executable available for Linux and MacOS.
- Manual setup involves building from source, setting up Python environment, and generating sample data.
- Supports both SQLite and DuckDB backends with configurable options.
- Slim Docker image available without Python, requiring manual TLS and database setup.