Skip to main content

Posts

Featured

Show HN: SQLite Graph Ext – Graph database with Cypher queries (alpha) https://ift.tt/eSW3UTk

Show HN: SQLite Graph Ext – Graph database with Cypher queries (alpha) I've been working on adding graph database capabilities to SQLite with support for the Cypher query language. As of this week, both CREATE and MATCH operations work with full relationship support. Here's what it looks like: import sqlite3 conn = sqlite3.connect(":memory:") conn.load_extension("./libgraph.so") conn.execute("CREATE VIRTUAL TABLE graph USING graph()") # Create a social network conn.execute("""SELECT cypher_execute(' CREATE (alice:Person {name: "Alice", age: 30}), (bob:Person {name: "Bob", age: 25}), (alice)-[:KNOWS {since: 2020}]->(bob) ')""") # Query the graph with relationship patterns conn.execute("""SELECT cypher_execute(' MATCH (a:Person)-[r:KNOWS]->(b:Person) WHERE a.age > 25 RETURN a, r, b ')""") The interesting part was building the complete execution pi...

Latest Posts

Show HN: I Built an LSP and CLI for Ron (Rusty Object Notation) https://ift.tt/BV0wJda

Show HN: Rewriting Scratch 3.0 from scratch in Lua (browser-free native runtime) https://ift.tt/WE3ltJc

Show HN: Pipelex – declarative language for repeatable AI workflows (MIT) https://ift.tt/oIQhc2a

Show HN: Easily visualize torch, Jax, tf, NumPy, etc. tensors https://ift.tt/FNgvmM8

Show HN: JSON Query https://ift.tt/Ggil0WX

Show HN: MNML – Android Launcher (Open Testing Release) https://ift.tt/CsTdjSg

Show HN: Helium Browser for Android with extensions support, based on Vanadium https://ift.tt/NtL9QDs

Show HN: The Legal Embedding Benchmark (MLEB) https://ift.tt/oL0GcMh

Show HN: MyraOS – My 32-bit operating system in C and ASM (Hack Club project) https://ift.tt/BWLIhiY

Show HN: I Built DevTools for Blazor (Like React DevTools but for .NET) https://ift.tt/M1kXYDU