Database Features

Geode is an enterprise-ready graph database packed with production-grade features for reliability, performance, security, and scalability. This comprehensive guide covers all major database capabilities. <h3 id="core-transaction-features" class="position-relative d-flex align-items-center group"> Core Transaction 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="core-transaction-features" aria-haspopup="dialog" aria-label="Share link: Core Transaction Features"> 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> <h4 id="acid-compliance" class="position-relative d-flex align-items-center group"> ACID Compliance <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="acid-compliance" aria-haspopup="dialog" aria-label="Share link: ACID Compliance"> Share link </button> </h4>Geode provides full ACID guarantees for data integrity: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">// Atomic operations BEGIN TRANSACTION; CREATE (:Account {id: 1, balance: 1000}); CREATE (:Account {id: 2, balance: 500}); MATCH (a:Account {id: 1}), (b:Account {id: 2}) SET a.balance = a.balance - 100, b.balance = b.balance + 100; COMMIT; // Rollback on error BEGIN TRANSACTION; MATCH (a:Account {id: 1}) SET a.balance = a.balance - 10000; // Would go negative // Automatically rolled back if constraint fails COMMIT; </code></pre></div> <h4 id="isolation-levels" class="position-relative d-flex align-items-center group"> Isolation Levels <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="isolation-levels" aria-haspopup="dialog" aria-label="Share link: Isolation Levels"> Share link </button> </h4>Geode implements Serializable Snapshot Isolation (SSI) by default, the strongest isolation level, preventing all anomalies including phantom reads, dirty reads, and write skew. <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python"># Python client with explicit isolation async with client.connection() as tx: # Isolation is configured server-side await tx.begin() result, _ = await tx.query("MATCH (u:User {id: $id}) RETURN u", {"id": 123}) await tx.query("CREATE (:AuditLog {user_id: $id, action: 'login'})", {"id": 123}) await tx.commit() </code></pre></div> <h4 id="savepoints" class="position-relative d-flex align-items-center group"> Savepoints <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="savepoints" aria-haspopup="dialog" aria-label="Share link: Savepoints"> Share link </button> </h4>Nested transaction control with savepoints: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">BEGIN TRANSACTION; CREATE (:User {id: 1, name: 'Alice'}); SAVEPOINT sp1; CREATE (:User {id: 2, name: 'Bob'}); ROLLBACK TO SAVEPOINT sp1; // Removes Bob, keeps Alice CREATE (:User {id: 3, name: 'Charlie'}); COMMIT; // Commits Alice and Charlie </code></pre></div> <h3 id="indexing-and-performance" class="position-relative d-flex align-items-center group"> Indexing and 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="indexing-and-performance" aria-haspopup="dialog" aria-label="Share link: Indexing and Performance"> Share link </button> </h3> <h4 id="index-types" class="position-relative d-flex align-items-center group"> Index Types <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-types" aria-haspopup="dialog" aria-label="Share link: Index Types"> Share link </button> </h4>Multiple index types for different access patterns: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">// B-tree index (range queries, sorting) CREATE INDEX FOR (p:Product) ON (p.price); // Hash index (equality lookups) CREATE HASH INDEX FOR (u:User) ON (u.id); // Text index (full-text search) CREATE TEXT INDEX FOR (p:Post) ON (p.content); // Composite index (multi-column) CREATE INDEX FOR (u:User) ON (u.last_name, u.first_name); // HNSW vector index (similarity search) CREATE VECTOR INDEX FOR (d:Document) ON (d.embedding) OPTIONS {metric: 'cosine', dimensions: 768, m: 16, ef_construction: 200}; // BM25 index (ranking search) CREATE BM25 INDEX FOR (a:Article) ON (a.title, a.body); </code></pre></div> <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>Built-in query optimization and execution planning: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">// Explain query plan EXPLAIN MATCH (u:User)-[:PURCHASED]->(p:Product) WHERE p.price > 100 RETURN u.name, COUNT(p); // Profile execution with metrics PROFILE MATCH (u:User)-[:PURCHASED]->(p:Product) WHERE p.price > 100 RETURN u.name, COUNT(p); </code></pre></div> <h3 id="security-features" class="position-relative d-flex align-items-center group"> Security 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="security-features" aria-haspopup="dialog" aria-label="Share link: Security Features"> Share link </button> </h3> <h4 id="row-level-security-rls" class="position-relative d-flex align-items-center group"> Row-Level Security (RLS) <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="row-level-security-rls" aria-haspopup="dialog" aria-label="Share link: Row-Level Security (RLS)"> Share link </button> </h4>Fine-grained access control at the data level: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">// Create RLS policy CREATE POLICY tenant_isolation ON User USING (tenant_id = current_setting('app.tenant_id')); // Apply policy ALTER LABEL User ENABLE ROW LEVEL SECURITY; // Set session context SET app.tenant_id = 'acme'; // Query only sees tenant's data MATCH (u:User) RETURN u; // Automatically filtered </code></pre></div> <h4 id="encryption" class="position-relative d-flex align-items-center group"> Encryption <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="encryption" aria-haspopup="dialog" aria-label="Share link: Encryption"> Share link </button> </h4>Data protection at rest and in transit: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">// Transparent Data Encryption (TDE) -- Configured at server level, encrypts all data files // Field-Level Encryption (FLE) CREATE (:User { name: 'Alice', ssn: ENCRYPT('123-45-6789', 'user-key'), email: ENCRYPT('alice@example.com', 'user-key') }); // Decrypt on retrieval MATCH (u:User {name: 'Alice'}) RETURN u.name, DECRYPT(u.ssn, 'user-key') AS ssn; </code></pre></div> <h4 id="authentication-and-authorization" class="position-relative d-flex align-items-center group"> Authentication and Authorization <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="authentication-and-authorization" aria-haspopup="dialog" aria-label="Share link: Authentication and Authorization"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python"># Client authentication client = Client( 'localhost:3141', username='admin', password='secure-password', tls_verify=True ) # Role-based access control await client.execute(""" CREATE ROLE analyst; GRANT SELECT ON * TO analyst; GRANT analyst TO user_bob; """) </code></pre></div> <h3 id="replication-and-high-availability" class="position-relative d-flex align-items-center group"> Replication and High Availability <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="replication-and-high-availability" aria-haspopup="dialog" aria-label="Share link: Replication and High Availability"> Share link </button> </h3> <h4 id="streaming-replication" class="position-relative d-flex align-items-center group"> Streaming Replication <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="streaming-replication" aria-haspopup="dialog" aria-label="Share link: Streaming Replication"> Share link </button> </h4>Real-time data replication to standby servers: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># Configure primary geode serve --listen 0.0.0.0:3141 --replication-mode primary # Configure replica geode serve --listen 0.0.0.0:3142 --replication-mode replica --primary-host primary-host:3141 </code></pre></div> <h4 id="change-data-capture-cdc" class="position-relative d-flex align-items-center group"> Change Data Capture (CDC) <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="change-data-capture-cdc" aria-haspopup="dialog" aria-label="Share link: Change Data Capture (CDC)"> Share link </button> </h4>Stream database changes to external systems: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python"># Poll application ChangeLog last_seen = "1970-01-01T00:00:00Z" async with client.connection() as conn: result, _ = await conn.query( """ MATCH (e:ChangeLog) WHERE e.emitted_at > $since AND e.label IN $labels RETURN e.operation AS operation, e.label AS label, e.after AS after, e.emitted_at AS emitted_at ORDER BY emitted_at """, {"since": last_seen, "labels": ["User", "Product"]}, ) for row in result.rows: print(f"Operation: {row['operation'].raw_value}") # INSERT, UPDATE, DELETE print(f"Label: {row['label'].raw_value}") print(f"Data: {row['after'].raw_value}") print(f"Timestamp: {row['emitted_at'].raw_value}") </code></pre></div> <h3 id="backup-and-recovery" class="position-relative d-flex align-items-center group"> Backup and Recovery <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="backup-and-recovery" aria-haspopup="dialog" aria-label="Share link: Backup and Recovery"> Share link </button> </h3> <h4 id="point-in-time-recovery" class="position-relative d-flex align-items-center group"> Point-in-Time Recovery <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="point-in-time-recovery" aria-haspopup="dialog" aria-label="Share link: Point-in-Time Recovery"> Share link </button> </h4>Restore to any point in transaction history: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># Create backup geode backup create --destination /backups/geode-20240615 # Restore from backup geode backup restore --source /backups/geode-20240615 --target /data/geode-restored # Point-in-time restore geode backup restore --source /backups/geode-20240615 --timestamp '2024-06-15T14:30:00Z' </code></pre></div> <h4 id="continuous-backup" class="position-relative d-flex align-items-center group"> Continuous Backup <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="continuous-backup" aria-haspopup="dialog" aria-label="Share link: Continuous Backup"> Share link </button> </h4>Automated backup scheduling: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># Configure continuous backup geode serve --backup-enabled --backup-interval 3600 --backup-destination /backups </code></pre></div> <h3 id="advanced-query-features" class="position-relative d-flex align-items-center group"> Advanced Query 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="advanced-query-features" aria-haspopup="dialog" aria-label="Share link: Advanced Query Features"> Share link </button> </h3> <h4 id="prepared-statements" class="position-relative d-flex align-items-center group"> Prepared Statements <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="prepared-statements" aria-haspopup="dialog" aria-label="Share link: Prepared Statements"> Share link </button> </h4>Compiled queries with parameter substitution: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python"># Prepare statement once stmt = await client.prepare(""" MATCH (u:User {id: $id}) RETURN u.name, u.email """) # Execute multiple times with different parameters result1, _ = await stmt.execute({"id": 1}) result2, _ = await stmt.execute({"id": 2}) result3, _ = await stmt.execute({"id": 3}) </code></pre></div> <h4 id="stored-procedures" class="position-relative d-flex align-items-center group"> Stored Procedures <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="stored-procedures" aria-haspopup="dialog" aria-label="Share link: Stored Procedures"> Share link </button> </h4>Reusable database logic: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">// Create procedure CREATE PROCEDURE transfer_funds(from_id INT, to_id INT, amount FLOAT) LANGUAGE GQL AS $$ BEGIN TRANSACTION; MATCH (from:Account {id: $from_id}), (to:Account {id: $to_id}) WHERE from.balance >= $amount SET from.balance = from.balance - $amount, to.balance = to.balance + $amount; RETURN from, to; COMMIT; $$; // Call procedure CALL transfer_funds(1, 2, 100.0); </code></pre></div> <h4 id="query-caching" class="position-relative d-flex align-items-center group"> Query Caching <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" aria-haspopup="dialog" aria-label="Share link: Query Caching"> Share link </button> </h4>Automatic result caching for repeated queries: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python"># Enable query cache client = Client('localhost:3141', enable_cache=True, cache_ttl=300) # First execution hits database result1 = await client.query("MATCH (u:User) WHERE u.active = true RETURN COUNT(u)") # Second execution uses cache (if within TTL) result2 = await client.query("MATCH (u:User) WHERE u.active = true RETURN COUNT(u)") </code></pre></div> <h3 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> </h3> <h4 id="performance-metrics" class="position-relative d-flex align-items-center group"> Performance Metrics <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-metrics" aria-haspopup="dialog" aria-label="Share link: Performance Metrics"> Share link </button> </h4>Built-in metrics collection: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">// Query current metrics SHOW METRICS; // Results include: // - queries_per_second // - average_query_latency_ms // - active_connections // - cache_hit_rate // - index_usage_stats // - transaction_throughput </code></pre></div> <h4 id="query-logging" class="position-relative d-flex align-items-center group"> Query Logging <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-logging" aria-haspopup="dialog" aria-label="Share link: Query Logging"> Share link </button> </h4>Detailed query execution logging: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># Enable slow query log geode serve --slow-query-log --slow-query-threshold 1000 # Log queries > 1s </code></pre></div> <h4 id="health-checks" class="position-relative d-flex align-items-center group"> Health Checks <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="health-checks" aria-haspopup="dialog" aria-label="Share link: Health Checks"> Share link </button> </h4>Built-in health monitoring: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python"># Health check endpoint health = await client.health_check() print(f"Status: {health['status']}") # 'healthy', 'degraded', 'unhealthy' print(f"Uptime: {health['uptime_seconds']}") print(f"Version: {health['version']}") </code></pre></div> <h3 id="schema-management" class="position-relative d-flex align-items-center group"> Schema 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="schema-management" aria-haspopup="dialog" aria-label="Share link: Schema Management"> Share link </button> </h3> <h4 id="constraints" class="position-relative d-flex align-items-center group"> Constraints <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="constraints" aria-haspopup="dialog" aria-label="Share link: Constraints"> Share link </button> </h4>Data integrity enforcement: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">// Unique constraints CREATE CONSTRAINT ON (u:User) ASSERT u.email IS UNIQUE; // Existence constraints CREATE CONSTRAINT ON (u:User) ASSERT EXISTS(u.email); // Property type constraints CREATE CONSTRAINT ON (p:Product) ASSERT p.price IS :: FLOAT; // Check constraints CREATE CONSTRAINT ON (u:User) ASSERT u.age >= 0 AND u.age <= 150; </code></pre></div> <h4 id="schema-versioning" class="position-relative d-flex align-items-center group"> Schema Versioning <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-versioning" aria-haspopup="dialog" aria-label="Share link: Schema Versioning"> Share link </button> </h4>Track schema changes over time: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">// Create versioned schema change BEGIN SCHEMA MIGRATION 'v2.0.0'; CREATE INDEX FOR (p:Product) ON (p.category); ALTER LABEL User ADD PROPERTY created_at DATETIME DEFAULT NOW(); COMMIT SCHEMA MIGRATION; // View migration history SHOW SCHEMA MIGRATIONS; </code></pre></div> <h3 id="import-and-export" class="position-relative d-flex align-items-center group"> Import and Export <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="import-and-export" aria-haspopup="dialog" aria-label="Share link: Import and Export"> Share link </button> </h3> <h4 id="bulk-data-loading" class="position-relative d-flex align-items-center group"> Bulk Data Loading <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="bulk-data-loading" aria-haspopup="dialog" aria-label="Share link: Bulk Data Loading"> Share link </button> </h4>Efficient bulk import: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># Import from CSV geode import --format csv --file users.csv --label User --mapping id:id,name:name,email:email # Import from JSON geode import --format json --file data.json # Import from Cypher/GQL dump geode import --format gql --file database.gql </code></pre></div> <h4 id="data-export" class="position-relative d-flex align-items-center group"> Data Export <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-export" aria-haspopup="dialog" aria-label="Share link: Data Export"> Share link </button> </h4>Export data in various formats: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># Export to CSV geode export --format csv --query "MATCH (u:User) RETURN u.id, u.name, u.email" --output users.csv # Export entire database geode export --format gql --output database-backup.gql # Export to JSON geode export --format json --query "MATCH (u:User) RETURN u" --output users.json </code></pre></div> <h3 id="multi-tenancy" class="position-relative d-flex align-items-center group"> Multi-Tenancy <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="multi-tenancy" aria-haspopup="dialog" aria-label="Share link: Multi-Tenancy"> Share link </button> </h3> <h4 id="logical-isolation" class="position-relative d-flex align-items-center group"> Logical Isolation <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="logical-isolation" aria-haspopup="dialog" aria-label="Share link: Logical Isolation"> Share link </button> </h4>Isolate tenant data within single database: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">// Schema-based multi-tenancy CREATE GRAPH tenant_acme; CREATE GRAPH tenant_globex; // Switch context USE GRAPH tenant_acme; MATCH (u:User) RETURN u; // Only sees Acme data // RLS-based multi-tenancy CREATE POLICY tenant_filter ON * USING (tenant_id = current_setting('app.tenant_id')); </code></pre></div> <h3 id="client-libraries" class="position-relative d-flex align-items-center group"> Client Libraries <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="client-libraries" aria-haspopup="dialog" aria-label="Share link: Client Libraries"> Share link </button> </h3>Polyglot client support for multiple languages: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python"># Python (async) from geode_client import Client client = Client(host="localhost", port=3141) async with client.connection() as conn: result, _ = await conn.query("MATCH (u:User) RETURN u") </code></pre></div><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-go" data-lang="go">// Go (database/sql) import "database/sql" import _ "geodedb.com/geode" db, _ := sql.Open("geode", "quic://localhost:3141") rows, _ := db.Query("MATCH (u:User) RETURN u.name") </code></pre></div><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-rust" data-lang="rust">// Rust (async) use geode_client::Client; let client = Client::from_dsn("localhost:3141")?; let mut conn = client.connect().await?; let (page, _) = conn.query("MATCH (u:User) RETURN u").await?; </code></pre></div> <h3 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> </h3> <h4 id="isoiec-390752024-gql" class="position-relative d-flex align-items-center group"> ISO/IEC 39075:2024 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="isoiec-390752024-gql" aria-haspopup="dialog" aria-label="Share link: ISO/IEC 39075:2024 GQL"> Share link </button> </h4>Aligned with the ISO 100% GQL compliance: <ul> <li>MATCH and OPTIONAL MATCH with bounded expansions</li> <li>Deterministic ORDER BY and pagination policies</li> <li>Set operations (UNION, INTERSECT, EXCEPT)</li> <li>Diagnostics aligned to the conformance profile</li> </ul> <h4 id="interoperability" class="position-relative d-flex align-items-center group"> Interoperability <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="interoperability" aria-haspopup="dialog" aria-label="Share link: Interoperability"> Share link </button> </h4>Standard protocol support: <ul> <li>QUIC transport (RFC 9000)</li> <li>TLS 1.3 encryption (RFC 8446)</li> <li>Protobuf wire protocol</li> <li>OpenCypher compatibility layer</li> </ul> <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><ul> <li>Transactions: Deep dive into transaction management</li> <li>Security: Comprehensive security configuration</li> <li>Replication: High availability setup</li> <li>Performance: Query optimization and tuning</li> <li>Monitoring: Observability and metrics</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><ul> <li><a href="/tags/transactions/" >Transaction Management</a> - ACID and isolation</li> <li><a href="/tags/security/" >Security Guide</a> - Authentication and encryption</li> <li><a href="/tags/performance/" >Performance Tuning</a> - Optimization strategies</li> <li><a href="/tags/replication/" >Replication Setup</a> - High availability</li> <li><a href="/tags/gql-reference/" >GQL Reference</a> - Complete language documentation</li> </ul> Geode’s comprehensive feature set provides everything needed for production-grade graph database deployments, from single-node development to distributed enterprise systems. <h3 id="advanced-enterprise-features" class="position-relative d-flex align-items-center group"> Advanced Enterprise 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="advanced-enterprise-features" aria-haspopup="dialog" aria-label="Share link: Advanced Enterprise Features"> Share link </button> </h3> <h4 id="multi-tenancy-implementation" class="position-relative d-flex align-items-center group"> Multi-Tenancy Implementation <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="multi-tenancy-implementation" aria-haspopup="dialog" aria-label="Share link: Multi-Tenancy Implementation"> Share link </button> </h4>Isolate tenant data with Row-Level Security: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python">class MultiTenantClient: def __init__(self, base_client): self.client = base_client async def setup_tenant_isolation(self): """Configure RLS policies for multi-tenancy""" await self.client.execute(""" -- Create RLS policy for users CREATE POLICY tenant_users ON User USING (tenant_id = current_setting('app.tenant_id')); -- Create RLS policy for orders CREATE POLICY tenant_orders ON Order USING (tenant_id = current_setting('app.tenant_id')); -- Enable RLS ALTER LABEL User ENABLE ROW LEVEL SECURITY; ALTER LABEL Order ENABLE ROW LEVEL SECURITY; """) async def execute_for_tenant(self, tenant_id, query, params=None): """Execute query in tenant context""" async with self.client.connection() as conn: await conn.begin() try: # Set tenant context await conn.execute(""" SET app.tenant_id = $tenant_id """, {"tenant_id": tenant_id}) # Execute query (RLS auto-applied) result, _ = await conn.query(query, params) await conn.commit() return result except Exception: await conn.rollback() raise # Usage client = MultiTenantClient(base_client) await client.setup_tenant_isolation() # Queries automatically filtered by tenant result = await client.execute_for_tenant("tenant_123", """ MATCH (u:User) RETURN u.name """) # Only sees tenant_123 users </code></pre></div> <h4 id="time-travel-queries" class="position-relative d-flex align-items-center group"> Time-Travel 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="time-travel-queries" aria-haspopup="dialog" aria-label="Share link: Time-Travel Queries"> Share link </button> </h4>Query historical state with temporal data: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Point-in-time query MATCH (u:User) WHERE u.valid_from <= datetime('2024-01-15') AND (u.valid_to IS NULL OR u.valid_to > datetime('2024-01-15')) RETURN u.name, u.email -- Temporal join MATCH (e:Employee)-[r:WORKS_FOR]->(c:Company) WHERE r.start_date <= datetime('2023-06-01') AND (r.end_date IS NULL OR r.end_date >= datetime('2023-06-01')) RETURN e.name, c.name -- Audit trail MATCH (a:Account {id: $account_id})-[:HAS_HISTORY]->(h:AccountHistory) WHERE h.timestamp BETWEEN datetime('2024-01-01') AND datetime('2024-12-31') RETURN h.balance, h.timestamp ORDER BY h.timestamp </code></pre></div> <h4 id="full-text-search-integration" class="position-relative d-flex align-items-center group"> Full-Text Search 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="full-text-search-integration" aria-haspopup="dialog" aria-label="Share link: Full-Text Search Integration"> Share link </button> </h4>Advanced text search capabilities: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Create full-text index CREATE TEXT INDEX FOR (p:Post) ON (p.title, p.content); CREATE TEXT INDEX FOR (a:Article) ON (a.body) OPTIONS {language: 'english', stemming: true}; -- Basic text search MATCH (p:Post) WHERE p.content CONTAINS 'graph database' RETURN p.title, p.content -- Ranked search with BM25 CREATE BM25 INDEX FOR (d:Document) ON (d.title, d.body); MATCH (d:Document) WHERE d MATCH 'graph AND (database OR query)' RETURN d.title, score(d) as relevance ORDER BY relevance DESC LIMIT 10 -- Phrase search MATCH (a:Article) WHERE a.body CONTAINS PHRASE 'machine learning' RETURN a.title -- Fuzzy search MATCH (u:User) WHERE u.name =~ fuzzy('Alise', max_edit_distance: 2) RETURN u.name </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>Semantic search with embeddings: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python">async def semantic_search(client, query_text, limit=10): """Perform semantic search using vector embeddings""" # Generate query embedding query_embedding = await generate_embedding(query_text) # Vector similarity search results, _ = await client.query(""" MATCH (d:Document) WITH d, vector_similarity(d.embedding, $query_embedding, 'cosine') as similarity WHERE similarity > 0.7 RETURN d.id, d.title, d.content, similarity ORDER BY similarity DESC LIMIT $limit """, { "query_embedding": query_embedding, "limit": limit }) return results # HNSW index for fast approximate search await client.execute(""" CREATE VECTOR INDEX document_embeddings FOR (d:Document) ON (d.embedding) OPTIONS { metric: 'cosine', dimensions: 768, m: 16, ef_construction: 200, ef_search: 100 } """) </code></pre></div> <h4 id="graph-algorithms-library" class="position-relative d-flex align-items-center group"> Graph Algorithms Library <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-library" aria-haspopup="dialog" aria-label="Share link: Graph Algorithms Library"> Share link </button> </h4>Built-in algorithm implementations: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- PageRank CALL algo.pageRank('User', 'FOLLOWS', { iterations: 20, dampingFactor: 0.85 }) YIELD node, score RETURN node.name, score ORDER BY score DESC LIMIT 10 -- Community Detection (Louvain) CALL algo.louvain('User', 'FRIENDS_WITH', { resolution: 1.0 }) YIELD node, community RETURN community, COUNT(node) as size ORDER BY size DESC -- Shortest Path MATCH path = shortestPath((start:User {id: $id1})-[:KNOWS*]-(end:User {id: $id2})) RETURN [node IN nodes(path) | node.name] as path, length(path) as distance -- Betweenness Centrality CALL algo.betweenness('User', 'KNOWS') YIELD node, score RETURN node.name, score ORDER BY score DESC LIMIT 20 </code></pre></div> <h4 id="data-validation-and-constraints" class="position-relative d-flex align-items-center group"> Data Validation and Constraints <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-validation-and-constraints" aria-haspopup="dialog" aria-label="Share link: Data Validation and Constraints"> Share link </button> </h4>Comprehensive data integrity: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Uniqueness constraints CREATE CONSTRAINT ON (u:User) ASSERT u.email IS UNIQUE; CREATE CONSTRAINT ON (p:Product) ASSERT (p.sku, p.variant) IS UNIQUE; -- Existence constraints CREATE CONSTRAINT ON (u:User) ASSERT EXISTS(u.email); CREATE CONSTRAINT ON (o:Order) ASSERT EXISTS(o.customer_id); -- Type constraints CREATE CONSTRAINT ON (p:Product) ASSERT p.price IS :: FLOAT; CREATE CONSTRAINT ON (u:User) ASSERT p.created_at IS :: DATETIME; -- Check constraints CREATE CONSTRAINT ON (u:User) ASSERT u.age BETWEEN 0 AND 150; CREATE CONSTRAINT ON (p:Product) ASSERT p.price > 0; CREATE CONSTRAINT ON (r:Rating) ASSERT r.score IN [1,2,3,4,5]; -- Pattern constraints CREATE CONSTRAINT ON (u:User) ASSERT u.email =~ '^[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\\.[a-zA-Z]{2,}$'; -- Custom validation functions CREATE FUNCTION validate_credit_card(card_number STRING) RETURNS BOOLEAN AS $$ -- Luhn algorithm implementation RETURN luhn_check(card_number); $$; CREATE CONSTRAINT ON (p:Payment) ASSERT validate_credit_card(p.card_number); </code></pre></div> <h4 id="geospatial-features" class="position-relative d-flex align-items-center group"> Geospatial 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="geospatial-features" aria-haspopup="dialog" aria-label="Share link: Geospatial Features"> Share link </button> </h4>Location-based queries: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Create spatial index CREATE SPATIAL INDEX FOR (l:Location) ON (l.coordinates); -- Point creation CREATE (store:Store { name: 'Main Street Store', coordinates: point({latitude: 37.7749, longitude: -122.4194}) }); -- Distance queries MATCH (u:User {id: $user_id}), (store:Store) WITH u, store, distance(u.location, store.location) as dist_meters WHERE dist_meters < 5000 // Within 5km RETURN store.name, dist_meters ORDER BY dist_meters -- Polygon containment MATCH (p:Place) WHERE contains( polygon([ point({latitude: 37.8, longitude: -122.5}), point({latitude: 37.8, longitude: -122.3}), point({latitude: 37.7, longitude: -122.3}), point({latitude: 37.7, longitude: -122.5}) ]), p.location ) RETURN p.name </code></pre></div> <h4 id="query-result-caching" class="position-relative d-flex align-items-center group"> Query Result Caching <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-result-caching" aria-haspopup="dialog" aria-label="Share link: Query Result Caching"> Share link </button> </h4>Intelligent result caching: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python">from functools import lru_cache import hashlib class CachedClient: def __init__(self, client, cache_backend): self.client = client self.cache = cache_backend def cache_key(self, query, params): """Generate cache key from query and params""" content = f"{query}:{json.dumps(params, sort_keys=True)}" return hashlib.sha256(content.encode()).hexdigest() async def execute_cached(self, query, params=None, ttl=300): """Execute query with result caching""" key = self.cache_key(query, params) # Check cache cached = await self.cache.get(key) if cached: return json.loads(cached) # Execute query result, _ = await self.client.query(query, params) # Store in cache await self.cache.set(key, json.dumps(result), ex=ttl) return result async def invalidate_pattern(self, pattern): """Invalidate cached queries matching pattern""" keys = await self.cache.keys(f"{pattern}*") if keys: await self.cache.delete(*keys) </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>Efficient bulk data processing: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python">async def batch_insert_users(client, users, batch_size=1000): """Insert users in batches""" for i in range(0, len(users), batch_size): batch = users[i:i + batch_size] await client.execute(""" UNWIND $users AS user_data CREATE (u:User { id: user_data.id, name: user_data.name, email: user_data.email, created_at: datetime() }) """, {"users": batch}) async def batch_update_prices(client, price_updates): """Update prices in batch""" await client.execute(""" UNWIND $updates AS update MATCH (p:Product {id: update.product_id}) SET p.price = update.new_price, p.updated_at = datetime() """, {"updates": price_updates}) </code></pre></div>Browse the tagged content below to discover comprehensive feature documentation and implementation guides for Geode’s enterprise capabilities.

Popular

Related Articles

Overview