9 comments

  • petervandijck24 minutes ago
    Congrats this is really cool and love the examples
  • tescreal44 minutes ago
    I see &quot;Claude&quot; listed as a contributor. Could you describe how and how much? I&#x27;m keen to see how this looks in practise.<p>As for the tool, it scratches an itch I&#x27;ve been having, I&#x27;ll give it a go soon.
    • smiths199934 minutes ago
      I used claude extensively (as well as codex, I finding myself switching between the two every few months). How I used claude varied by the stage. I spent a lot of time initially going back and forth with claude on the idea, figuring out what exists, what would make this interesting, key features I wanted as a user and how to build something around that that made sense as a product.<p>The initial phases of building I would build out piece by piece. For example, building out the file system interactions I would have claude build a feature and explain how it worked in an educational manner (e.g., like it was a section in a book on latticedb internals). I would then read through the code. This was a great way to learn and build, simultaneously.<p>In the later stages, where the features and work was more complex, I would spend more time discussing, instructing, and verifying, but less time understanding the actual implementation. I&#x27;ll give you an example. It&#x27;s been a long time since I&#x27;ve handwritten SIMD code. I could try and review claudes output, but I am certain I&#x27;d miss any subtle bugs that may exist. I found it more productive to assume the code was right and focus on thinking about how I would verify that. Benchmarking, playing with latticedb, etc. were my primary tools for verifying the work. I could run a benchmark and see performance was great. Then I&#x27;d explore the test vectors and realize they were trivial, completely invalidating the benchmark results. So we would go back to the drawing board, create a new benchmark set, see results weren&#x27;t great, and evaluate what was wrong with the implementation. Sometimes features would take days to get out just because of the iteration loop.
  • tomComb38 minutes ago
    I wonder about mapping RDF data (like Wikidata) to this. I guess the RDF predicate becomes the edge in your node-edge style of graph.
    • smiths199933 minutes ago
      Yes! This is something I&#x27;ve been thinking about quite a bit the past few weeks. We are going in this direction at work and I think graph storage is a natural way to think about this.
  • srameshc1 hour ago
    LatticeDB looks good, just curious how useful is duckpgq<p><a href="https:&#x2F;&#x2F;duckdb.org&#x2F;community_extensions&#x2F;extensions&#x2F;duckpgq" rel="nofollow">https:&#x2F;&#x2F;duckdb.org&#x2F;community_extensions&#x2F;extensions&#x2F;duckpgq</a>
    • smiths199957 minutes ago
      duckpgq is great. I&#x27;d say the tl;dr is duckpgq if you have tables you want to traverse like a graph sometimes, latticedb when graph traversal is the primary mechanism of querying.<p>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).
  • ebb_earl_co1 hour ago
    Just read through the README on GitHub and this looks impressive! Kudos
  • vorpalhex2 hours ago
    Thank you for sharing. I think the sqlite-esque local file approach makes sense for a lot of use cases.<p>What are some of the scales of the data you&#x27;ve been able to test this design on so far?<p>What was the most interesting part of designing it for you?
    • smiths19991 hour ago
      I did some perf benchmarking with 1M nodes but I&#x27;m mostly using it at smaller scales for another project exploring agentic memory.<p>Most interesting part is a tough one. From a learning perspective the beginning was incredibly interesting because I was spending a lot of time learning about how other DBs work. Even something as relatively simple as writing to disk had a lot more complexity to it than I initially anticipated.<p>I used LLMs extensively in building this, and the other interesting part was seeing how they failed. I&#x27;ve always been a proponent that tests are no guarantee of quality code, and working with LLMs has only reinforced it. 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. LLMs certainly enabled me to build something of this scope, but it was far from &quot;build a graph DB and notify me when you are done&quot;
  • useiris1 hour ago
    [flagged]
  • anentropic1 hour ago
    See also: <a href="https:&#x2F;&#x2F;ladybugdb.com&#x2F;" rel="nofollow">https:&#x2F;&#x2F;ladybugdb.com&#x2F;</a> &quot;DuckDB for graphs&quot;
    • AgharaShyam42 minutes ago
      Ladybug looks promising after KuzuDB was sunset (acquired by Apple).<p>However, I really miss the content posted by the KuzuDB team on their YouTube channel.
    • smiths19991 hour ago
      I like the aesthetics of this page. Very clean and visually appealing
    • anentropic1 hour ago
      ...turns out they are compared here: <a href="https:&#x2F;&#x2F;docs.latticedb.org&#x2F;comparisons&#x2F;vs-kuzu" rel="nofollow">https:&#x2F;&#x2F;docs.latticedb.org&#x2F;comparisons&#x2F;vs-kuzu</a>