The GizmoData Dispatch - February 2026 Edition
2026 is heating up!
Happy February, GizmoData community! 👋 We hope your new year is off to a great start. We’ve been hard at work since the holidays, and this edition is packed with exciting updates across the GizmoData ecosystem. Let’s dive in!
🚀 GizmoSQL Updates
GizmoSQL is our open-source, high-performance SQL engine powered by DuckDB and Apache Arrow Flight SQL. It lets you run DuckDB remotely with blazing-fast Arrow-native data transfer, full TLS/mTLS security, and seamless integration with tools like Python, DBeaver, and Tableau.
⬆️ DuckDB v1.4.4 Upgrade
GizmoSQL now runs on DuckDB v1.4.4, bringing all the latest performance improvements and bug fixes from the DuckDB team.
🗺️ Native Geospatial Support (v1.15.1)
Spatial data users rejoice! GizmoSQL now includes built-in support for geospatial data:
GEOMETRY Type - Native spatial data type support
100+ Spatial Functions - Full suite of geospatial operations
GeoArrow Export - Efficient Arrow-native transport of geospatial data through Flight SQL
GeoPandas Integration - Seamless Python geospatial workflows
📚 New Documentation Site
We’ve launched a brand new documentation site with improved navigation and comprehensive guides:
🔐 Token Authentication Guide - Step-by-step instructions for configuring token-based auth
🦆 DuckLake Integration Documentation - Complete guide to setting up and using DuckLake with GizmoSQL
🐧 Linux Homebrew Support - Our Homebrew tap now supports Linux in addition to macOS
☕ JDBC Driver v1.4.1
We’ve released JDBC Driver v1.4.1 with updated download links and improved compatibility. Our custom JDBC driver supports server-side query cancellation—a feature not available in the base Arrow Flight SQL JDBC driver. This means tools like DBeaver can actually cancel long-running queries instead of just disconnecting!
The driver is now available on Maven Central under our new com.gizmodata namespace. We’ve also updated gizmosqlline—our command-line SQL client—to use the new driver.
👉 Maven Central | Documentation
🖥️ Introducing GizmoSQL UI
We’re excited to announce GizmoSQL UI—a web-based SQL interface that makes working with GizmoSQL servers a breeze! No more fiddling with command-line tools or complex setup.
Features include:
🔌 Connection Management - Connect to GizmoSQL servers with TLS and authentication support
✏️ Monaco SQL Editor - Syntax highlighting and autocomplete powered by the same editor as VS Code
📊 Results Grid - View query results in a responsive table with type-aware formatting
🗂️ Schema Browser - Browse catalogs, schemas, tables, and columns
📤 Export Options - Export results to CSV, TSV, JSON, or Parquet formats
Install via Homebrew and you’re up and running:
brew install gizmodata/tap/gizmosql-ui
gizmosql-ui
🧩 Adapter Ecosystem Growth
The GizmoSQL adapter ecosystem continues to expand, making it easier to plug GizmoSQL into your existing data stack:
SQLMesh Adapter - Use GizmoSQL as a backend for your data transformation pipelines. SQLMesh is a modern alternative to dbt, and now you can leverage GizmoSQL’s speed for your SQL-based data modeling workflows.
PySpark SQLFrame Adapter - Write familiar PySpark DataFrame code, but execute it against GizmoSQL instead of Spark. Perfect for teams who want GizmoSQL’s performance without rewriting their existing PySpark pipelines.
🔧 Bug Fixes & Improvements
Fixed connection mutex issue to allow multiple cursors per connection
Improved catalog access propagation and instrumentation schema checks
Enhanced system info logging capabilities
🏢 GizmoSQL Enterprise Edition
We’re excited to announce that GizmoSQL Enterprise Edition is now available! 🎉 Built for production deployments, Enterprise Edition adds powerful features on top of our free, open-source Core Edition.
✨ Enterprise Features
📊 Session Instrumentation & Auditing Track server instances, client sessions, SQL statements, and query executions. All records are stored in DuckDB for analysis and auditing, with built-in views like active_sessions, session_activity, and session_stats.
🦆 DuckLake-Backed Instrumentation New in v1.16.0! Capture and analyze query metrics directly within a DuckLake catalog, providing deeper insights into your workload performance and usage patterns. For organizations with multiple GizmoSQL instances - this feature lets you centralize telemetry data - for easy reporting of performance characteristics across your infrastructure.
⚡ KILL SESSION Command Terminate active client sessions via SQL with KILL SESSION '<session-id>'. Perfect for managing runaway queries or rogue connections. Requires admin role.
🔒 Per-Catalog Permissions Fine-grained access control via bootstrap tokens. Use the catalog_access JWT claim to grant read, write, or no access to specific catalogs on a per-user basis.
💰 Pricing
Core Edition - Free forever (Apache 2.0 open-source)
Enterprise Edition - $500/mo per server with priority support
Enterprise+ - Custom pricing for volume discounts and SLAs
👉 Learn more about GizmoSQL editions
🎤 DuckDB Developer Meeting - Amsterdam
Philip Moore presented “GizmoEdge: A distributed DuckDB engine for IoT” at the inaugural DuckDB Developer Meeting #1 in Amsterdam on January 30th! 🇳🇱 It was fantastic to connect with the DuckDB community and share our vision for distributed analytics at the edge.
📺 The talk is now available on YouTube - watch it here!
🌐 GizmoEdge Progress
GizmoEdge is our distributed SQL engine that brings warp-speed analytics to the edge. It coordinates fleets of lightweight DuckDB workers across devices, regions, and clouds—enabling real-time queries over distributed data without the need for centralized ETL.
Recent highlights include:
➗ Distributed Query Handling for AVG Aggregates - Proper distributed computation of average functions across edge nodes
🐍 Python 3.14 Support - Keeping pace with the latest Python releases
📦 We’ve shipped over a dozen releases since December, now at v0.0.126
Our early access program is still open - if you’re interested in bringing analytics to the edge, let us know!
📝 Blog & Guest Articles
⚡ ADBC Flight SQL 1.10.0: Bulk Ingestion for GizmoSQL
The new ADBC Flight SQL Python driver 1.10.0 brings bulk ingestion to Arrow Flight SQL servers like GizmoSQL. Load millions of rows directly from Python or DuckDB with automatic schema inference. 👉 Read more
✍️ Guest Articles
We’re grateful for the community voices helping spread the word about GizmoSQL:
🤔 “What the Heck is GizmoSQL?” by Shawn Gordon - A deep dive into what makes GizmoSQL tick, originally published on HackerNoon. Read it
☸️ “Introducing GizmoSQL Operator” by Nima Khoshini - Learn about the GizmoSQL Kubernetes Operator and how it reduces operational costs for large-scale SQL queries. Read it
💬 Customer Spotlight
We’re thrilled to have production customers trusting GizmoSQL for their critical data infrastructure! 🙏
“Since partnering with GizmoData, we’ve gone live in production with one of our primary customers. GizmoSQL has become a critical part of our infrastructure, and we look forward to continuing the partnership.”
— Hema Nagarajan, Director of Engineering at Summation
“GizmoSQL fits right into our stack — performant, flexible, and reliable. It’s a key piece of how we deliver unified observability at Randoli.”
— Rajith Attapattu, Founder & CTO at Randoli
🧠 Upstream Contributions
We’re proud to continue contributing to the open-source ecosystem:
Apache Arrow ADBC
📥 Bulk Ingest Support for Go Flight SQL Driver (PR #3808) - Our contribution enables efficient bulk data loading through the Go ADBC Flight SQL driver
🐍 Python Cursor Close Fix (PR #3810) - Improved resource cleanup in the Python driver manager
These contributions help strengthen the entire Arrow Flight SQL ecosystem that GizmoSQL builds upon.
☁️ Coming Soon: GizmoData Cloud Data Platform
We’re building a fully managed GizmoSQL hosting platform with additional enterprise features:
📁 Full catalog support
👥 Organization management
📝 SQL Worksheets
🐍 Python notebooks
📊 Data visualization
🛟 24/7 support
Interested? 👉 Join the waitlist!
💡 Looking Ahead
We have an exciting roadmap for Q1 2026, including continued GizmoEdge development, additional DuckLake integrations, and the Cloud Data Platform. Stay tuned!
Thank you for being part of the GizmoData community. As always, we’d love to hear your feedback and use cases. 💙
Until next time,
The GizmoData Team
Want to stay updated? Subscribe to The GizmoData Dispatch for monthly updates on GizmoSQL, GizmoEdge, and the broader data ecosystem. ✉️
It's interesting how comprehensive these updates are. Thank you for this detailed overview; the advancments in GizmoSQL, especially geospatial support, are truly significant. Very well structured and insightful.