October 29, 2025
SQL meets soap opera
Show HN: SQLite Graph – Graph database with Cypher queries (alpha, but working)
Weekend hack turns trusty SQLite into a graph brain; cheers, side-eye, and ELI5s
TLDR: An alpha add-on makes SQLite handle graph-style relationships using Cypher, like mapping who-knows-whom. The comments split: some cheer the hacker spirit and speed claims, others ask ELI5 how it works and argue to build on existing tools, making this a buzzy experiment, not production-ready.
SQLite just got a wild upgrade: an alpha extension that turns the tiny, everywhere database into a graph—think social-network-style connections—complete with Cypher (a query language for relationships). The devs dropped SQLite Graph, boasting basic features, big speed numbers, and a warning: alpha, not for production.
Commenters showed up with energy. One dev flexed: “Nothing says weekend project like writing a Cypher planner from scratch in C99,” while also plugging AgentML. Others went full “Explain Like I’m 5,” asking if this is basically tables that model edges and nodes—and whether queries are just being transformed into SQL under the hood. Translation: users want clarity on how the magic happens, not just shiny benchmarks.
The spice? A friendly-but-firm nudge from open-source fans: why build from scratch when mature local graph projects (like Kuzu) exist? That lit the classic debate: fresh invention vs. standing on giants’ shoulders. Some cheered the audacity and pure hacker vibes; others worried about fragmentation and future maintenance. Meanwhile, meme energy bubbled around “weekend C99” and “do not use in production,” with folks joking this is Neo4j vibes in a .so.
Bottom line: bold idea, alpha chaos, and a crowd split between hype and healthy skepticism. Watch this space.
Key Points
- •SQLite Graph v0.1.0-alpha.0 adds graph capabilities to SQLite with basic Cypher support and is not recommended for production use.
- •Working features include CRUD operations on nodes/edges via SQL, CREATE/MATCH patterns, WHERE filtering, and a full execution pipeline.
- •The project passes 70/70 CREATE TCK tests for openCypher compliance and integrates graph data via SQLite virtual tables.
- •Performance claims exceed 300K nodes/sec and 390K edges/sec; Python 3.6+ bindings, thread-safety fixes, and security protections are provided.
- •In-progress features target advanced Cypher querying, more algorithms, property indexing; the roadmap aims for full openCypher compliance, optimization, and distributed queries.