GizmoSQL is a lightweight, high-performance SQL server built on:
- DuckDB or SQLite for query execution.
- Apache Arrow Flight SQL for fast, modern connectivity.
- Middleware-based auth with optional TLS & JWT.
This is free and open source software.
Features include:
- Deploy Anywhere — Run as a container, native binary, or in Kubernetes.
- Columnar Fast — Leverages Arrow columnar format for high-speed transfers.
- Dual Backends — Switch between DuckDB and SQLite at runtime.
- Built-in TLS + Auth — Password-based login + signed JWT tokens.
- Super Cheap Analytics — TPC-H SF 1000 in 161s for ~$0.17 on Azure.
- CLI, Python, JDBC, SQLAlchemy, Ibis, WebSocket — Pick your interface.
Website: github.com/gizmodata/gizmosql
Support:
Developer: GizmoData
License: Apache License 2.0
GizmoSQL is written in C++. Learn C++ with our recommended free books and free tutorials.
| Explore Linux | |
|---|---|
| Best Free and Open Source Software - A huge collection of recommended free and open source software covering every major category. | |
| In-depth Linux Software Reviews - Detailed assessments of Linux software covering features, usability and overall quality. | |
| The Big List of Active Linux Distros - An extensive collection of actively developed Linux distributions. | |
| Open Source Alternatives - Alternatives to software and services from Google, Microsoft, Apple, Adobe, IBM, Autodesk, Oracle and others. | |
| Essential Linux System Tools - Indispensable utilities for monitoring, maintaining and managing Linux systems. | |
| Linux Productivity Tools - Useful utilities for improving productivity and streamlining everyday tasks. | |
| Alternatives to Popular CLI Tools - Modern alternatives to familiar command-line utilities supplied with Linux systems. | |
| Awesome Free Linux Game Tools - Tools, utilities and companion software that improve gaming on Linux. | |
| Machine Learning on Linux - Machine learning and deep learning software, self-hosted applications and practical tools. | |
| Saving Money with Linux - Practical ways to reduce electricity consumption and lower computing costs with Linux. | |
| Linux Candy - Fun, entertaining and sometimes delightfully quirky software from the lighter side of Linux. | |

Please read our Comment Policy before commenting.