Project ideas from Hacker News discussions.

Show HN: LatticeDB – Like SQLite but for graph databases

📝 Discussion Summary (Click to expand)

1. LLMs as a development aid (with caveats)
- “I used LLMs extensively in building this… They often write superficial tests. Sometimes a suite of tests would pass, but when I would actually play around with the feature it was clearly broken.” – smiths1999
- “I spent a lot of time initially going back and forth with claude on the idea… In the later stages… I would spend more time discussing, instructing, and verifying, but less time understanding the actual implementation.” – smiths1999

2. Real‑world use‑cases and ecosystem fit
- “One of the motivating use cases for me was experimenting with agentic memory. I use latticedb as the backing data store. Finding related memories is traversing the graph (kind of like graph RAG).” – smiths1999
- “duckpgq is great… latticedb when graph traversal is the primary mechanism of querying.” – smiths1999
- “I wonder about mapping RDF data (like Wikidata) to this… Yes! This is something I've been thinking about quite a bit.” – smiths1999 replying to tomComb
- “The permissions question is interesting… One approach would be to create some edge types hasAccessTo and accessibleBy…” – smiths1999 answering k9294

3. Design choices, performance, and operational concerns
- “I did some perf benchmarking with 1M nodes but I'm mostly using it at smaller scales… Most interesting part is a tough one… writing to disk had a lot more complexity to it than I initially anticipated.” – smiths1999
- “Within the same process it's enforced at the db level… we don't have a mechanism in place to manage safety across processes. Will add a file lock mechanism tonight.” – smiths1999 replying to vladigtr
- “I am in the final stages of adding [hot copy] based on your comment… will push a new release with hot copy functionality tonight!” – smiths1999 answering itissid
- “They are very similar in the single‑file, graph db respect. But lattice is transactional and row oriented while kuzu is columnar.” – smiths1999 responding to nrjames about why he didn’t fork Kuzu.


🚀 Project Ideas

LatticeSync – Live Backup & Restore for Embedded Graph Databases

Summary

  • Provides litestream‑style WAL archiving and hot‑copy for single‑file graph DBs like LatticeDB.
  • Enables zero‑downtime backups to S3, GCS, or local storage with point‑in‑time restore.

Details

Key Value
Target Audience Developers deploying LatticeDB or similar embedded graph DBs in production
Core Feature Continuous write‑ahead log capture and immutable snapshot upload with restore CLI
Tech Stack Go (or Rust) daemon, WAL parsing library, AWS SDK, Cobra CLI
Difficulty Medium
Monetization Hobby

Notes

  • "itissid: Does it have something like litestream to back it up for specific production usecases? ... smiths1999: I am in the final stages of adding this based on your comment."
  • Enables reliable production use of embedded graph DBs, opening doors for agentic memory apps and edge deployments.

GraphPerm – Policy Engine for Subtree Permissions in Graph Databases

Summary

  • Allows modeling of hierarchical access (e.g., user → document → children) via declarative rules and automatic subtree traversal.
  • Generates efficient permission‑checking queries and middleware for any graph DB backend.

Details

Key Value
Target Audience SaaS builders and internal tool developers needing workspace‑style permission models
Core Feature DSL (YAML/JSON) to define edge types like hasAccessTo, childOf and compile to graph traversal checks
Tech Stack TypeScript (or Rust) library, pluggable adapters for LatticeDB, Neo4j, etc.; optional Wasm module
Difficulty Medium
Monetization Hobby

Notes

  • "k9294: … how would you recommend modeling a hierarchical access system in a graph database? … smiths1999: One approach would be to create some edge types hasAccessTo and accessibleBy …"
  • Provides a reusable solution that reduces boilerplate and errors in permission logic, encouraging adoption of graph DBs for multi‑tenant apps.

RDF2Lattice – SPARQL Query Engine Over Embedded Graph Storage

Summary

  • Imports RDF/Triple data (e.g., Wikidata dumps) into LatticeDB while preserving graph semantics.
  • Exposes a SPARQL endpoint that translates to native graph traversals, giving users familiar Semantic Web querying.

Details

Key Value
Target Audience Data engineers and researchers wanting to query large knowledge graphs with SPARQL on a lightweight, file‑based store
Core Feature RDF import pipeline + SPARQL-to-LatticeDB query translator + optional HTTP endpoint
Tech Stack Rust (or Go) with RDF parsing, Arrow/Parquet intermediate, LatticeDB storage; Actix‑web or Gin for HTTP
Difficulty High
Monetization Hobby

Notes

  • "tomComb: I wonder about mapping RDF data (like Wikidata) to this… zvr: If you're going to support RDF, please also consider supporting SPARQL for querying the data."
  • Bridges the gap between semantic web communities and embedded graph DBs, enabling lightweight graph analytics without heavyweight triplestores.

Read Later