Tag: Graph Query Language (GQL) Page 2 | Tags

Geode documentation tagged with Graph Query Language (GQL). GQL is the ISO/IEC 39075:2024 international standard for querying property graph databases, providing a declarative, composable language designed specifically for graph data structures. <h3 id="introduction-to-gql" class="position-relative d-flex align-items-center group"> Introduction to GQL <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-gql" aria-haspopup="dialog" aria-label="Share link: Introduction to GQL"> Share link </button> </h3><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>The Graph Query Language (GQL) represents a watershed moment in database standardization. Published as ISO/IEC 39075:2024, GQL provides the first international standard specifically designed for querying property graphs. Unlike SQL, which evolved from relational theory, or Cypher and SPARQL, which were vendor-specific or domain-specific, GQL was built from the ground up as a universal standard for graph databases. GQL combines the best ideas from existing graph query languages while introducing new capabilities for modern graph workloads. The language supports both read queries (MATCH) and write operations (INSERT, SET, REMOVE, DELETE), making it a complete data manipulation language. Its declarative nature means you describe what data you want, not how to retrieve it—the query optimizer handles execution strategy. Geode follows the ISO/IEC 39075:2024 compliance. See the conformance profile for scope, diagnostics, and implementation-defined behaviors. <h3 id="key-concepts" class="position-relative d-flex align-items-center group"> Key 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="key-concepts" aria-haspopup="dialog" aria-label="Share link: Key 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>At the heart of GQL is pattern matching. The <code>MATCH</code> clause lets you describe graph structures using ASCII-art syntax: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">MATCH (person:Person)-[:KNOWS]->(friend:Person) WHERE person.name = 'Alice' RETURN friend.name </code></pre></div>This query reads naturally: “Match a Person node named Alice, connected by a KNOWS relationship to friend nodes, and return the friends’ names.” <h4 id="node-and-relationship-patterns" class="position-relative d-flex align-items-center group"> Node and Relationship 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="node-and-relationship-patterns" aria-haspopup="dialog" aria-label="Share link: Node and Relationship Patterns"> Share link </button> </h4>GQL supports rich pattern syntax: <ul> <li>Node patterns: <code>(variable:Label {property: value})</code></li> <li>Relationship patterns: <code>-[:TYPE]-></code>, <code><-[:TYPE]-</code>, <code>-[:TYPE]-</code></li> <li>Variable-length paths: <code>-[:KNOWS*1..3]-></code> (1 to 3 hops)</li> <li>Property constraints: <code>WHERE node.age > 30</code></li> </ul> <h4 id="data-manipulation" class="position-relative d-flex align-items-center group"> Data Manipulation <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-manipulation" aria-haspopup="dialog" aria-label="Share link: Data Manipulation"> Share link </button> </h4>GQL provides comprehensive write operations: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">// Insert new nodes INSERT (:Person {name: 'Bob', age: 30}) // Create relationships MATCH (a:Person {name: 'Alice'}), (b:Person {name: 'Bob'}) INSERT (a)-[:KNOWS]->(b) // Update properties MATCH (p:Person {name: 'Bob'}) SET p.age = 31 // Remove properties MATCH (p:Person {name: 'Bob'}) REMOVE p.temporary_flag // Delete nodes and relationships MATCH (p:Person {name: 'Bob'}) DELETE p </code></pre></div> <h4 id="composability-and-modularity" class="position-relative d-flex align-items-center group"> Composability and Modularity <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="composability-and-modularity" aria-haspopup="dialog" aria-label="Share link: Composability and Modularity"> Share link </button> </h4>GQL queries compose naturally using subqueries, CTEs (Common Table Expressions), and nested patterns: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">MATCH (p:Person) WHERE EXISTS { MATCH (p)-[:WORKS_AT]->(:Company {name: 'Acme Corp'}) } RETURN p.name </code></pre></div> <h3 id="how-gql-works-in-geode" class="position-relative d-flex align-items-center group"> How GQL Works in 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="how-gql-works-in-geode" aria-haspopup="dialog" aria-label="Share link: How GQL Works in Geode"> Share link </button> </h3>Geode’s GQL implementation is built on a sophisticated query engine that transforms GQL syntax into optimized execution plans. <h4 id="query-pipeline" class="position-relative d-flex align-items-center group"> Query Pipeline <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-pipeline" aria-haspopup="dialog" aria-label="Share link: Query Pipeline"> Share link </button> </h4><ol> <li>Lexical Analysis: The lexer tokenizes GQL source code into tokens (keywords, identifiers, operators)</li> <li>Parsing: The parser builds an Abstract Syntax Tree (AST) representing the query structure</li> <li>Semantic Analysis: Type checking, label validation, and constraint verification</li> <li>Query Optimization: The optimizer applies rules to generate efficient execution plans</li> <li>Execution: The runtime engine executes the plan using Geode’s storage and indexing layers</li> </ol> <h4 id="standards-compliance" class="position-relative d-flex align-items-center group"> Standards 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="standards-compliance" aria-haspopup="dialog" aria-label="Share link: Standards Compliance"> Share link </button> </h4>Geode achieves ISO/IEC 39075:2024 compliance through: <ul> <li>Complete syntax support: All GQL keywords, operators, and expressions</li> <li>Correct semantics: Exact ISO-specified behavior for edge cases</li> <li>Test validation: All 70 ISO compliance tests passing</li> <li>Error handling: ISO-compliant status codes and error messages</li> </ul> <h4 id="performance-optimizations" class="position-relative d-flex align-items-center group"> Performance Optimizations <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="performance-optimizations" aria-haspopup="dialog" aria-label="Share link: Performance Optimizations"> Share link </button> </h4>Geode’s GQL engine includes advanced optimizations: <ul> <li>Index-aware planning: Automatically uses indexes for WHERE clauses</li> <li>Join reordering: Optimizes multi-pattern queries</li> <li>Predicate pushdown: Filters data as early as possible</li> <li>Parallel execution: Distributes work across CPU cores</li> <li>Query caching: Reuses compiled query plans</li> </ul> <h3 id="use-cases" class="position-relative d-flex align-items-center group"> Use Cases <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="use-cases" aria-haspopup="dialog" aria-label="Share link: Use Cases"> Share link </button> </h3> <h4 id="social-network-analysis" class="position-relative d-flex align-items-center group"> Social Network Analysis <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="social-network-analysis" aria-haspopup="dialog" aria-label="Share link: Social Network Analysis"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">// Find friends-of-friends who share interests MATCH (me:Person {id: $userId})-[:KNOWS]->()-[:KNOWS]->(foaf:Person) WHERE NOT EXISTS { MATCH (me)-[:KNOWS]->(foaf) } AND EXISTS { MATCH (me)-[:INTERESTED_IN]->(interest)<-[:INTERESTED_IN]-(foaf) } RETURN DISTINCT foaf.name, COUNT(interest) AS shared_interests ORDER BY shared_interests DESC LIMIT 10 </code></pre></div> <h4 id="fraud-detection" class="position-relative d-flex align-items-center group"> Fraud Detection <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="fraud-detection" aria-haspopup="dialog" aria-label="Share link: Fraud Detection"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">// Detect suspicious transaction patterns MATCH (account:Account)-[t1:TRANSACTION]->(intermediary:Account) -[t2:TRANSACTION]->(destination:Account) WHERE t1.timestamp - t2.timestamp < duration('PT1H') AND t1.amount > 10000 AND account.risk_score > 0.7 RETURN account.id, destination.id, t1.amount </code></pre></div> <h4 id="knowledge-graph-queries" class="position-relative d-flex align-items-center group"> Knowledge Graph Queries <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="knowledge-graph-queries" aria-haspopup="dialog" aria-label="Share link: Knowledge Graph Queries"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">// Find related concepts within 3 hops MATCH path = (start:Concept {name: 'Machine Learning'}) -[:RELATED_TO*1..3]->(related:Concept) WHERE related.importance > 0.5 RETURN related.name, length(path) AS distance ORDER BY distance, related.importance DESC </code></pre></div> <h4 id="recommendation-systems" class="position-relative d-flex align-items-center group"> Recommendation Systems <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="recommendation-systems" aria-haspopup="dialog" aria-label="Share link: Recommendation Systems"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">// Collaborative filtering recommendations MATCH (user:User {id: $userId})-[:RATED]->(item:Item) <-[:RATED]-(similar:User)-[:RATED]->(recommendation:Item) WHERE NOT EXISTS { MATCH (user)-[:RATED]->(recommendation) } RETURN recommendation.title, COUNT(similar) AS score ORDER BY score DESC LIMIT 20 </code></pre></div> <h3 id="best-practices" class="position-relative d-flex align-items-center group"> Best Practices <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="best-practices" aria-haspopup="dialog" aria-label="Share link: Best Practices"> Share link </button> </h3> <h4 id="query-optimization" class="position-relative d-flex align-items-center group"> Query Optimization <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-optimization" aria-haspopup="dialog" aria-label="Share link: Query Optimization"> Share link </button> </h4><ol> <li> Use indexes: Create indexes on frequently queried properties <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">CREATE INDEX person_name FOR (p:Person) ON (p.name) </code></pre></div></li> <li> Filter early: Place selective WHERE clauses near MATCH patterns </li> <li> Limit results: Always use LIMIT for unbounded queries </li> <li> Profile queries: Use PROFILE to understand execution plans </li> </ol> <h4 id="schema-design" class="position-relative d-flex align-items-center group"> Schema Design <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="schema-design" aria-haspopup="dialog" aria-label="Share link: Schema Design"> Share link </button> </h4><ul> <li>Label consistently: Use clear, singular noun labels (<code>:Person</code>, <code>:Product</code>)</li> <li>Type relationships: Give relationships meaningful types (<code>:PURCHASED</code>, <code>:FRIEND_OF</code>)</li> <li>Index strategically: Index properties used in WHERE, JOIN, and ORDER BY</li> <li>Normalize carefully: Balance between normalization and query performance</li> </ul> <h4 id="transaction-management" class="position-relative d-flex align-items-center group"> Transaction Management <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="transaction-management" aria-haspopup="dialog" aria-label="Share link: Transaction Management"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">BEGIN TRANSACTION; MATCH (account:Account {id: $fromId}) WHERE account.balance >= $amount SET account.balance = account.balance - $amount; MATCH (recipient:Account {id: $toId}) SET recipient.balance = recipient.balance + $amount; COMMIT; </code></pre></div> <h4 id="error-handling" class="position-relative d-flex align-items-center group"> Error Handling <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="error-handling" aria-haspopup="dialog" aria-label="Share link: Error Handling"> Share link </button> </h4><ul> <li>Check for NULL values in optional patterns</li> <li>Use EXISTS for conditional logic</li> <li>Validate inputs in WHERE clauses</li> <li>Handle constraint violations gracefully</li> </ul> <h3 id="code-examples" class="position-relative d-flex align-items-center group"> Code Examples <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="code-examples" aria-haspopup="dialog" aria-label="Share link: Code Examples"> Share link </button> </h3> <h4 id="basic-pattern-matching" class="position-relative d-flex align-items-center group"> Basic 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="basic-pattern-matching" aria-haspopup="dialog" aria-label="Share link: Basic Pattern Matching"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">// Find all employees in engineering department MATCH (p:Person)-[:WORKS_IN]->(d:Department {name: 'Engineering'}) RETURN p.name, p.title ORDER BY p.hire_date DESC </code></pre></div> <h4 id="aggregation" class="position-relative d-flex align-items-center group"> Aggregation <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="aggregation" aria-haspopup="dialog" aria-label="Share link: Aggregation"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">// Count connections by relationship type MATCH (p:Person)-[r]->() RETURN type(r) AS relationship_type, COUNT(*) AS count ORDER BY count DESC </code></pre></div> <h4 id="path-queries" class="position-relative d-flex align-items-center group"> Path Queries <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="path-queries" aria-haspopup="dialog" aria-label="Share link: Path Queries"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">// Find shortest path between two people MATCH path = shortestPath( (start:Person {name: 'Alice'})-[:KNOWS*]-(end:Person {name: 'Bob'}) ) RETURN [node IN nodes(path) | node.name] AS path </code></pre></div> <h4 id="conditional-logic" class="position-relative d-flex align-items-center group"> Conditional Logic <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="conditional-logic" aria-haspopup="dialog" aria-label="Share link: Conditional Logic"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">// Use CASE for computed values MATCH (p:Person) RETURN p.name, CASE WHEN p.age < 18 THEN 'Minor' WHEN p.age < 65 THEN 'Adult' ELSE 'Senior' END AS age_group </code></pre></div> <h3 id="related-topics" class="position-relative d-flex align-items-center group"> Related Topics <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="related-topics" aria-haspopup="dialog" aria-label="Share link: Related Topics"> Share link </button> </h3>Explore related GQL concepts and features: <ul> <li><a href="/tags/iso-gql/" >ISO GQL Standard</a> - ISO/IEC 39075:2024 specification details</li> <li><a href="/tags/gql-compliance/" >GQL Compliance</a> - Standards conformance and testing</li> <li><a href="/tags/pattern-matching/" >Pattern Matching</a> - Advanced pattern techniques</li> <li><a href="/tags/match/" >MATCH Clause</a> - Core query patterns</li> <li><a href="/tags/query-language/" >Query Language</a> - Language fundamentals</li> <li><a href="/tags/query-optimization/" >Query Optimization</a> - Performance tuning</li> <li><a href="/tags/gql-syntax/" >GQL Syntax</a> - Syntax reference</li> <li><a href="/tags/gql-reference/" >GQL Reference</a> - Complete language reference</li> </ul> <h3 id="further-reading" class="position-relative d-flex align-items-center group"> Further Reading <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="further-reading" aria-haspopup="dialog" aria-label="Share link: Further Reading"> Share link </button> </h3> <h4 id="documentation" class="position-relative d-flex align-items-center group"> Documentation <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="documentation" aria-haspopup="dialog" aria-label="Share link: Documentation"> Share link </button> </h4><ul> <li><a href="/docs/quick-reference/" >GQL Quick Reference</a> - Syntax cheat sheet</li> <li><a href="/docs/api-reference/" >API Reference</a> - Complete API documentation</li> <li><a href="/tags/query-optimization/" >Query Optimization</a> - Performance best practices</li> <li><a href="/tags/tutorial/" >GQL Tutorial Series</a> - Step-by-step learning path</li> </ul> <h4 id="specifications" class="position-relative d-flex align-items-center group"> Specifications <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="specifications" aria-haspopup="dialog" aria-label="Share link: Specifications"> Share link </button> </h4><ul> <li><a href="/tags/iso-standard/" >ISO/IEC 39075:2024 Overview</a> - International standard details</li> <li><a href="/tags/specification/" >GQL Specification</a> - Technical specification</li> </ul> <h4 id="advanced-topics" class="position-relative d-flex align-items-center group"> Advanced Topics <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="advanced-topics" aria-haspopup="dialog" aria-label="Share link: Advanced Topics"> Share link </button> </h4><ul> <li><a href="/tags/transactions/" >Transaction Management</a> - ACID guarantees and isolation</li> <li><a href="/tags/distributed/" >Distributed Queries</a> - Multi-node query execution</li> <li><a href="/tags/security/" >Security</a> - Row-level security and query authorization</li> <li><a href="/tags/performance/" >Performance</a> - Benchmarks and optimization</li> </ul> <h3 id="advanced-query-patterns" class="position-relative d-flex align-items-center group"> Advanced Query 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="advanced-query-patterns" aria-haspopup="dialog" aria-label="Share link: Advanced Query Patterns"> Share link </button> </h3> <h4 id="complex-traversals-with-multiple-hops" class="position-relative d-flex align-items-center group"> Complex Traversals with Multiple Hops <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="complex-traversals-with-multiple-hops" aria-haspopup="dialog" aria-label="Share link: Complex Traversals with Multiple Hops"> Share link </button> </h4>Real-world graph applications often require sophisticated multi-hop traversals with conditional logic: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">// Find influencers in a social network MATCH (u:User) WHERE EXISTS { MATCH (u)<-[:FOLLOWS]-(follower) WITH follower WHERE follower.verified = true WITH count(follower) AS verified_followers WHERE verified_followers > 1000 } AND EXISTS { MATCH (u)-[:POSTED]->(p:Post) WHERE p.likes > 10000 WITH count(p) AS viral_posts WHERE viral_posts > 5 } RETURN u.name, SIZE((u)<-[:FOLLOWS]-()) AS total_followers, SIZE((u)-[:POSTED]->(:Post)) AS post_count ORDER BY total_followers DESC LIMIT 50 </code></pre></div> <h4 id="recursive-pattern-matching" class="position-relative d-flex align-items-center group"> Recursive 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="recursive-pattern-matching" aria-haspopup="dialog" aria-label="Share link: Recursive Pattern Matching"> Share link </button> </h4>GQL supports recursive patterns for hierarchical data: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">// Organizational hierarchy traversal MATCH path = (employee:Person {id: $employeeId}) -[:REPORTS_TO*0..]->(manager:Person) WHERE manager.role = 'CEO' RETURN [n IN nodes(path) | { name: n.name, title: n.title, level: length(path) - indexOf(nodes(path), n) }] AS hierarchy </code></pre></div> <h4 id="graph-algorithms-with-gql" class="position-relative d-flex align-items-center group"> Graph Algorithms with GQL <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="graph-algorithms-with-gql" aria-haspopup="dialog" aria-label="Share link: Graph Algorithms with GQL"> Share link </button> </h4>Implement graph algorithms using declarative GQL: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">// PageRank-style influence calculation MATCH (p:Page) WITH p, SIZE((p)<-[:LINKS_TO]-()) AS inbound_links WITH p, inbound_links, 1.0 + 0.85 * SUM( CASE WHEN inbound_links > 0 THEN 1.0 / inbound_links ELSE 0 END ) AS page_rank WHERE page_rank > 0.5 RETURN p.url, page_rank ORDER BY page_rank DESC LIMIT 100 </code></pre></div> <h3 id="performance-optimization-deep-dive" class="position-relative d-flex align-items-center group"> Performance Optimization Deep Dive <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="performance-optimization-deep-dive" aria-haspopup="dialog" aria-label="Share link: Performance Optimization Deep Dive"> Share link </button> </h3> <h4 id="index-strategy" class="position-relative d-flex align-items-center group"> Index Strategy <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="index-strategy" aria-haspopup="dialog" aria-label="Share link: Index Strategy"> Share link </button> </h4>Choosing the right indexes dramatically impacts query performance: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">// Multi-column composite index for complex queries CREATE INDEX user_activity_idx FOR (u:User) ON (u.country, u.status, u.created_at); // Covering index includes all needed properties CREATE INDEX product_search_idx FOR (p:Product) ON (p.category, p.price, p.availability) INCLUDE (p.name, p.description); // Full-text search index for text queries CREATE TEXT INDEX article_content_idx FOR (a:Article) ON (a.title, a.body) OPTIONS { analyzer: 'english', min_token_length: 3 }; </code></pre></div> <h4 id="query-rewriting-for-performance" class="position-relative d-flex align-items-center group"> Query Rewriting for 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-rewriting-for-performance" aria-haspopup="dialog" aria-label="Share link: Query Rewriting for Performance"> Share link </button> </h4>Transform queries to leverage indexes effectively: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- SLOW: Property filter in WHERE clause MATCH (u:User)-[:PURCHASED]->(p:Product) WHERE u.country = 'USA' RETURN p.name, count(u) AS buyers; -- FAST: Property filter in MATCH pattern MATCH (u:User {country: 'USA'})-[:PURCHASED]->(p:Product) RETURN p.name, count(u) AS buyers; -- EVEN FASTER: Use index hints MATCH (u:User {country: 'USA'})-[:PURCHASED]->(p:Product) USING INDEX user_activity_idx RETURN p.name, count(u) AS buyers; </code></pre></div> <h4 id="batch-operations" class="position-relative d-flex align-items-center group"> Batch Operations <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-operations" aria-haspopup="dialog" aria-label="Share link: Batch Operations"> Share link </button> </h4>Optimize bulk data operations: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">// Batch insert with UNWIND UNWIND $batch AS item CREATE (p:Product { id: item.id, name: item.name, price: item.price, created_at: timestamp() }); // Batch update with FOREACH MATCH (u:User) WHERE u.id IN $user_ids FOREACH (update IN $updates | MERGE (u {id: update.id}) SET u.last_login = update.timestamp ); // Parallel batch processing CALL { UNWIND range(0, $total_batches - 1) AS batch_num WITH batch_num, batch_num * $batch_size AS offset MATCH (n:Node) SKIP offset LIMIT $batch_size SET n.processed = true } IN TRANSACTIONS OF 1000 ROWS; </code></pre></div> <h3 id="advanced-features-and-extensions" class="position-relative d-flex align-items-center group"> Advanced Features and Extensions <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="advanced-features-and-extensions" aria-haspopup="dialog" aria-label="Share link: Advanced Features and Extensions"> Share link </button> </h3> <h4 id="temporal-queries" class="position-relative d-flex align-items-center group"> Temporal Queries <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="temporal-queries" aria-haspopup="dialog" aria-label="Share link: Temporal Queries"> Share link </button> </h4>GQL supports temporal data types and operations: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">// Time-based filtering MATCH (event:Event) WHERE event.timestamp >= datetime('2025-01-01T00:00:00Z') AND event.timestamp < datetime('2025-02-01T00:00:00Z') RETURN event.type, count(*) AS occurrences ORDER BY occurrences DESC; // Duration calculations MATCH (session:Session) WITH session, duration.between(session.start_time, session.end_time) AS session_length WHERE session_length > duration('PT30M') RETURN session.user_id, session_length ORDER BY session_length DESC; // Date arithmetic MATCH (subscription:Subscription) WHERE subscription.expires_at < date() + duration('P7D') AND subscription.auto_renew = false RETURN subscription.user_email, subscription.expires_at ORDER BY subscription.expires_at; </code></pre></div> <h4 id="geospatial-queries" class="position-relative d-flex align-items-center group"> Geospatial Queries <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="geospatial-queries" aria-haspopup="dialog" aria-label="Share link: Geospatial Queries"> Share link </button> </h4>Geode extends GQL with spatial operations: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">// Point-based proximity search MATCH (store:Store) WHERE point.distance( store.location, point({latitude: $user_lat, longitude: $user_lon}) ) < 5000 // meters RETURN store.name, store.address, point.distance(store.location, point({latitude: $user_lat, longitude: $user_lon})) AS distance ORDER BY distance LIMIT 10; // Polygon containment MATCH (property:Property) WHERE point.within( property.location, polygon($neighborhood_boundary) ) RETURN property.address, property.price; </code></pre></div> <h4 id="vector-similarity-search" class="position-relative d-flex align-items-center group"> Vector Similarity Search <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="vector-similarity-search" aria-haspopup="dialog" aria-label="Share link: Vector Similarity Search"> Share link </button> </h4>Combine graph traversal with vector search: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">// Semantic search over graph structures MATCH (doc:Document) WHERE vector.cosineSimilarity(doc.embedding, $query_embedding) > 0.8 OPTIONAL MATCH (doc)-[:CITES]->(cited:Document) RETURN doc.title, doc.abstract, vector.cosineSimilarity(doc.embedding, $query_embedding) AS similarity, collect(cited.title) AS citations ORDER BY similarity DESC LIMIT 20; // Hybrid search combining keywords and vectors MATCH (article:Article) WHERE article.content SEARCH $keywords WITH article, SCORE(article) AS text_score WHERE vector.cosineSimilarity(article.embedding, $query_vector) > 0.7 RETURN article.title, text_score, vector.cosineSimilarity(article.embedding, $query_vector) AS semantic_score, text_score * 0.4 + semantic_score * 0.6 AS combined_score ORDER BY combined_score DESC; </code></pre></div> <h3 id="client-library-integration" class="position-relative d-flex align-items-center group"> Client Library Integration <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-library-integration" aria-haspopup="dialog" aria-label="Share link: Client Library Integration"> Share link </button> </h3> <h4 id="python-advanced-usage" class="position-relative d-flex align-items-center group"> Python Advanced Usage <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-advanced-usage" aria-haspopup="dialog" aria-label="Share link: Python Advanced Usage"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python">from geode_client import Client, QueryBuilder import asyncio async def advanced_query_patterns(): client = Client(host="localhost", port=3141) async with client.connection() as conn: # Prepared statement caching stmt = await conn.prepare(""" MATCH (u:User {id: $user_id})-[:FRIEND*1..2]->(friend) RETURN DISTINCT friend.name, friend.email """) # Execute with different parameters for user_id in range(1, 100): result, _ = await stmt.execute(user_id=user_id) friends = [row for row in result.rows] print(f"User {user_id} has {len(friends)} friends") # Transaction with savepoints async with client.connection() as txn: await txn.begin() await txn.execute("CREATE (u:User {id: 1000, name: 'Alice'})") await txn.savepoint("after_user") try: await txn.execute(""" MATCH (u:User {id: 1000}) CREATE (u)-[:POSTED]->(p:Post {title: 'Hello'}) """) except Exception as e: await txn.rollback_to("after_user") print(f"Post creation failed: {e}") # Transaction commits automatically on context exit # Streaming large result sets query = """ MATCH (n:Node) RETURN n.id, n.data ORDER BY n.created_at """ async with client.stream(query) as stream: batch = [] for row in stream.rows: batch.append(row) if len(batch) >= 1000: await process_batch(batch) batch = [] if batch: await process_batch(batch) async def process_batch(batch): # Process batch of results pass asyncio.run(advanced_query_patterns()) </code></pre></div> <h4 id="go-advanced-usage" class="position-relative d-flex align-items-center group"> Go Advanced Usage <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-advanced-usage" aria-haspopup="dialog" aria-label="Share link: Go Advanced Usage"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-go" data-lang="go">package main import ( "context" "database/sql" "fmt" "time" _ "geodedb.com/geode" ) func advancedQueries() error { db, err := sql.Open("geode", "quic://localhost:3141") if err != nil { return err } defer db.Close() // Connection pooling configuration db.SetMaxOpenConns(25) db.SetMaxIdleConns(10) db.SetConnMaxLifetime(5 * time.Minute) ctx := context.Background() // Prepared statements stmt, err := db.PrepareContext(ctx, ` MATCH (u:User {id: $1})-[:PURCHASED]->(p:Product) WHERE p.price > $2 RETURN p.name, p.price ORDER BY p.price DESC `) if err != nil { return err } defer stmt.Close() // Execute with different parameters rows, err := stmt.QueryContext(ctx, 123, 100.0) if err != nil { return err } defer rows.Close() for rows.Next() { var name string var price float64 if err := rows.Scan(&name, &price); err != nil { return err } fmt.Printf("%s: $%.2f\n", name, price) } // Transaction with retry logic return withRetry(ctx, db, func(tx *sql.Tx) error { _, err := tx.ExecContext(ctx, ` MATCH (account:Account {id: $1}) WHERE account.balance >= $2 SET account.balance = account.balance - $2 `, "acc_123", 50.0) return err }) } func withRetry(ctx context.Context, db *sql.DB, fn func(*sql.Tx) error) error { maxRetries := 3 for attempt := 0; attempt < maxRetries; attempt++ { tx, err := db.BeginTx(ctx, nil) if err != nil { return err } err = fn(tx) if err != nil { tx.Rollback() if isSerializationError(err) && attempt < maxRetries-1 { time.Sleep(time.Millisecond * time.Duration(1<<attempt)) continue } return err } return tx.Commit() } return fmt.Errorf("max retries exceeded") } func isSerializationError(err error) bool { // Check for serialization error return false // Implement based on error codes } </code></pre></div> <h3 id="troubleshooting-common-issues" class="position-relative d-flex align-items-center group"> Troubleshooting Common 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="troubleshooting-common-issues" aria-haspopup="dialog" aria-label="Share link: Troubleshooting Common Issues"> Share link </button> </h3> <h4 id="query-performance-problems" class="position-relative d-flex align-items-center group"> Query Performance Problems <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-problems" aria-haspopup="dialog" aria-label="Share link: Query Performance Problems"> Share link </button> </h4>Symptom: Slow query execution Diagnosis: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Use EXPLAIN to see query plan EXPLAIN MATCH (u:User)-[:FRIEND*1..3]->(friend) WHERE u.country = 'USA' RETURN friend.name; -- Use PROFILE for detailed metrics PROFILE MATCH (u:User)-[:FRIEND*1..3]->(friend) WHERE u.country = 'USA' RETURN friend.name; </code></pre></div>Solutions: <ul> <li>Add indexes on frequently filtered properties</li> <li>Rewrite variable-length patterns with LIMIT</li> <li>Break complex queries into smaller pieces with WITH</li> <li>Use OPTIONAL MATCH instead of EXISTS when appropriate</li> </ul> <h4 id="memory-issues-with-large-result-sets" class="position-relative d-flex align-items-center group"> Memory Issues with Large Result Sets <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="memory-issues-with-large-result-sets" aria-haspopup="dialog" aria-label="Share link: Memory Issues with Large Result Sets"> Share link </button> </h4>Symptom: Out of memory errors Solutions: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Add LIMIT to bound results MATCH (n:Node) RETURN n LIMIT 10000; -- Use aggregation to reduce result size MATCH (u:User)-[:PURCHASED]->(p:Product) RETURN p.category, count(u) AS buyers ORDER BY buyers DESC; -- Process in batches MATCH (n:Node) WITH n SKIP $offset LIMIT $batch_size RETURN n; </code></pre></div> <h4 id="deadlock-and-conflict-errors" class="position-relative d-flex align-items-center group"> Deadlock and Conflict 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="deadlock-and-conflict-errors" aria-haspopup="dialog" aria-label="Share link: Deadlock and Conflict Errors"> Share link </button> </h4>Symptom: Transaction aborted due to conflicts Solutions: <ul> <li>Implement retry logic with exponential backoff</li> <li>Access resources in consistent order</li> <li>Keep transactions short</li> <li>Use optimistic locking patterns</li> </ul> <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python">from geode_client import QueryError async def retry_on_conflict(client, query, params, max_attempts=3): for attempt in range(max_attempts): async with client.connection() as conn: await conn.begin() try: page, _ = await conn.query(query, params) await conn.commit() return page except QueryError as exc: await conn.rollback() if "40502" not in str(exc): raise if attempt == max_attempts - 1: raise await asyncio.sleep(0.1 * (2 ** attempt)) </code></pre></div> <h3 id="production-deployment-best-practices" class="position-relative d-flex align-items-center group"> Production Deployment Best Practices <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="production-deployment-best-practices" aria-haspopup="dialog" aria-label="Share link: Production Deployment Best Practices"> Share link </button> </h3> <h4 id="monitoring-and-observability" class="position-relative d-flex align-items-center group"> Monitoring and Observability <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="monitoring-and-observability" aria-haspopup="dialog" aria-label="Share link: Monitoring and Observability"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python"># Export query metrics from prometheus_client import Counter, Histogram query_duration = Histogram( 'geode_query_duration_seconds', 'Query execution time', ['query_type'] ) query_errors = Counter( 'geode_query_errors_total', 'Query error count', ['error_type'] ) async def monitored_query(client, query, params): start = time.time() try: result, _ = await client.query(query, params) query_duration.labels(query_type='read').observe(time.time() - start) return result except Exception as e: query_errors.labels(error_type=type(e).__name__).inc() raise </code></pre></div> <h4 id="query-caching-strategy" class="position-relative d-flex align-items-center group"> Query Caching Strategy <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-caching-strategy" aria-haspopup="dialog" aria-label="Share link: Query Caching Strategy"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python">from functools import lru_cache import hashlib class QueryCache: def __init__(self, max_size=1000, ttl=300): self.cache = {} self.max_size = max_size self.ttl = ttl def get_cache_key(self, query, params): return hashlib.md5( f"{query}:{params}".encode() ).hexdigest() async def execute(self, client, query, params): cache_key = self.get_cache_key(query, params) if cache_key in self.cache: entry = self.cache[cache_key] if time.time() - entry['timestamp'] < self.ttl: return entry['result'] result, _ = await client.query(query, params) self.cache[cache_key] = { 'result': result, 'timestamp': time.time() } return result </code></pre></div> <h4 id="load-balancing-and-failover" class="position-relative d-flex align-items-center group"> Load Balancing and Failover <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="load-balancing-and-failover" aria-haspopup="dialog" aria-label="Share link: Load Balancing and Failover"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python">class GeodeCluster: def __init__(self, nodes): self.nodes = nodes self.current_index = 0 async def get_client(self): """Round-robin load balancing.""" for _ in range(len(self.nodes)): node = self.nodes[self.current_index] self.current_index = (self.current_index + 1) % len(self.nodes) try: client = Client(host=node['host'], port=node['port']) conn = await client.connect() try: await conn.query("RETURN 1") return conn except Exception: await conn.close() continue except Exception: continue raise Exception("No healthy nodes available") async def execute(self, query, params): conn = await self.get_client() try: result, _ = await conn.query(query, params) return result finally: await conn.close() </code></pre></div>Geode’s GQL implementation aligned with the conformance profile provides a production-ready platform for graph workloads. Whether you’re building social networks, fraud detection systems, recommendation engines, or knowledge graphs, GQL’s declarative syntax and Geode’s optimized execution deliver both developer productivity and runtime performance.

Popular

Tag: Graph Query Language (GQL)

Related Articles

Advanced Pattern Matching Reference

Aggregation Functions

GQL Quick Reference

GQL Conformance Profile

Built-in Functions Reference

EXPLAIN Command

GQL Language

PROFILE Command

Migrating from Neo4j to Geode

Migrating from PostgreSQL to Geode

Migrating from MongoDB to Geode

Advanced GQL Query Patterns