1 Trillion Rows.
5 Seconds.
GizmoEdge aggregated one trillion rows of data in just five seconds — demonstrated live at the DuckDB Developer Meeting in Amsterdam. A distributed fleet of DuckDB workers divides the workload, conquers it in parallel, and streams the answer back before you can reach for your coffee. The result hit #1 on Hacker News — submitted by database performance expert Tanel Poder, and debated by the toughest technical crowd on the internet across 224 points and 136 comments.
Jump straight to the trillion-row aggregation (17:41) from the DuckDB Developer Meeting talk.
Distribute SQL Workloads to Any Device
With GizmoEdge, run federated queries that are distributed and executed by DuckDB workers in the Cloud, Datacenter, or at the edge of your IoT landscape. Use Cloud VMs, Kubernetes Pods, and ambient compute such as MacBooks, iPads, Windows computers, and even iPhones to power your SQL analytics.
Divide-and-Conquer
GizmoEdge allows you to process workloads across a heterogeneous network of hundreds, to thousands of IoT computing devices.
Performance
Using GizmoEdge's patented SQL distribution algorithms, you can run workloads you only dreamed of before. Tap into the virtually unlimited computing resources of IoT.
Skip ETL
Eliminate costly ETL for IoT-generated data. Use powerful computing capabilities at the edge to summarize, filter, join, and aggregate just what you need.
Powered by Industry-Leading Technologies
Harnessing the power of Apache Arrow, DuckDB, Websockets, and military-grade security - you can query, join, aggregate, and filter terabytes of data in seconds, or less.
Apache Arrow
A cross-language development platform for in-memory analytics that enables GizmoEdge to efficiently transfer data between devices with zero-copy sharing and columnar memory layout, improving query speed by up to 100x.
Benefits: Improved data transfer speeds, reduced memory usage, cross-platform compatibility
DuckDB
An in-process analytical database that powers GizmoEdge's SQL engine, allowing complex queries to run directly on edge devices. DuckDB's vectorized execution model delivers near-native performance even on mobile devices.
Benefits: Reduced latency, lower operational costs, efficient resource utilization
Websockets
Enables real-time, bidirectional communication between edge devices and coordinator nodes, with minimal latency and overhead. This allows GizmoEdge to maintain persistent connections for continuous data streaming and work coordination.
Benefits: Real-time data processing, minimal network overhead, resilient connections
Military-grade Security
End-to-end encryption with TLS 1.3, JWT authentication, and a bi-directional trust-but-verify security model to ensure that your distributed computing cluster remains secure and private.
Benefits: Data protection, compliance with security standards, granular access control
Run on Virtually Any Device
You can run GizmoEdge data compute nodes in your cloud's VPC, in Kubernetes, on-premises, and across your employees' or customers' computing devices.
Cloud VMs
On-Premise
Laptops
Mobile
A Revolutionary Distributed Data Computing Platform
Join the IoT Computing Revolution. With GizmoEdge, you can save 80% or more on your cloud computing costs by processing your data workloads at the edge.
GizmoEdge in Action
Watch as we run a workload across a distributed computing network of Kubernetes pods, iPhones, iPads, MacBooks, and more!
GizmoEdge Demonstration
Run GizmoEdge Worker on your Apple device
Download the GizmoEdge app for macOS or iOS to turn your Mac, iPhone, or iPad into a powerful data computing node. Join the distributed computing network and contribute to processing workloads - including your own!
GizmoEdge Videos
See GizmoEdge's distributed computing in action
GizmoEdge at the DuckDB Developer Meeting
Presenting GizmoEdge at the inaugural DuckDB Developer Meeting in Amsterdam.
Taking the Trillion Row Challenge with GizmoEdge 🚀
Watch as GizmoEdge processes 1 trillion rows of data in less than 10 seconds!.
GizmoEdge is your multi-cloud distributed SQL OLAP engine 🚀
GizmoEdge can distribute OLAP SQL workloads to multiple clouds - watch as we leverage Azure, AWS, and GCP workers to divide and conquer a large TPC-H dataset in real-time!
GizmoEdge powers through 10TB in seconds!
GizmoEdge powers through 10TB TPC-H queries in less than 5 seconds.
Introducing GizmoEdge - IoT SQL Revolution 🚀
See how GizmoEdge distributes SQL analytics workloads across ambient compute — including iPhones, MacBooks, Kubernetes pods, and more.
GizmoEdge Articles
Deep dives into the technology powering GizmoEdge
GizmoEdge Takes on the 1 Trillion Row Challenge
October 22, 2025 • by GizmoData Team
What happens when you give a distributed SQL engine a trillion-row dataset? GizmoEdge crushed the Coiled challenge with a 1,000-worker cluster on Azure.