GizmoData

MotherDuck + DuckDB SF Meetup is back, May 21. Three talks: • Philip Moore (GizmoData) on GizmoSQL: wrapping DuckDB with Arrow Flight SQL so it runs as a server anywhere, including on an iPhone • Michael Driscoll (Rill Data) on rebuilding Rill Cloud around Quack, DuckDB's new client-server protocol, and what it does to the dev loop • Eddie A. Tejeda (HotData) on a DataFusion extension for DuckLake Co-hosted with Greybeam. RSVP: luma.com/motherduckdckd…

That was fast! @GizmoData777 already pushed out an ADBC driver for Quack. Get that multi client DuckDB concurrency along with reading as Arrow. @mim_djo approved! github.com/gizmodata/adbc…

@mim_djo x.com/GizmoData777/s…

Same feeling, they keep breaking my heart

We just shipped experimental ADBC and JDBC drivers for the new Quack DuckDB protocol - check them out here: JDBC: github.com/gizmodata/quac… ADBC: github.com/gizmodata/adbc…

@_Felipe @HoytEmerson We just shipped experimental JDBC and ADBC drivers! JDBC: github.com/gizmodata/quac… ADBC: github.com/gizmodata/adbc…

@HoytEmerson None, to my disappointment. It’s a DuckDB<->DuckDB communication protocol. An idea: wrap the client in an ADBC driver. The driver would convert DuckDB vectors to Arrow. Now have an ADBC driver talking to a quack server and usable from any language with an Arrow impl.

With DuckDB's Quack (really don't like that name) now in beta, the question worth asking is what does it possibly replace? 1. Apache Arrow Flight 2. Postgres 3. Files on storage buckets 3. Custom server-client builds What else should I be thinking about here 🤔

You think you've seen it all with DuckDB and then @GizmoData777 goes and makes an iOS app that let's you run it on an iPhone. Article and Video: open.substack.com/pub/thefulldat… youtu.be/LiAKzVLbIyw?si…

GizmoData is excited to announce the launch of GizmoSQL iOS edition! With this new app, users can easily run a GizmoSQL server directly from their iPhone and connect to it from a computer on the same local network using ADBC, JDBC, ODBC, nodeJS, and GizmoSQL-UI clients. This edition is perfect for prototyping, development, and learning how to operate and query a GizmoSQL Arrow Flight SQL server, powered by DuckDB. It also includes the DuckLake, httpfs, and TPC-H extensions, allowing you to carry your data lake in your pocket. The app shares the same code as the full GizmoSQL server, ensuring a seamless transition for client applications. Check it out today! apps.apple.com/us/app/gizmosq… #gizmosql #iOS #duckdb #arrow #flight #sql #ducklake #mobile

New on the GizmoData blog: "Freeing the Individuals from the Matrix" Chris Harrison built something fascinating — a Matrix-themed simulation of one million people, all living inside a GizmoSQL database, being silently manipulated by automated agents every 30 seconds. Then he pointed Claude at it. The AI agent connects over Arrow Flight SQL, writes its own queries, and autonomously hunts for anomalies — geographic clusters of spiking bioelectric readings, individuals hitting age caps, patterns no human would catch scanning a million rows. The best part? The AI agent connects the exact same way as every other client. Same protocol, same port, same credentials. No special middleware. No REST wrapper. Just SQL. That's what "AI-agent ready" actually means in practice. What's inside: - Full project architecture with GizmoSQL running natively on Windows - Claude tool use for autonomous database monitoring - Real cost analysis (~$5 for 30 min with Opus 4.6) - Why row count barely affects AI agent costs Read the full post: gizmodata.com/blog/freeing-i… Source code: github.com/virtualninjach… #GizmoSQL #AI #DuckDB #ApacheArrow #DataEngineering #Claude #AIAgents

🚀 Announcing the GizmoSQL ODBC Driver Not every application speaks modern data APIs. While ADBC and JDBC power most new integrations with GizmoSQL, a huge number of enterprise and legacy applications still rely on ODBC to connect to data sources. And honestly… that’s perfectly fine. ODBC may not be the coolest kid in the room, but it still gets a lot of real work done. So today we’re excited to introduce the GizmoSQL ODBC Driver, enabling legacy applications to connect directly to: GizmoSQL - a powerful DuckDB server built with Arrow Flight SQL Under the hood, the driver is built on Apache Arrow v23, enabling columnar zero-copy data transfer between the client and server for efficient analytics workloads. The driver was originally forked from Dremio’s ODBC driver, with a number of enhancements added for modern enterprise deployments: • OAuth / SSO authentication • Primary key / foreign key schema detection • Auto-commit support • Hierarchical catalog/schema/table inspection • Bind parameter support • TLS root certificate discovery • Cross-platform CI builds • Extensive integration testing So go ahead - get crazy with Excel sheets pulling from GizmoSQL in real-time! And yes — GizmoSQL plays well with the cool kids too. Modern applications can connect using ADBC or JDBC, both fully supported. In fact, GizmoData recently contributed the bulk ingestion capability to the ADBC Flight SQL driver, making it easy to load millions of rows directly into Arrow Flight SQL servers like GizmoSQL. Sometimes the future needs a bridge. ODBC driver repo: github.com/gizmodata/gizm… GizmoSQL homepage: gizmodata.com/gizmosql #DuckDB #ApacheArrow #ODBC #ADBC #DataEngineer

The GizmoSQL Power BI Connector is now available! This connector allows seamless integration of Power BI Desktop with GizmoSQL, enabling you to remotely and securely query your DuckDB database files, DuckLake, Iceberg tables, Delta Lake, and more. For users with GizmoSQL Enterprise Edition, you will benefit from OAuth2/Single-Sign On integration, enhanced catalog security, instrumentation features, and additional capabilities. GizmoSQL offers a powerful DuckDB server with strong security, performance, and integrations. Explore the adapter here: github.com/gizmodata/gizm… Comment "GIZMO" for a demo.

GizmoSQL is now available for Windows customers. This open-source Arrow Flight SQL Server, powered by DuckDB, efficiently runs terabyte-scale SQL and PySpark workloads at a cost savings of 75% or more compared to Snowflake or Databricks. Upgrade to Enterprise Edition for Single Sign-on, telemetry, instrumentation, and more. For more details, check out our latest release notes and download artifacts here: github.com/gizmodata/gizm… #GizmoSQL #Windows #DuckDB #Arrow #Flight

We just published ADBC Flight SQL 1.10.0: Bulk Ingestion for GizmoSQL medium.com/p/adbc-flight-…

A brief look at GizmoSQL, a small server that runs DuckDB, with the Arrow Flight SQL protocol wrapped around it so that you can run DuckDB remotely. - hackernoon.com/what-the-heck-… #duckdb #apachearrowecosystem

My new blog on @hackernoonhq is getting a lot of attention. hackernoon.com/what-the-heck-…

Check out the cool new @hackernews article by @ProgRockRec about #GizmoSQL: hackernoon.com/what-the-heck-…

🚀 Sharded DuckDB just processed 1 trillion rows in 5 seconds across 63 nodes! The DuckLake format is pushing the boundaries of distributed analytics. #HackerNews #Tech gizmodata.com/blog/gizmoedge…