Back to browse
GitHub Repository

🚀 GizmoSQL — High-Performance SQL Server

324 starsC++

DuckDB / DuckLake Server (With Arrow Flight SQL) for iOS

by philbe77·Apr 14, 2026·2 points·0 comments

AI Analysis

●●●BangerWizardryZero to One

TPC-H 1GB in 2 seconds on iPhone—Arrow Flight SQL running locally.

Strengths
  • Full DuckDB server with Arrow Flight protocol on iOS is genuinely novel architecture
  • Verified TPC-H benchmarks show real analytical performance on mobile hardware
  • DuckLake mounting enables actual data lake workflows in your pocket
Weaknesses
  • Enterprise features locked behind commercial license limits open-source utility
  • iOS server use case is niche despite impressive technical achievement
Category
Target Audience

Data engineers and mobile developers working with local analytics

Similar To

DuckDB · sqlflite · MotherDuck

Post Description

Hi, I've created an iOS app (GizmoSQL) for running DuckDB as a server (with Arrow Flight SQL).

You can even mount a DuckLake - meaning you can have a "data lake in your pocket".

It is fully secure, and runs the TPC-H 1GB 22-query benchmark in less than 2 seconds on an iPhone 16 Pro Max.

See: https://github.com/gizmodata/gizmosql for more details...

Similar Projects

Data●●Solid

GoldenMatch – 100M-row dedupe on Ray in 213s, no Spark, Arrow-native

Ray-based dedupe at 100M rows without Spark — that's a real architectural choice.

Big BrainShip It
benzsevern
308d ago
Developer Tools●●Solid

Rembus – Distributed Messaging (Julia, Python)

Rembus exposes simple node and rpc primitives (expose/rpc) over a tiny brokerable WebSocket transport, so you can spin up remote functions in minutes. The unusual bit is treating a local DuckDB/DuckLake datalake as a first-class part of the runtime, which makes lightweight local analytics painless; I'd still want to see guarantees (delivery semantics, auth, scaling/benchmarking) before trusting it beyond prototypes.

Niche GemSolve My Problem
attdona
103mo ago