Introduction to Geode

<h2 id="introduction-to-geode" class="position-relative d-flex align-items-center group"> Introduction to Geode <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="introduction-to-geode" aria-haspopup="dialog" aria-label="Share link: Introduction to Geode"> Share link </button> </h2><div id="headingShareModal" class="heading-share-modal" role="dialog" aria-modal="true" aria-labelledby="headingShareTitle" hidden> <div class="hsm-dialog" role="document"> <div class="hsm-header"> <h2 id="headingShareTitle" class="h6 mb-0 fw-bold">Share this section</h2> <button type="button" class="hsm-close" aria-label="Close"> </button> </div> <div class="hsm-body"> <label for="headingShareInput" class="form-label small text-muted mb-1 text-uppercase fw-bold" style="font-size: 0.7rem; letter-spacing: 0.5px;">Permalink</label> <div class="input-group mb-4 hsm-url-group"> <input id="headingShareInput" type="text" class="form-control font-monospace" readonly aria-readonly="true" style="font-size: 0.85rem;" /> <button class="btn btn-primary hsm-copy" type="button" aria-label="Copy" title="Copy"> </button> </div> <div class="small fw-bold mb-2 text-muted text-uppercase" style="font-size: 0.7rem; letter-spacing: 0.5px;">Share via</div> <div class="hsm-share-grid"> <a id="share-twitter" class="btn btn-outline-secondary w-100" target="_blank" rel="noopener noreferrer"> Twitter </a> <a id="share-linkedin" class="btn btn-outline-secondary w-100" target="_blank" rel="noopener noreferrer"> LinkedIn </a> <a id="share-facebook" class="btn btn-outline-secondary w-100" target="_blank" rel="noopener noreferrer"> Facebook </a> </div> </div> </div> </div> <style> .heading-share-modal { position: fixed; inset: 0; display: flex; justify-content: center; align-items: center; background: rgba(0, 0, 0, 0.6); z-index: 1050; padding: 1rem; backdrop-filter: blur(4px); -webkit-backdrop-filter: blur(4px); } .heading-share-modal[hidden] { display: none !important; } .hsm-dialog { max-width: 420px; width: 100%; background: var(--bs-body-bg, #fff); color: var(--bs-body-color, #212529); border: 1px solid var(--bs-border-color, rgba(0,0,0,0.1)); border-radius: 1rem; box-shadow: 0 25px 50px -12px rgba(0, 0, 0, 0.25); overflow: hidden; animation: hsm-fade-in 0.2s ease-out; } @keyframes hsm-fade-in { from { opacity: 0; transform: scale(0.95); } to { opacity: 1; transform: scale(1); } } [data-bs-theme="dark"] .hsm-dialog { background: #1e293b; border-color: rgba(255,255,255,0.1); color: #f8f9fa; } .hsm-header { display: flex; justify-content: space-between; align-items: center; padding: 1rem 1.5rem; border-bottom: 1px solid var(--bs-border-color, rgba(0,0,0,0.1)); background: rgba(0,0,0,0.02); } [data-bs-theme="dark"] .hsm-header { background: rgba(255,255,255,0.02); border-color: rgba(255,255,255,0.1); } .hsm-close { background: transparent; border: none; color: inherit; opacity: 0.5; padding: 0.25rem 0.5rem; border-radius: 0.25rem; font-size: 1.2rem; line-height: 1; transition: opacity 0.2s; } .hsm-close:hover { opacity: 1; } .hsm-body { padding: 1.5rem; } .hsm-url-group { display: flex !important; align-items: stretch; } .hsm-url-group .form-control { flex: 1; min-width: 0; margin: 0; background: var(--bs-secondary-bg, #f8f9fa); border-color: var(--bs-border-color, #dee2e6); border-top-right-radius: 0; border-bottom-right-radius: 0; height: 42px; } .hsm-url-group .btn { flex: 0 0 auto; margin: 0; margin-left: -1px; border-top-left-radius: 0; border-bottom-left-radius: 0; height: 42px; display: flex; align-items: center; justify-content: center; padding: 0 1.25rem; z-index: 2; } [data-bs-theme="dark"] .hsm-url-group .form-control { background: #0f172a; border-color: #334155; color: #e2e8f0; } .hsm-share-grid { display: flex; flex-direction: column; gap: 0.5rem; } .hsm-share-grid .btn { display: flex; align-items: center; justify-content: center; font-size: 0.9rem; padding: 0.6rem; border-color: var(--bs-border-color); width: 100%; } [data-bs-theme="dark"] .hsm-share-grid .btn { color: #e2e8f0; border-color: #475569; } [data-bs-theme="dark"] .hsm-share-grid .btn:hover { background: #334155; border-color: #cbd5e1; } </style> <script> (function(){ const modal = document.getElementById('headingShareModal'); if(!modal) return; const input = modal.querySelector('#headingShareInput'); const copyBtn = modal.querySelector('.hsm-copy'); const twitter = modal.querySelector('#share-twitter'); const linkedin = modal.querySelector('#share-linkedin'); const facebook = modal.querySelector('#share-facebook'); const closeBtn = modal.querySelector('.hsm-close'); let lastFocus=null; let trapBound=false; function buildUrl(id){ return window.location.origin + window.location.pathname + '#' + id; } function isOpen(){ return !modal.hasAttribute('hidden'); } function hydrate(id){ const url=buildUrl(id); input.value=url; const enc=encodeURIComponent(url); const text=encodeURIComponent(document.title); if(twitter) twitter.href=`https://twitter.com/intent/tweet?url=${enc}&text=${text}`; if(linkedin) linkedin.href=`https://www.linkedin.com/sharing/share-offsite/?url=${enc}`; if(facebook) facebook.href=`https://www.facebook.com/sharer/sharer.php?u=${enc}`; } function openModal(id){ lastFocus=document.activeElement; hydrate(id); if(!isOpen()){ modal.removeAttribute('hidden'); } requestAnimationFrame(()=>{ input.focus(); }); trapFocus(); } function closeModal(){ if(!isOpen()) return; modal.setAttribute('hidden',''); if(lastFocus && typeof lastFocus.focus==='function') lastFocus.focus(); } function copyCurrent(){ try{ navigator.clipboard.writeText(input.value).then(()=>feedback(true),()=>fallback()); } catch(e){ fallback(); } } function fallback(){ input.select(); try{ document.execCommand('copy'); feedback(true);}catch(e){ feedback(false);} } function feedback(ok){ if(!copyBtn) return; const icon=copyBtn.querySelector('i'); if(!icon) return; const prev=copyBtn.getAttribute('data-prev')||icon.className; if(!copyBtn.getAttribute('data-prev')) copyBtn.setAttribute('data-prev',prev); icon.className= ok ? 'fa-duotone fa-clipboard-check':'fa-duotone fa-circle-exclamation'; setTimeout(()=>{ icon.className=prev; },1800); } function handleShareClick(e){ e.preventDefault(); const btn=e.currentTarget; const id=btn.getAttribute('data-share-target'); if(id) openModal(id); } function bindShareButtons(){ document.querySelectorAll('.h-share').forEach(btn=>{ if(!btn.dataset.hShareBound){ btn.addEventListener('click', handleShareClick); btn.dataset.hShareBound='1'; } }); } bindShareButtons(); if(document.readyState==='loading'){ document.addEventListener('DOMContentLoaded', bindShareButtons); } else { requestAnimationFrame(bindShareButtons); } document.addEventListener('click', function(e){ const shareBtn=e.target.closest && e.target.closest('.h-share'); if(shareBtn && !shareBtn.dataset.hShareBound){ handleShareClick.call(shareBtn, e); } }, true); document.addEventListener('click', e=>{ if(e.target===modal) closeModal(); if(e.target.closest && e.target.closest('.hsm-close')){ e.preventDefault(); closeModal(); } if(copyBtn && (e.target===copyBtn || (e.target.closest && e.target.closest('.hsm-copy')))) { e.preventDefault(); copyCurrent(); } }); document.addEventListener('keydown', e=>{ if(e.key==='Escape' && isOpen()) closeModal(); }); function trapFocus(){ if(trapBound) return; trapBound=true; modal.addEventListener('keydown', f=>{ if(f.key==='Tab' && isOpen()){ const focusable=[...modal.querySelectorAll('a[href],button,input,textarea,select,[tabindex]:not([tabindex="-1"])')].filter(el=>!el.hasAttribute('disabled')); if(!focusable.length) return; const first=focusable[0]; const last=focusable[focusable.length-1]; if(f.shiftKey && document.activeElement===first){ f.preventDefault(); last.focus(); } else if(!f.shiftKey && document.activeElement===last){ f.preventDefault(); first.focus(); } } }); } if(closeBtn) closeBtn.addEventListener('click', e=>{ e.preventDefault(); closeModal(); }); })(); </script>Welcome to Geode, an enterprise-ready graph database that implements the ISO/IEC 39075:2024 Graph Query Language (GQL) standard. This guide introduces you to graph databases, explains why Geode is different, and helps you get started building your first graph applications. <h3 id="what-is-geode" class="position-relative d-flex align-items-center group"> What is Geode? <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="what-is-geode" aria-haspopup="dialog" aria-label="Share link: What is Geode?"> Share link </button> </h3>Geode is a modern graph database designed for production workloads that require: <ul> <li>Standards Compliance: Full implementation of ISO/IEC 39075:2024 GQL</li> <li>ACID Guarantees: Complete transaction safety with distributed support</li> <li>Enterprise Features: Row-level security, audit logging, backup/restore</li> <li>High Performance: QUIC transport, parallel query execution, efficient storage</li> <li>Polyglot Support: Client libraries for Go, Python, Rust, Zig, and more</li> </ul> <h4 id="key-characteristics" class="position-relative d-flex align-items-center group"> Key Characteristics <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="key-characteristics" aria-haspopup="dialog" aria-label="Share link: Key Characteristics"> Share link </button> </h4>Production Ready: <ul> <li>97.4% test coverage (1644/1688 tests passing)</li> <li>100% GQL compliance (see conformance profile)</li> <li>Active development with rigorous governance</li> </ul> Modern Architecture: <ul> <li>Written in Zig for memory safety and performance</li> <li>QUIC + TLS 1.3 for secure, efficient communication</li> <li>Native graph storage with index-free adjacency</li> </ul> Developer Friendly: <ul> <li>Standard GQL query language</li> <li>Comprehensive client libraries</li> <li>Clear documentation and examples</li> <li>Active community support</li> </ul> <h3 id="why-graph-databases" class="position-relative d-flex align-items-center group"> Why Graph Databases? <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="why-graph-databases" aria-haspopup="dialog" aria-label="Share link: Why Graph Databases?"> Share link </button> </h3>Traditional relational databases store data in tables with rows and columns, requiring expensive JOIN operations to connect related data. Graph databases store relationships as first-class citizens, making connected data queries natural and efficient. <h4 id="when-relationships-matter" class="position-relative d-flex align-items-center group"> When Relationships Matter <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="when-relationships-matter" aria-haspopup="dialog" aria-label="Share link: When Relationships Matter"> Share link </button> </h4>Social Networks: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Find friends of friends in 2 hops MATCH (me:User {name: 'Alice'})-[:FRIEND]->(f1)-[:FRIEND]->(f2) WHERE f2 <> me AND NOT EXISTS { MATCH (me)-[:FRIEND]->(f2) } RETURN f2.name AS suggestion LIMIT 10; </code></pre></div>In a relational database, this requires multiple self-joins that become slower with each hop. In Geode, traversing relationships is constant-time regardless of depth. Recommendation Engines: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Find products similar users bought MATCH (me:User {id: $user_id})-[:PURCHASED]->(p:Product)<-[:PURCHASED]-(similar:User) MATCH (similar)-[:PURCHASED]->(rec:Product) WHERE NOT EXISTS { MATCH (me)-[:PURCHASED]->(rec) } RETURN rec.name, count(similar) AS score ORDER BY score DESC LIMIT 20; </code></pre></div>Fraud Detection: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Detect circular transaction patterns MATCH path = (a:Account)-[:TRANSFER*3..5]->(a) WHERE all(r IN relationships(path) WHERE r.amount > 10000) AND all(r IN relationships(path) WHERE r.timestamp >= CURRENT_DATE - DURATION 'P7D') RETURN path, reduce(sum = 0, r IN relationships(path) | sum + r.amount) AS total; </code></pre></div> <h3 id="why-geode" class="position-relative d-flex align-items-center group"> Why Geode? <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="why-geode" aria-haspopup="dialog" aria-label="Share link: Why Geode?"> Share link </button> </h3> <h4 id="standards-based" class="position-relative d-flex align-items-center group"> Standards-Based <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="standards-based" aria-haspopup="dialog" aria-label="Share link: Standards-Based"> Share link </button> </h4>Geode implements the ISO/IEC 39075:2024 GQL standard, the international standard for graph query languages (like SQL is for relational databases). Benefits: <ul> <li>No Vendor Lock-In: Standard language works across compliant databases</li> <li>Future-Proof: International standards evolve through consensus</li> <li>Familiar Syntax: If you know SQL or Cypher, GQL will feel natural</li> <li>Interoperability: Tools and skills transfer across GQL databases</li> </ul> <h4 id="full-acid-compliance" class="position-relative d-flex align-items-center group"> Full ACID Compliance <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="full-acid-compliance" aria-haspopup="dialog" aria-label="Share link: Full ACID Compliance"> Share link </button> </h4>Unlike many NoSQL databases, Geode provides complete ACID guarantees: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">BEGIN TRANSACTION; -- All operations succeed or all fail INSERT (sender:Account {id: 'a1', balance: 1000}); INSERT (receiver:Account {id: 'a2', balance: 500}); MATCH (s:Account {id: 'a1'}), (r:Account {id: 'a2'}) SET s.balance = s.balance - 100, r.balance = r.balance + 100; INSERT (s)-[:TRANSFERRED {amount: 100, timestamp: CURRENT_TIMESTAMP}]->(r); COMMIT; </code></pre></div> <h4 id="enterprise-security" class="position-relative d-flex align-items-center group"> Enterprise Security <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="enterprise-security" aria-haspopup="dialog" aria-label="Share link: Enterprise Security"> Share link </button> </h4>Row-Level Security (RLS): <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Define access policy CREATE POLICY user_data_isolation ON User USING (id = current_user_id()); -- Automatically enforced on all queries MATCH (u:User) RETURN u.name; -- Only returns current user </code></pre></div>Audit Logging: All data modifications are automatically logged for compliance and forensics. TLS 1.3 Encryption: All client connections use modern encryption by default. <h4 id="high-performance" class="position-relative d-flex align-items-center group"> High Performance <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="high-performance" aria-haspopup="dialog" aria-label="Share link: High Performance"> Share link </button> </h4>QUIC Transport: Geode uses QUIC (the protocol behind HTTP/3) for: <ul> <li>Reduced latency (0-RTT connection resumption)</li> <li>Better performance over unreliable networks</li> <li>Built-in encryption</li> <li>Multiplexed streams</li> </ul> Parallel Query Execution: Complex analytical queries automatically parallelize across CPU cores. Native Graph Storage: Index-free adjacency means traversing relationships is O(1) regardless of graph size. <h3 id="architecture-overview" class="position-relative d-flex align-items-center group"> Architecture Overview <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="architecture-overview" aria-haspopup="dialog" aria-label="Share link: Architecture Overview"> Share link </button> </h3> <h4 id="components" class="position-relative d-flex align-items-center group"> Components <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="components" aria-haspopup="dialog" aria-label="Share link: Components"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-fallback" data-lang="fallback">┌─────────────┐ │ Client │ (Go, Python, Rust, Zig) └──────┬──────┘ │ QUIC + TLS 1.3 │ Port 3141 ┌──────▼──────────────────────────┐ │ Geode Server │ │ ┌───────────────────────────┐ │ │ │ Query Engine │ │ │ │ - Parser (GQL) │ │ │ │ - Optimizer │ │ │ │ - Executor │ │ │ └───────────┬───────────────┘ │ │ │ │ │ ┌───────────▼───────────────┐ │ │ │ Storage Engine │ │ │ │ - Native graph storage │ │ │ │ - Indexes │ │ │ │ - Transaction log │ │ │ └───────────────────────────┘ │ └─────────────────────────────────┘ </code></pre></div> <h4 id="data-model" class="position-relative d-flex align-items-center group"> Data Model <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="data-model" aria-haspopup="dialog" aria-label="Share link: Data Model"> Share link </button> </h4>Geode implements the property graph model: <ul> <li>Nodes: Entities with labels and properties</li> <li>Relationships: Directed edges with type and properties</li> <li>Properties: Key-value pairs on nodes and relationships</li> <li>Labels: Categorize nodes (e.g., Person, Product, Company)</li> </ul> <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Node with label and properties (alice:Person { id: 'u123', name: 'Alice', age: 30 }) -- Relationship with type and properties (alice)-[:KNOWS {since: DATE '2020-01-15', context: 'work'}]->(bob:Person) </code></pre></div> <h3 id="installation-and-setup" class="position-relative d-flex align-items-center group"> Installation and Setup <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="installation-and-setup" aria-haspopup="dialog" aria-label="Share link: Installation and Setup"> Share link </button> </h3> <h4 id="prerequisites" class="position-relative d-flex align-items-center group"> Prerequisites <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="prerequisites" aria-haspopup="dialog" aria-label="Share link: Prerequisites"> Share link </button> </h4><ul> <li>Linux, macOS, or Windows (WSL)</li> <li>2GB RAM minimum (4GB+ recommended)</li> <li>100MB disk space</li> </ul> <h4 id="quick-start-with-docker" class="position-relative d-flex align-items-center group"> Quick Start with Docker <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="quick-start-with-docker" aria-haspopup="dialog" aria-label="Share link: Quick Start with Docker"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># Pull and run Geode docker pull geodedb/geode:latest docker run -p 3141:3141 geodedb/geode:latest # Connect from another terminal docker exec -it <container_id> geode shell </code></pre></div> <h4 id="build-from-source" class="position-relative d-flex align-items-center group"> Build from Source <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="build-from-source" aria-haspopup="dialog" aria-label="Share link: Build from Source"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># Clone repository git clone https://github.com/codeprosorg/geode cd geode # Build (requires Zig 0.1.0+) make build # Run server geode serve --listen 0.0.0.0:3141 # Connect via shell (in another terminal) geode shell </code></pre></div> <h4 id="verify-installation" class="position-relative d-flex align-items-center group"> Verify Installation <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="verify-installation" aria-haspopup="dialog" aria-label="Share link: Verify Installation"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># Check version geode --version # Test connection geode shell </code></pre></div>In the shell: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Test query RETURN 'Hello, Geode!' AS message; </code></pre></div> <h3 id="your-first-graph" class="position-relative d-flex align-items-center group"> Your First Graph <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="your-first-graph" aria-haspopup="dialog" aria-label="Share link: Your First Graph"> Share link </button> </h3> <h4 id="1-create-nodes" class="position-relative d-flex align-items-center group"> 1. Create Nodes <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="1-create-nodes" aria-haspopup="dialog" aria-label="Share link: 1. Create Nodes"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Create people INSERT (alice:Person {name: 'Alice', age: 30, city: 'San Francisco'}); INSERT (bob:Person {name: 'Bob', age: 28, city: 'New York'}); INSERT (charlie:Person {name: 'Charlie', age: 35, city: 'Austin'}); </code></pre></div> <h4 id="2-create-relationships" class="position-relative d-flex align-items-center group"> 2. Create Relationships <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="2-create-relationships" aria-haspopup="dialog" aria-label="Share link: 2. Create Relationships"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Connect people INSERT (alice:Person {name: 'Alice'})-[:KNOWS {since: DATE '2020-01-15'}]-> (bob:Person {name: 'Bob'}); INSERT (bob)-[:KNOWS {since: DATE '2021-03-20'}]-> (charlie:Person {name: 'Charlie'}); INSERT (charlie)-[:KNOWS {since: DATE '2019-11-10'}]-> (alice); </code></pre></div> <h4 id="3-query-the-graph" class="position-relative d-flex align-items-center group"> 3. Query the Graph <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="3-query-the-graph" aria-haspopup="dialog" aria-label="Share link: 3. Query the Graph"> Share link </button> </h4>Simple match: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Find all people MATCH (p:Person) RETURN p.name, p.age, p.city; </code></pre></div>Traversal: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Find Alice's friends MATCH (alice:Person {name: 'Alice'})-[:KNOWS]->(friend) RETURN friend.name, friend.city; </code></pre></div>Multi-hop: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Find friends of friends MATCH (alice:Person {name: 'Alice'})-[:KNOWS]->(friend)-[:KNOWS]->(fof) WHERE fof <> alice RETURN fof.name AS friend_of_friend; </code></pre></div>With filtering: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Find friends over 30 MATCH (alice:Person {name: 'Alice'})-[:KNOWS]->(friend) WHERE friend.age > 30 RETURN friend.name, friend.age ORDER BY friend.age DESC; </code></pre></div> <h4 id="4-update-data" class="position-relative d-flex align-items-center group"> 4. Update Data <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="4-update-data" aria-haspopup="dialog" aria-label="Share link: 4. Update Data"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Update properties MATCH (p:Person {name: 'Alice'}) SET p.age = 31, p.last_updated = CURRENT_TIMESTAMP; -- Add relationship MATCH (alice:Person {name: 'Alice'}), (charlie:Person {name: 'Charlie'}) INSERT (alice)-[:WORKS_WITH {department: 'Engineering'}]->(charlie); </code></pre></div> <h4 id="5-delete-data" class="position-relative d-flex align-items-center group"> 5. Delete Data <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="5-delete-data" aria-haspopup="dialog" aria-label="Share link: 5. Delete Data"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Delete relationship MATCH (alice:Person {name: 'Alice'})-[r:WORKS_WITH]->(charlie:Person {name: 'Charlie'}) DELETE r; -- Delete node (must delete relationships first) MATCH (p:Person {name: 'Charlie'})-[r]-() DELETE r; MATCH (p:Person {name: 'Charlie'}) DELETE p; </code></pre></div> <h3 id="core-gql-concepts" class="position-relative d-flex align-items-center group"> Core GQL Concepts <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="core-gql-concepts" aria-haspopup="dialog" aria-label="Share link: Core GQL Concepts"> Share link </button> </h3> <h4 id="pattern-matching" class="position-relative d-flex align-items-center group"> Pattern Matching <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="pattern-matching" aria-haspopup="dialog" aria-label="Share link: Pattern Matching"> Share link </button> </h4>GQL uses visual patterns to describe graph structures: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Node pattern (variable:Label {property: 'value'}) -- Relationship pattern (a)-[:TYPE {prop: value}]->(b) -- Variable-length path (a)-[:TYPE*1..5]->(b) -- Complete query MATCH (a:Person)-[:KNOWS*2..3]->(b:Person) WHERE a.city = 'San Francisco' RETURN b.name, b.city; </code></pre></div> <h4 id="clauses" class="position-relative d-flex align-items-center group"> Clauses <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="clauses" aria-haspopup="dialog" aria-label="Share link: Clauses"> Share link </button> </h4>MATCH: Find patterns in the graph <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">MATCH (p:Person {city: 'Austin'}) RETURN p.name; </code></pre></div>INSERT: Create nodes and relationships <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">INSERT (p:Person {name: 'Dave', age: 40}); </code></pre></div>SET: Update properties <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">MATCH (p:Person {name: 'Dave'}) SET p.verified = true; </code></pre></div>DELETE: Remove nodes or relationships <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">MATCH (p:Person {name: 'Dave'}) DELETE p; </code></pre></div>WHERE: Filter results <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">MATCH (p:Person) WHERE p.age >= 30 AND p.city = 'San Francisco' RETURN p.name; </code></pre></div>RETURN: Specify output <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">MATCH (p:Person) RETURN p.name AS name, p.age AS age ORDER BY age DESC LIMIT 10; </code></pre></div> <h4 id="aggregations" class="position-relative d-flex align-items-center group"> Aggregations <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="aggregations" aria-haspopup="dialog" aria-label="Share link: Aggregations"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Count nodes MATCH (p:Person) RETURN count(p) AS total_people; -- Group and aggregate MATCH (p:Person) RETURN p.city, count(p) AS people_count, avg(p.age) AS avg_age GROUP BY p.city ORDER BY people_count DESC; </code></pre></div> <h4 id="parameters" class="position-relative d-flex align-items-center group"> Parameters <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="parameters" aria-haspopup="dialog" aria-label="Share link: Parameters"> Share link </button> </h4>Use parameters for safe, reusable queries: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Query with parameter MATCH (p:Person {name: $person_name}) RETURN p.age, p.city; </code></pre></div>From client libraries: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-go" data-lang="go">// Go result, err := conn.Query("MATCH (p:Person {name: $name}) RETURN p.age", map[string]interface{}{"name": "Alice"}) </code></pre></div><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python"># Python result, _ = await conn.query( "MATCH (p:Person {name: $name}) RETURN p.age", parameters={"name": "Alice"} ) </code></pre></div> <h3 id="client-libraries" class="position-relative d-flex align-items-center group"> Client Libraries <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="client-libraries" aria-haspopup="dialog" aria-label="Share link: Client Libraries"> Share link </button> </h3> <h4 id="go" class="position-relative d-flex align-items-center group"> Go <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="go" aria-haspopup="dialog" aria-label="Share link: Go"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash">go get geodedb.com/geode </code></pre></div><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-go" data-lang="go">package main import ( "context" "fmt" "log" "geodedb.com/geode" ) func main() { conn, err := geode.Connect(context.Background(), "localhost:3141") if err != nil { log.Fatal(err) } defer conn.Close() result, err := conn.Query( "MATCH (p:Person {name: $name}) RETURN p.age, p.city", map[string]interface{}{"name": "Alice"}, ) if err != nil { log.Fatal(err) } for result.Next() { var age int var city string result.Scan(&age, &city) fmt.Printf("Age: %d, City: %s\n", age, city) } } </code></pre></div> <h4 id="python" class="position-relative d-flex align-items-center group"> Python <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="python" aria-haspopup="dialog" aria-label="Share link: Python"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash">pip install geode-client </code></pre></div><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python">import asyncio from geode_client import Client async def main(): client = Client(host="localhost", port=3141) async with client.connection() as conn: result, _ = await conn.query( "MATCH (p:Person {name: $name}) RETURN p.age, p.city", parameters={"name": "Alice"} ) for row in result.rows: print(f"Age: {row['p.age']}, City: {row['p.city']}") asyncio.run(main()) </code></pre></div> <h4 id="rust" class="position-relative d-flex align-items-center group"> Rust <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="rust" aria-haspopup="dialog" aria-label="Share link: Rust"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-toml" data-lang="toml">[dependencies] geode-client = "0.1" </code></pre></div><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-rust" data-lang="rust">use geode_client::{Client, Value}; use std::collections::HashMap; #[tokio::main] async fn main() -> Result<(), Box<dyn std::error::Error>> { let client = Client::from_dsn("localhost:3141")?; let mut conn = client.connect().await?; let mut params = HashMap::new(); params.insert("name".to_string(), Value::string("Alice")); let (page, _) = conn .query_with_params( "MATCH (p:Person {name: $name}) RETURN p.age, p.city", &params, ) .await?; for row in &page.rows { let age = row.get("p.age").unwrap().as_int()?; let city = row.get("p.city").unwrap().as_string()?; println!("Age: {}, City: {}", age, city); } Ok(()) } </code></pre></div> <h3 id="next-steps" class="position-relative d-flex align-items-center group"> Next Steps <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="next-steps" aria-haspopup="dialog" aria-label="Share link: Next Steps"> Share link </button> </h3> <h4 id="learn-more" class="position-relative d-flex align-items-center group"> Learn More <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="learn-more" aria-haspopup="dialog" aria-label="Share link: Learn More"> Share link </button> </h4><ul> <li>GQL Tutorial: Deep dive into query language features</li> <li>Data Modeling: Best practices for graph schema design</li> <li>Client SDKs: Language-specific guides</li> <li>Performance Tuning: Optimization techniques</li> <li>Security: RLS policies, authentication, encryption</li> </ul> <h4 id="example-applications" class="position-relative d-flex align-items-center group"> Example Applications <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="example-applications" aria-haspopup="dialog" aria-label="Share link: Example Applications"> Share link </button> </h4><ul> <li>Social Network: Friend recommendations, news feed</li> <li>E-commerce: Product recommendations, fraud detection</li> <li>Knowledge Graph: Semantic search, relationship discovery</li> <li>Network Analysis: Infrastructure dependencies, impact analysis</li> </ul> <h4 id="resources" class="position-relative d-flex align-items-center group"> Resources <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="resources" aria-haspopup="dialog" aria-label="Share link: Resources"> Share link </button> </h4><ul> <li>Documentation: Complete API reference and guides</li> <li>Examples: Sample applications and datasets</li> <li>Community: Forum, Slack, issue tracker</li> <li>Support: Commercial support options</li> </ul> <h3 id="common-patterns" class="position-relative d-flex align-items-center group"> Common Patterns <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="common-patterns" aria-haspopup="dialog" aria-label="Share link: Common Patterns"> Share link </button> </h3> <h4 id="application-setup" class="position-relative d-flex align-items-center group"> Application Setup <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="application-setup" aria-haspopup="dialog" aria-label="Share link: Application Setup"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Create indexes for common queries CREATE INDEX person_name ON Person(name); CREATE INDEX person_email ON Person(email); -- Set up RLS if needed CREATE POLICY user_isolation ON User USING (id = current_user_id()); </code></pre></div> <h4 id="batch-loading" class="position-relative d-flex align-items-center group"> Batch Loading <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="batch-loading" aria-haspopup="dialog" aria-label="Share link: Batch Loading"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Use UNWIND for bulk inserts UNWIND $users AS user_data INSERT (u:User { id: user_data.id, name: user_data.name, email: user_data.email }); </code></pre></div> <h4 id="transactions" class="position-relative d-flex align-items-center group"> Transactions <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="transactions" aria-haspopup="dialog" aria-label="Share link: Transactions"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">BEGIN TRANSACTION; -- Multiple related operations INSERT (order:Order {id: 'o123', total: 99.99}); MATCH (user:User {id: 'u456'}) INSERT (user)-[:PLACED]->(order); COMMIT; </code></pre></div> <h3 id="troubleshooting" class="position-relative d-flex align-items-center group"> Troubleshooting <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="troubleshooting" aria-haspopup="dialog" aria-label="Share link: Troubleshooting"> Share link </button> </h3> <h4 id="connection-issues" class="position-relative d-flex align-items-center group"> Connection Issues <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="connection-issues" aria-haspopup="dialog" aria-label="Share link: Connection Issues"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># Check server is running ps aux | grep geode # Check port is listening netstat -an | grep 3141 # Test connection geode shell </code></pre></div> <h4 id="query-performance" class="position-relative d-flex align-items-center group"> Query Performance <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="query-performance" aria-haspopup="dialog" aria-label="Share link: Query Performance"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Profile slow queries PROFILE MATCH (p:Person)-[:KNOWS*2..4]->(friend) WHERE p.city = 'San Francisco' RETURN friend.name; -- Check indexes SHOW INDEXES; </code></pre></div> <h4 id="common-errors" class="position-relative d-flex align-items-center group"> Common Errors <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="common-errors" aria-haspopup="dialog" aria-label="Share link: Common Errors"> Share link </button> </h4>“Node not found”: Use INSERT to create, not MATCH <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Wrong MATCH (p:Person {name: 'Alice'}) -- Error if doesn't exist -- Right INSERT (p:Person {name: 'Alice'}); </code></pre></div>“Relationship requires both nodes”: Create nodes first <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Create nodes INSERT (alice:Person {name: 'Alice'}); INSERT (bob:Person {name: 'Bob'}); -- Then relationship MATCH (a:Person {name: 'Alice'}), (b:Person {name: 'Bob'}) INSERT (a)-[:KNOWS]->(b); </code></pre></div> <h3 id="conclusion" class="position-relative d-flex align-items-center group"> Conclusion <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="conclusion" aria-haspopup="dialog" aria-label="Share link: Conclusion"> Share link </button> </h3>Geode brings standards-based graph database capabilities with enterprise features, ACID guarantees, and high performance. Whether building social networks, recommendation engines, fraud detection systems, or knowledge graphs, Geode provides the foundation for production-ready graph applications. Start exploring the documentation below to master GQL queries, graph modeling, client integration, and advanced features. Welcome to the Geode community!

Popular

Related Articles

Overview

Introduction and Key Features