Category: Tutorials & Learning Guides

The Tutorials & Learning Guides category provides structured, hands-on learning paths for mastering Geode graph database. From installation through advanced features, these tutorials build skills progressively with complete code examples, expected outputs, and practical exercises. <h3 id="introduction" class="position-relative d-flex align-items-center group"> Introduction <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" aria-haspopup="dialog" aria-label="Share link: Introduction"> 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>Learning a new database is most effective through hands-on practice with guided examples. Geode’s tutorials are designed for progressive skill building: start with installation and basic queries, advance to pattern matching and indexing, explore transactions and concurrency, and master advanced features like vector search and graph algorithms. Each tutorial is self-contained with setup instructions, complete code, expected results, and exercises for practice. Tutorials span beginner through advanced levels. Beginners learn installation, REPL basics, and simple MATCH patterns. Intermediate users explore indexing strategies, transaction management, and query optimization. Advanced users master vector search, graph algorithms, Row-Level Security, and production deployment patterns. Whether learning alone or training a team, these tutorials provide structured learning paths. <h3 id="what-youll-find" class="position-relative d-flex align-items-center group"> What You&rsquo;ll Find <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-youll-find" aria-haspopup="dialog" aria-label="Share link: What Youll Find"> Share link </button> </h3> <h4 id="getting-started-tutorials" class="position-relative d-flex align-items-center group"> Getting Started Tutorials <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="getting-started-tutorials" aria-haspopup="dialog" aria-label="Share link: Getting Started Tutorials"> Share link </button> </h4>Installation and Setup <ul> <li>Installing Geode (Docker, binary, source)</li> <li>Starting the database server</li> <li>Connecting with the REPL shell</li> <li>Creating your first graph</li> <li>Basic CRUD operations</li> <li>Understanding graph structure</li> </ul> REPL Basics <ul> <li>Interactive shell features</li> <li>Multi-line query editing</li> <li>Result formatting options</li> <li>History and search</li> <li>Meta-commands</li> <li>Saving and loading sessions</li> </ul> <h4 id="query-language-tutorials" class="position-relative d-flex align-items-center group"> Query Language Tutorials <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-language-tutorials" aria-haspopup="dialog" aria-label="Share link: Query Language Tutorials"> Share link </button> </h4>Pattern Matching Fundamentals <ul> <li>Basic node patterns</li> <li>Relationship patterns</li> <li>Variable-length paths</li> <li>Pattern composition</li> <li>Optional patterns with EXISTS</li> <li>Filtering with WHERE</li> </ul> Data Manipulation <ul> <li>Inserting nodes and relationships</li> <li>Updating properties with SET</li> <li>Removing properties</li> <li>Deleting nodes and relationships</li> <li>Merging patterns</li> <li>Bulk operations</li> </ul> Aggregations and Analytics <ul> <li>COUNT, SUM, AVG, MIN, MAX</li> <li>GROUP BY for grouping</li> <li>COLLECT for arrays</li> <li>DISTINCT for uniqueness</li> <li>Nested aggregations</li> <li>Window functions</li> </ul> <h4 id="advanced-tutorials" class="position-relative d-flex align-items-center group"> Advanced Tutorials <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-tutorials" aria-haspopup="dialog" aria-label="Share link: Advanced Tutorials"> Share link </button> </h4>Indexing Strategies <ul> <li>Creating B+tree indexes</li> <li>Unique constraints</li> <li>Composite indexes</li> <li>Vector indexes (HNSW)</li> <li>Full-text search (BM25)</li> <li>Index selection and optimization</li> </ul> Transaction Management <ul> <li>BEGIN/COMMIT/ROLLBACK</li> <li>Savepoints for partial rollback</li> <li>Transaction isolation levels</li> <li>Handling conflicts</li> <li>Deadlock prevention</li> <li>Concurrent access patterns</li> </ul> Graph Algorithms <ul> <li>PageRank for centrality</li> <li>Community detection</li> <li>Shortest path algorithms</li> <li>Path finding strategies</li> <li>Graph traversal patterns</li> <li>Custom algorithm implementation</li> </ul> Vector Search <ul> <li>Storing embeddings</li> <li>Creating HNSW indexes</li> <li>Similarity search queries</li> <li>Combining vector and graph queries</li> <li>RAG (Retrieval Augmented Generation)</li> <li>Semantic search patterns</li> </ul> <h4 id="production-tutorials" class="position-relative d-flex align-items-center group"> Production Tutorials <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-tutorials" aria-haspopup="dialog" aria-label="Share link: Production Tutorials"> Share link </button> </h4>Performance Optimization <ul> <li>Query profiling with EXPLAIN/PROFILE</li> <li>Index optimization</li> <li>Query rewriting for performance</li> <li>Connection pooling</li> <li>Batch operations</li> <li>Caching strategies</li> </ul> Security Configuration <ul> <li>Setting up authentication</li> <li>Configuring Row-Level Security</li> <li>Enabling encryption (TDE/FLE)</li> <li>Audit logging configuration</li> <li>Certificate management</li> <li>Security best practices</li> </ul> Deployment Patterns <ul> <li>Docker deployment</li> <li>Kubernetes deployment</li> <li>High availability setup</li> <li>Backup and restore</li> <li>Monitoring configuration</li> <li>Production checklist</li> </ul> <h3 id="learning-paths" class="position-relative d-flex align-items-center group"> Learning Paths <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="learning-paths" aria-haspopup="dialog" aria-label="Share link: Learning Paths"> Share link </button> </h3> <h4 id="path-1-database-beginner" class="position-relative d-flex align-items-center group"> Path 1: Database Beginner <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-1-database-beginner" aria-haspopup="dialog" aria-label="Share link: Path 1: Database Beginner"> Share link </button> </h4><ol> <li>Installation Tutorial - Set up Geode locally</li> <li>REPL Basics - Learn interactive shell</li> <li>First Graph - Create simple graph structure</li> <li>Basic Queries - Master MATCH and RETURN</li> <li>CRUD Operations - Insert, update, delete data</li> <li>Simple Patterns - Query relationships</li> </ol> Estimated time: 4-6 hours <h4 id="path-2-gql-developer" class="position-relative d-flex align-items-center group"> Path 2: GQL Developer <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-2-gql-developer" aria-haspopup="dialog" aria-label="Share link: Path 2: GQL Developer"> Share link </button> </h4><ol> <li>Advanced Patterns - Complex graph patterns</li> <li>Aggregations - Analytics queries</li> <li>Subqueries - Nested query logic</li> <li>Transactions - ACID operations</li> <li>Query Optimization - Performance tuning</li> <li>Client Integration - Application development</li> </ol> Estimated time: 8-12 hours <h4 id="path-3-production-engineer" class="position-relative d-flex align-items-center group"> Path 3: Production Engineer <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-3-production-engineer" aria-haspopup="dialog" aria-label="Share link: Path 3: Production Engineer"> Share link </button> </h4><ol> <li>Indexing Strategies - Optimize queries</li> <li>Performance Tuning - System optimization</li> <li>Security Setup - Authentication and encryption</li> <li>Monitoring - Prometheus integration</li> <li>Backup/Recovery - Disaster recovery</li> <li>Production Deployment - Go-live checklist</li> </ol> Estimated time: 12-16 hours <h4 id="path-4-advanced-features" class="position-relative d-flex align-items-center group"> Path 4: Advanced Features <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-4-advanced-features" aria-haspopup="dialog" aria-label="Share link: Path 4: Advanced Features"> Share link </button> </h4><ol> <li>Vector Search - Embedding-based search</li> <li>Graph Algorithms - PageRank, communities</li> <li>Row-Level Security - Fine-grained access</li> <li>CDC Streaming - Change data capture</li> <li>Advanced Optimization - Expert tuning</li> <li>Custom Extensions - Extending Geode</li> </ol> Estimated time: 16-20 hours <h3 id="tutorial-format" class="position-relative d-flex align-items-center group"> Tutorial Format <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="tutorial-format" aria-haspopup="dialog" aria-label="Share link: Tutorial Format"> Share link </button> </h3>Each tutorial follows a consistent structure: <ol> <li>Learning Objectives - What you’ll learn</li> <li>Prerequisites - Required knowledge and setup</li> <li>Overview - Concept introduction</li> <li>Step-by-Step Instructions - Detailed walkthrough</li> <li>Code Examples - Complete, runnable code</li> <li>Expected Output - Verification of results</li> <li>Exercises - Practice problems</li> <li>Troubleshooting - Common issues and solutions</li> <li>Next Steps - Suggested follow-up tutorials</li> <li>Additional Resources - Further reading</li> </ol> <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>All tutorials include complete, tested code examples: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Example from Pattern Matching Tutorial MATCH (person:Person)-[:WORKS_AT]->(company:Company) WHERE person.age > 30 AND company.industry = 'Technology' RETURN person.name AS employee, company.name AS employer, person.salary AS salary ORDER BY person.salary DESC LIMIT 10; </code></pre></div><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python"># Example from Client Library Tutorial import geode_client import asyncio async def get_employee_data(): client = geode_client.open_database('quic://localhost:3141') async with client.connection() as conn: result, _ = await conn.query(""" MATCH (p:Person)-[:WORKS_AT]->(c:Company) WHERE p.age > 30 RETURN p.name, c.name """) employees = [] for row in result.rows: employees.append({ 'name': row[0], 'company': row[1] }) return employees # Run tutorial example employees = asyncio.run(get_employee_data()) for emp in employees: print(f"{emp['name']} works at {emp['company']}") </code></pre></div> <h3 id="practice-exercises" class="position-relative d-flex align-items-center group"> Practice Exercises <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="practice-exercises" aria-haspopup="dialog" aria-label="Share link: Practice Exercises"> Share link </button> </h3>Tutorials include exercises for skill reinforcement: Exercise: Friend Recommendations <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- TODO: Write a query that finds friends-of-friends -- who share at least 2 common interests with the user -- but are not already friends MATCH (user:Person {name: 'Alice'})... -- Complete this query </code></pre></div>Exercise: Performance Optimization <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- TODO: Optimize this slow query using indexes -- Current execution time: 2.5 seconds -- Target execution time: <100ms MATCH (p:Person) WHERE p.email LIKE '%@example.com' RETURN p.name, p.email -- Hint: Consider index strategy </code></pre></div> <h3 id="related-categories" class="position-relative d-flex align-items-center group"> Related Categories <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-categories" aria-haspopup="dialog" aria-label="Share link: Related Categories"> Share link </button> </h3><ul> <li><a href="/categories/getting-started/" >Getting Started</a> - Initial setup</li> <li><a href="/categories/gql/" >GQL</a> - Query language reference</li> <li><a href="/categories/use-cases/" >Use Cases</a> - Real-world applications</li> <li><a href="/categories/examples/" >Examples</a> - Code examples</li> <li><a href="/categories/best-practices/" >Best Practices</a> - Guidelines</li> <li><a href="/categories/development/" >Development</a> - Development workflow</li> </ul> <h3 id="related-tags" class="position-relative d-flex align-items-center group"> Related Tags <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-tags" aria-haspopup="dialog" aria-label="Share link: Related Tags"> Share link </button> </h3><ul> <li><a href="/tags/tutorial/" >Tutorial</a> - Tutorial content</li> <li><a href="/tags/learning/" >Learning</a> - Learning resources</li> <li><a href="/tags/getting-started/" >Getting Started</a> - Beginner content</li> <li><a href="/tags/hands-on/" >Hands-On</a> - Practical exercises</li> <li><a href="/tags/examples/" >Examples</a> - Code examples</li> <li><a href="/tags/repl/" >REPL</a> - Interactive shell</li> <li><a href="/tags/gql/" >GQL</a> - Query language</li> </ul> <h3 id="interactive-tutorials" class="position-relative d-flex align-items-center group"> Interactive Tutorials <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="interactive-tutorials" aria-haspopup="dialog" aria-label="Share link: Interactive Tutorials"> Share link </button> </h3> <h4 id="beginner-tutorial-your-first-graph" class="position-relative d-flex align-items-center group"> Beginner Tutorial: 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="beginner-tutorial-your-first-graph" aria-haspopup="dialog" aria-label="Share link: Beginner Tutorial: Your First Graph"> Share link </button> </h4>Learning Objective: Create a simple social network and query it. Prerequisites: Geode installed and running. Step 1: Start the REPL <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash">geode shell Connected to Geode v0.2.18 geode> </code></pre></div>Step 2: Create Your First Nodes <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">geode> CREATE (alice:Person {name: 'Alice', age: 30, city: 'San Francisco'}); Created 1 node geode> CREATE (bob:Person {name: 'Bob', age: 25, city: 'New York'}); Created 1 node geode> CREATE (carol:Person {name: 'Carol', age: 28, city: 'San Francisco'}); Created 1 node </code></pre></div>Step 3: Create Relationships <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">geode> MATCH (a:Person {name: 'Alice'}), (b:Person {name: 'Bob'}) CREATE (a)-[:KNOWS {since: 2020}]->(b); Created 1 relationship geode> MATCH (a:Person {name: 'Alice'}), (c:Person {name: 'Carol'}) CREATE (a)-[:KNOWS {since: 2019}]->(c); Created 1 relationship geode> MATCH (b:Person {name: 'Bob'}), (c:Person {name: 'Carol'}) CREATE (b)-[:KNOWS {since: 2021}]->(c); Created 1 relationship </code></pre></div>Step 4: Query the Graph <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">geode> MATCH (p:Person) RETURN p.name, p.age, p.city; ┌─────────┬──────┬─────────────────┐ │ name │ age │ city │ ├─────────┼──────┼─────────────────┤ │ Alice │ 30 │ San Francisco │ │ Bob │ 25 │ New York │ │ Carol │ 28 │ San Francisco │ └─────────┴──────┴─────────────────┘ </code></pre></div>Step 5: Find Connections <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">geode> MATCH (a:Person {name: 'Alice'})-[:KNOWS]->(friend) RETURN friend.name, friend.city; ┌─────────┬─────────────────┐ │ name │ city │ ├─────────┼─────────────────┤ │ Bob │ New York │ │ Carol │ San Francisco │ └─────────┴─────────────────┘ </code></pre></div>Exercise: Add yourself to the graph and create friendships. Then find all people who know at least 2 people. <h4 id="intermediate-tutorial-building-a-recommendation-engine" class="position-relative d-flex align-items-center group"> Intermediate Tutorial: Building a Recommendation Engine <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="intermediate-tutorial-building-a-recommendation-engine" aria-haspopup="dialog" aria-label="Share link: Intermediate Tutorial: Building a Recommendation Engine"> Share link </button> </h4>Learning Objective: Implement collaborative filtering recommendations. Scenario: A movie recommendation system based on user ratings. Step 1: Create the Data Model <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python">import geode_client import asyncio async def setup_movie_database(): client = geode_client.open_database('quic://localhost:3141') async with client.connection() as conn: # Create movies movies = [ {'title': 'The Matrix', 'genre': 'Sci-Fi', 'year': 1999}, {'title': 'Inception', 'genre': 'Sci-Fi', 'year': 2010}, {'title': 'Interstellar', 'genre': 'Sci-Fi', 'year': 2014}, {'title': 'The Shawshank Redemption', 'genre': 'Drama', 'year': 1994}, ] for movie in movies: await conn.execute(""" CREATE (:Movie { title: $title, genre: $genre, year: $year }) """, movie) # Create users users = ['Alice', 'Bob', 'Carol', 'Dave'] for user in users: await conn.execute(""" CREATE (:User {name: $name}) """, {'name': user}) # Create ratings ratings = [ ('Alice', 'The Matrix', 5), ('Alice', 'Inception', 4), ('Bob', 'The Matrix', 5), ('Bob', 'Interstellar', 5), ('Carol', 'Inception', 4), ('Carol', 'Interstellar', 5), ('Dave', 'The Shawshank Redemption', 5), ] for user_name, movie_title, rating in ratings: await conn.execute(""" MATCH (u:User {name: $user}), (m:Movie {title: $movie}) CREATE (u)-[:RATED {score: $score}]->(m) """, {'user': user_name, 'movie': movie_title, 'score': rating}) asyncio.run(setup_movie_database()) </code></pre></div>Step 2: Implement Collaborative Filtering <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python">async def get_recommendations(user_name, limit=5): """Get movie recommendations for a user.""" client = geode_client.open_database('quic://localhost:3141') async with client.connection() as conn: result, _ = await conn.query(""" // Find users with similar taste MATCH (me:User {name: $user})-[my_rating:RATED]->(movie:Movie) <-[their_rating:RATED]-(similar:User) -[rec_rating:RATED]->(recommendation:Movie) WHERE NOT EXISTS { MATCH (me)-[:RATED]->(recommendation) } // Calculate similarity based on common ratings WITH recommendation, AVG(rec_rating.score) AS avg_score, COUNT(DISTINCT similar) AS similar_user_count RETURN recommendation.title AS title, recommendation.genre AS genre, avg_score, similar_user_count ORDER BY similar_user_count DESC, avg_score DESC LIMIT $limit """, {'user': user_name, 'limit': limit}) recommendations = [] for row in result.rows: recommendations.append({ 'title': row['title'], 'genre': row['genre'], 'predicted_score': row['avg_score'], 'confidence': row['similar_user_count'] }) return recommendations # Test recommendations recs = asyncio.run(get_recommendations('Alice')) for rec in recs: print(f"{rec['title']}: {rec['predicted_score']:.1f} " f"(confidence: {rec['confidence']} users)") </code></pre></div>Expected Output: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-fallback" data-lang="fallback">Interstellar: 5.0 (confidence: 2 users) The Shawshank Redemption: 5.0 (confidence: 1 user) </code></pre></div>Exercise: Implement content-based filtering that recommends movies in the same genre with similar ratings. <h4 id="advanced-tutorial-real-time-fraud-detection" class="position-relative d-flex align-items-center group"> Advanced Tutorial: Real-Time 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="advanced-tutorial-real-time-fraud-detection" aria-haspopup="dialog" aria-label="Share link: Advanced Tutorial: Real-Time Fraud Detection"> Share link </button> </h4>Learning Objective: Build a fraud detection system using graph patterns. Scenario: Detect suspicious transaction patterns in financial data. Step 1: Transaction Data Model <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python">async def create_transaction_network(): client = geode_client.open_database('quic://localhost:3141') async with client.connection() as conn: # Create accounts for i in range(1, 11): await conn.execute(""" CREATE (:Account { id: $id, balance: $balance, created: $created }) """, { 'id': i, 'balance': 10000.0, 'created': '2025-01-01' }) # Simulate normal transactions normal_transactions = [ (1, 2, 100, '2025-01-24T10:00:00Z'), (2, 3, 50, '2025-01-24T11:00:00Z'), (3, 4, 75, '2025-01-24T12:00:00Z'), ] for from_id, to_id, amount, timestamp in normal_transactions: await conn.execute(""" MATCH (from:Account {id: $from}), (to:Account {id: $to}) CREATE (from)-[:TRANSFER { amount: $amount, timestamp: $timestamp }]->(to) """, {'from': from_id, 'to': to_id, 'amount': amount, 'timestamp': timestamp}) # Simulate suspicious circular transactions circular = [ (5, 6, 1000, '2025-01-24T13:00:00Z'), (6, 7, 900, '2025-01-24T13:05:00Z'), (7, 5, 850, '2025-01-24T13:10:00Z'), ] for from_id, to_id, amount, timestamp in circular: await conn.execute(""" MATCH (from:Account {id: $from}), (to:Account {id: $to}) CREATE (from)-[:TRANSFER { amount: $amount, timestamp: $timestamp, flagged: false }]->(to) """, {'from': from_id, 'to': to_id, 'amount': amount, 'timestamp': timestamp}) asyncio.run(create_transaction_network()) </code></pre></div>Step 2: Detect Circular Transactions <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python">async def detect_circular_transactions(time_window_hours=24): """Find circular money flows within time window.""" client = geode_client.open_database('quic://localhost:3141') async with client.connection() as conn: result, _ = await conn.query(""" MATCH path = (a1:Account)-[t1:TRANSFER]->(a2:Account) -[t2:TRANSFER]->(a3:Account) -[t3:TRANSFER]->(a1) WHERE t1.timestamp > current_timestamp() - INTERVAL '$hours' HOUR AND t2.timestamp > t1.timestamp AND t3.timestamp > t2.timestamp AND t3.timestamp < t1.timestamp + INTERVAL '1' HOUR RETURN a1.id AS account1, a2.id AS account2, a3.id AS account3, t1.amount + t2.amount + t3.amount AS total_amount, [t1.timestamp, t2.timestamp, t3.timestamp] AS timestamps """, {'hours': time_window_hours}) suspicious_patterns = [] for row in result.rows: suspicious_patterns.append({ 'accounts': [row['account1'], row['account2'], row['account3']], 'total_amount': row['total_amount'], 'timestamps': row['timestamps'] }) return suspicious_patterns # Detect fraud fraud_cases = asyncio.run(detect_circular_transactions()) for case in fraud_cases: print(f"Circular transaction detected: {case['accounts']}") print(f" Total amount: ${case['total_amount']}") print(f" Time span: {case['timestamps'][0]} to {case['timestamps'][-1]}") </code></pre></div>Step 3: Velocity Check Implementation <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python">async def velocity_check(account_id, threshold_multiplier=5): """Detect accounts with unusual transaction velocity.""" client = geode_client.open_database('quic://localhost:3141') async with client.connection() as conn: result, _ = await conn.query(""" MATCH (a:Account {id: $account_id})-[t:TRANSFER]->() WITH a, COUNT{(a)-[recent:TRANSFER]->() WHERE recent.timestamp > current_timestamp() - INTERVAL '1' HOUR} AS recent_count, AVG(t.amount) AS historical_avg WHERE recent_count > $threshold * historical_avg RETURN a.id AS account_id, recent_count AS recent_transactions, historical_avg AS normal_rate """, {'account_id': account_id, 'threshold': threshold_multiplier}) return result.rows[0] if result.rows else None # Check specific account alert = asyncio.run(velocity_check(5)) if alert: print(f"⚠️ Velocity alert for account {alert['account_id']}") print(f" Recent transactions: {alert['recent_transactions']}") print(f" Normal rate: {alert['normal_rate']}") </code></pre></div>Exercise: Implement a shared device detector that finds multiple accounts accessing from the same IP address or device ID. <h3 id="tutorial-videos-and-screencasts" class="position-relative d-flex align-items-center group"> Tutorial Videos and Screencasts <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="tutorial-videos-and-screencasts" aria-haspopup="dialog" aria-label="Share link: Tutorial Videos and Screencasts"> Share link </button> </h3>While primarily text-based, Geode tutorials benefit from visual demonstrations: Available Video Tutorials: <ol> <li>“Getting Started with Geode” (15 minutes)</li> <li>“Pattern Matching Deep Dive” (30 minutes)</li> <li>“Building a Social Network” (45 minutes)</li> <li>“Transaction Management Best Practices” (25 minutes)</li> <li>“Performance Tuning and Profiling” (40 minutes)</li> </ol> Access videos at: <code>https://geodedb.com/videos/</code> <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="connection-errors" class="position-relative d-flex align-items-center group"> Connection 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="connection-errors" aria-haspopup="dialog" aria-label="Share link: Connection Errors"> Share link </button> </h4>Problem: Cannot connect to Geode server <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-fallback" data-lang="fallback">Error: connection refused at localhost:3141 </code></pre></div>Solution: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># Check if server is running ps aux | grep geode # Start server if not running geode serve --listen 0.0.0.0:3141 # Check firewall rules sudo ufw status sudo ufw allow 3141/tcp </code></pre></div> <h4 id="query-performance-issues" class="position-relative d-flex align-items-center group"> Query Performance 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="query-performance-issues" aria-haspopup="dialog" aria-label="Share link: Query Performance Issues"> Share link </button> </h4>Problem: Query taking too long Solution: Use PROFILE to identify bottlenecks <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">PROFILE MATCH (u:User)-[:FRIEND*2..3]-(friend) WHERE u.city = 'San Francisco' RETURN friend.name -- Review execution plan -- Look for full scans vs. index scans -- Add indexes on frequently filtered properties CREATE INDEX user_city ON :User(city); </code></pre></div> <h4 id="memory-errors" class="position-relative d-flex align-items-center group"> Memory 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="memory-errors" aria-haspopup="dialog" aria-label="Share link: Memory Errors"> Share link </button> </h4>Problem: Out of memory during large queries Solution: Use pagination and streaming <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python">async def paginated_query(page_size=1000): """Process large result sets in chunks.""" offset = 0 client = geode_client.open_database('quic://localhost:3141') async with client.connection() as conn: while True: result, _ = await conn.query(""" MATCH (n:Node) RETURN n ORDER BY n.id SKIP $offset LIMIT $limit """, {'offset': offset, 'limit': page_size}) rows = [] for row in result.rows: rows.append(row) if not rows: break # Process chunk process_chunk(rows) offset += page_size </code></pre></div> <h3 id="tutorial-completion-checklist" class="position-relative d-flex align-items-center group"> Tutorial Completion Checklist <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="tutorial-completion-checklist" aria-haspopup="dialog" aria-label="Share link: Tutorial Completion Checklist"> Share link </button> </h3>After completing tutorials, verify your knowledge: <ul> <li><input disabled="" type="checkbox"> Can create nodes and relationships</li> <li><input disabled="" type="checkbox"> Understand pattern matching syntax</li> <li><input disabled="" type="checkbox"> Can write WHERE clause filters</li> <li><input disabled="" type="checkbox"> Know how to use aggregation functions</li> <li><input disabled="" type="checkbox"> Understand transaction boundaries</li> <li><input disabled="" type="checkbox"> Can create and use indexes</li> <li><input disabled="" type="checkbox"> Able to profile and optimize queries</li> <li><input disabled="" type="checkbox"> Familiar with at least one client library</li> <li><input disabled="" type="checkbox"> Can implement basic graph algorithms</li> <li><input disabled="" type="checkbox"> Understand security best practices</li> </ul> <h3 id="next-steps-after-tutorials" class="position-relative d-flex align-items-center group"> Next Steps After Tutorials <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-after-tutorials" aria-haspopup="dialog" aria-label="Share link: Next Steps After Tutorials"> Share link </button> </h3><ol> <li>Build a small project: Apply knowledge to a real use case</li> <li>Read API documentation: Deep dive into specific features</li> <li>Join community: Share experiences and ask questions</li> <li>Contribute: Report bugs or contribute documentation</li> <li>Production deployment: Plan and execute production rollout</li> </ol> <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><ul> <li><a href="/docs/" >Documentation Index</a> - Complete documentation</li> <li><a href="/docs/api-reference/" >API Reference</a> - API documentation</li> <li><a href="/docs/gql-reference/" >GQL Reference</a> - Syntax reference</li> <li><a href="/docs/getting-started/" >Getting Started</a> - Get started with Geode</li> <li><a href="/docs/use-cases/" >Use Cases</a> - Sample applications and use cases</li> <li><a href="/docs/deployment/" >Deployment</a> - Going to production</li> <li><a href="/docs/performance/" >Performance</a> - Optimization techniques</li> <li><a href="/docs/security/" >Security</a> - Security configuration</li> </ul>

Popular

Related Articles

Graph Query Language (GQL) Guide

Tutorials and Examples

GQL Tutorial

Tutorials

REPL Interactive Shell Basics