GizmoEdge – Distributed IoT SQL Engine
GizmoEdge – Distributed IoT SQL Engine
Hi, I'm Philip Moore - the founder of GizmoData, and creator of GizmoEdge - a Distributed SQL Engine powered by Internet-of-Things (IoT) devices. GizmoEdge is a prototype application - that allows you to run SQL queries that get distributed to many devices - including: Linux, macOS, iOS, iPadOS, Kubernetes Pods, Raspberry Pis, and more. I've built a front-end application from which you can issue distributed SQL queries - here: https://gizmoedge.gizmodata.com If you have an Apple device - you can install the GizmoEdge Worker app to have it "join the collective" - here is the App Store link: https://apps.apple.com/us/app/gizmoedge/id6738658135 Once you install the app, you just connect it up to the running GizmoEdge server - and it will download a shard of TPC-H data at the 1GB foot-print (it is actually smaller, b/c it is compressed parquet - in a ZStandard-compressed tarball). The app will then create a DuckDB database from the parquet datasets that are on your device. Right now - queries will only run on your device if the app is open and in the foreground. To connect your device to the server - click the little blue "server" icon just to the right of the GizmoData logo at the top of the screen - the username, password, etc. are pre-filled for you - just click the blue: "Connect WebSocket" button at the bottom to get started. When you issue a SQL query that is eligible for distribution from the GizmoEdge SQL app (at https://gizmoedge.gizmodata.com ) - it should distribute and execute on your device (among others) in the collective, provided that they have downloaded a shard of data and are connected to the server. I would be honored if folks tried the engine. Please bear in mind - this is a prototype - it isn't production ready, yet. It is currently read-only as well - but I'm working on a way to make it easy for folks to ingest data for distributed SQL execution in the near-future. GizmoEdge is powered by DuckDB on the workers, and uses WebSockets for low-latency connections between the server and workers. It uses TLS for encryption of communication - and has a robust security model - in which the server and workers have a "trust-but-verify" relationship. Getting started: GizmoEdge SQL Navigator app (run interactive SQL queries here): https://gizmoedge.gizmodata.com GizmoEdge Worker on the App Store: https://apps.apple.com/us/app/gizmoedge/id6738658135 GizmoEdge homepage: https://gizmodata.com/gizmoedge Thank you for your time and feedback - in advance!
Share cardActual performance
Launch Intel predictions
Analyze your own launch →Incorrect prediction on native model
Similar products
Squirreling: a browser-native SQL engine
Timeplus Proton 3.0 – First vectorized streaming SQL engine
I Solved N Queens in SQL
Lithium::SQL C++17, Header Only MySQL and SQLite Connectors and ORM
Go Fearless SQL
Mongita is to MongoDB as SQLite is to SQL
SQL Basics
Querying OpenAPI Definitions with SQL
YAML to SQL
can we get rid of SQL?