{"repo":"gizmodata/ibis-gizmosql","free":true,"listed":false,"github":"https://github.com/gizmodata/ibis-gizmosql","clone":"git clone https://github.com/gizmodata/ibis-gizmosql.git","description":"An Ibis back-end for the GizmoSQL Arrow Flight SQL Server (with the DuckDB engine)","language":"Python","stars":17,"topics":["database","duckdb","ibis","python","sql","gizmosql","gizmodata"],"license":"Apache-2.0","category":"databases-storage","readme_excerpt":"ibis-gizmosql An Ibis back-end for GizmoSQL [!NOTE] As of v1.1.0 - ibis-gizmosql runs on adbc-driver-gizmosql 2.0 - powered by the new native Go GizmoSQL ADBC driver. The Python API is unchanged - and the shared Go driver library (used across all languages) provides DDL/DML immediate execution, RETURNING support, gizmosql:// URIs, and OAuth/SSO. Setup (to run locally) Install Python package You can install ibis-gizmosql from PyPi or from source. Option 1 - from PyPi Option 2 - from source - for development Note For the following commands - if you running from source and using --editable mode (for development purposes) - you will need to set the PYTHONPATH environment variable as follows: Usage In this example - we'll start a GizmoSQL server with the DuckDB back-end in Docker, and connect to it from Python using Ibis. First - start the GizmoSQL server - which by default mounts an empty in-memory database. We use the INIT SQL COMMANDS env var in the docker command to create a very small TPC-H database upon startup: [!IMPORTANT] The GizmoSQL server must be started with the DuckDB (default) back-end. The SQLite back-end is not supported. Next - connect to the GizmoSQL server from Python using Ibis by running this Python code: You should see output: OAuth/SSO Authentication For browser-based OAuth/SSO, use auth type=\"external\" — no username or password needed: Or via URL: Additional OAuth parameters: Parameter URL Param Default Description --- --- --- --- auth type authType \"passw","default_branch":null,"files":null,"tree":[],"storefront":"/r/gizmodata","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/gizmodata/ibis-gizmosql/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}