<!-- CANARY: REQ=REQ-DOCUMENTATION-STRUCTURE-001; FEATURE="DocStructure"; ASPECT=StructureTests; STATUS=TESTED; OWNER=claude; UPDATED=2026-01-16 --> <h3 id="overview" class="position-relative d-flex align-items-center group"> <span>Overview</span> <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="overview" aria-haspopup="dialog" aria-label="Share link: Overview"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </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"> <i class="fa-solid fa-xmark"></i> </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"> <i class="fa-duotone fa-clipboard" aria-hidden="true"></i> </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"> <i class="fa-brands fa-twitter me-2"></i>Twitter </a> <a id="share-linkedin" class="btn btn-outline-secondary w-100" target="_blank" rel="noopener noreferrer"> <i class="fa-brands fa-linkedin me-2"></i>LinkedIn </a> <a id="share-facebook" class="btn btn-outline-secondary w-100" target="_blank" rel="noopener noreferrer"> <i class="fa-brands fa-facebook me-2"></i>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><p>Geode&rsquo;s interactive REPL (Read-Eval-Print Loop) provides professional database shell features including syntax highlighting, fuzzy search, result pagination, session persistence, and advanced keybindings for maximum productivity.</p> <p><strong>Status</strong>: Production-ready (all features tested and documented)</p> <h4 id="what-youll-learn" class="position-relative d-flex align-items-center group"> <span>What You&amp;rsquo;ll Learn</span> <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-learn" aria-haspopup="dialog" aria-label="Share link: What Youll Learn"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h4><ul> <li>Syntax highlighting for GQL queries</li> <li>Fuzzy history search and navigation</li> <li>Smart result pagination</li> <li>Session state persistence</li> <li>Keybindings and shortcuts</li> <li>Scripting and automation</li> <li>Productivity tips and tricks</li> </ul> <h4 id="prerequisites" class="position-relative d-flex align-items-center group"> <span>Prerequisites</span> <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="prerequisites" aria-haspopup="dialog" aria-label="Share link: Prerequisites"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h4><ul> <li>Geode installed (see <a href="/guides/installation/" >Installation Guide</a> )</li> <li>Terminal with color support (optional, for syntax highlighting)</li> <li>Basic familiarity with GQL syntax</li> </ul> <h3 id="getting-started" class="position-relative d-flex align-items-center group"> <span>Getting Started</span> <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" aria-haspopup="dialog" aria-label="Share link: Getting Started"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h3> <h4 id="starting-the-repl" class="position-relative d-flex align-items-center group"> <span>Starting the REPL</span> <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="starting-the-repl" aria-haspopup="dialog" aria-label="Share link: Starting the REPL"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"><span class="line"><span class="cl"><span class="c1"># Interactive shell</span> </span></span><span class="line"><span class="cl">geode shell </span></span><span class="line"><span class="cl"> </span></span><span class="line"><span class="cl"><span class="c1"># Connect to specific server</span> </span></span><span class="line"><span class="cl">geode shell --host localhost --port <span class="m">3141</span> </span></span><span class="line"><span class="cl"> </span></span><span class="line"><span class="cl"><span class="c1"># With custom prompt</span> </span></span><span class="line"><span class="cl">geode shell --prompt <span class="s2">&#34;geode&gt; &#34;</span> </span></span></code></pre></div><p><strong>Exit Commands</strong>:</p> <ul> <li><code>\quit</code> or <code>\q</code> - Exit REPL</li> <li><code>Ctrl+D</code> - EOF (exit)</li> <li><code>exit</code> - Alternative exit command</li> </ul> <h3 id="syntax-highlighting" class="position-relative d-flex align-items-center group"> <span>Syntax Highlighting</span> <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="syntax-highlighting" aria-haspopup="dialog" aria-label="Share link: Syntax Highlighting"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h3> <h4 id="overview-1" class="position-relative d-flex align-items-center group"> <span>Overview</span> <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="overview-1" aria-haspopup="dialog" aria-label="Share link: Overview"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h4><p>Real-time syntax highlighting for GQL queries with ANSI color codes.</p> <p><strong>Features</strong>:</p> <ul> <li>Keywords highlighted in bold blue</li> <li>Strings in green</li> <li>Numbers in cyan</li> <li>Operators in yellow</li> <li>Comments in dim gray</li> <li>Meta commands in bright magenta</li> </ul> <h4 id="color-scheme" class="position-relative d-flex align-items-center group"> <span>Color Scheme</span> <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="color-scheme" aria-haspopup="dialog" aria-label="Share link: Color Scheme"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="py">MATCH</span><span class="w"> </span><span class="p">(</span><span class="py">n</span><span class="p">:</span><span class="nc">Person</span><span class="p">)</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="py">Keywords</span><span class="p">:</span><span class="w"> </span><span class="nc">bold</span><span class="w"> </span><span class="py">blue</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">WHERE</span><span class="w"> </span><span class="py">n</span><span class="err">.</span><span class="py">name</span><span class="w"> </span><span class="p">=</span><span class="w"> </span><span class="err">&#39;</span><span class="py">Alice</span><span class="err">&#39;</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="py">String</span><span class="p">:</span><span class="w"> </span><span class="nc">green</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">AND</span><span class="w"> </span><span class="py">n</span><span class="err">.</span><span class="py">age</span><span class="w"> </span><span class="err">&gt;</span><span class="w"> </span><span class="py">25</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="py">Number</span><span class="p">:</span><span class="w"> </span><span class="nc">cyan</span><span class="p">,</span><span class="w"> </span><span class="py">operator</span><span class="p">:</span><span class="w"> </span><span class="nc">yellow</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">n</span><span class="err">.</span><span class="py">name</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="py">Keyword</span><span class="p">:</span><span class="w"> </span><span class="nc">bold</span><span class="w"> </span><span class="py">blue</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">This</span><span class="w"> </span><span class="py">is</span><span class="w"> </span><span class="py">a</span><span class="w"> </span><span class="py">comment</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="py">Comment</span><span class="p">:</span><span class="w"> </span><span class="nc">dim</span><span class="w"> </span><span class="py">gray</span><span class="w"> </span></span></span></code></pre></div><p><strong>ANSI Codes</strong>:</p> <ul> <li>Keyword: <code>\x1b[1m\x1b[34m</code> (Bold Blue)</li> <li>String: <code>\x1b[32m</code> (Green)</li> <li>Number: <code>\x1b[36m</code> (Cyan)</li> <li>Operator: <code>\x1b[33m</code> (Yellow)</li> <li>Parenthesis: <code>\x1b[93m</code> (Bright Yellow)</li> <li>Meta Command: <code>\x1b[95m</code> (Bright Magenta)</li> <li>Comment: <code>\x1b[2m\x1b[90m</code> (Dim Gray)</li> </ul> <h4 id="configuration" class="position-relative d-flex align-items-center group"> <span>Configuration</span> <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="configuration" aria-haspopup="dialog" aria-label="Share link: Configuration"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Enable</span><span class="err">/</span><span class="py">disable</span><span class="w"> </span><span class="py">syntax</span><span class="w"> </span><span class="py">highlighting</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">\</span><span class="py">set</span><span class="w"> </span><span class="py">highlight</span><span class="w"> </span><span class="kd">on</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="py">Enable</span><span class="w"> </span><span class="p">(</span><span class="py">default</span><span class="w"> </span><span class="py">if</span><span class="w"> </span><span class="py">terminal</span><span class="w"> </span><span class="py">supports</span><span class="w"> </span><span class="py">colors</span><span class="p">)</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">\</span><span class="py">set</span><span class="w"> </span><span class="py">highlight</span><span class="w"> </span><span class="py">off</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="py">Disable</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Check</span><span class="w"> </span><span class="py">current</span><span class="w"> </span><span class="py">setting</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">\</span><span class="py">show</span><span class="w"> </span><span class="py">highlight</span><span class="w"> </span></span></span></code></pre></div><p><strong>Auto-Detection</strong>: Syntax highlighting is automatically enabled when the terminal supports colors.</p> <h4 id="benefits" class="position-relative d-flex align-items-center group"> <span>Benefits</span> <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="benefits" aria-haspopup="dialog" aria-label="Share link: Benefits"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h4><ol> <li><strong>Improved Readability</strong>: Easier to distinguish query components</li> <li><strong>Error Detection</strong>: Syntax errors more visible</li> <li><strong>Learning Aid</strong>: Visual feedback helps learn GQL syntax</li> <li><strong>Professional Look</strong>: Modern IDE-like experience</li> </ol> <h3 id="result-pagination" class="position-relative d-flex align-items-center group"> <span>Result Pagination</span> <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="result-pagination" aria-haspopup="dialog" aria-label="Share link: Result Pagination"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h3> <h4 id="overview-2" class="position-relative d-flex align-items-center group"> <span>Overview</span> <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="overview-2" aria-haspopup="dialog" aria-label="Share link: Overview"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h4><p>Smart pagination for handling large result sets without overwhelming output.</p> <p><strong>Features</strong>:</p> <ul> <li>Configurable page size (default: 25 rows)</li> <li>Auto-paging for large results (&gt; 50 rows)</li> <li>Multi-format support (table, CSV, JSON)</li> <li>Navigation commands (<code>\next</code>, <code>\prev</code>, <code>\page</code>)</li> <li>Status display with row counts</li> </ul> <h4 id="configuration-1" class="position-relative d-flex align-items-center group"> <span>Configuration</span> <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="configuration-1" aria-haspopup="dialog" aria-label="Share link: Configuration"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Set</span><span class="w"> </span><span class="py">page</span><span class="w"> </span><span class="py">size</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">\</span><span class="py">pagesize</span><span class="w"> </span><span class="py">50</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="py">50</span><span class="w"> </span><span class="py">rows</span><span class="w"> </span><span class="py">per</span><span class="w"> </span><span class="py">page</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Enable</span><span class="err">/</span><span class="py">disable</span><span class="w"> </span><span class="py">pagination</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">\</span><span class="py">paging</span><span class="w"> </span><span class="kd">on</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="py">Enable</span><span class="w"> </span><span class="p">(</span><span class="py">default</span><span class="w"> </span><span class="py">for</span><span class="w"> </span><span class="py">large</span><span class="w"> </span><span class="py">results</span><span class="p">)</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">\</span><span class="py">paging</span><span class="w"> </span><span class="py">off</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="py">Disable</span><span class="w"> </span><span class="p">(</span><span class="py">show</span><span class="w"> </span><span class="py">all</span><span class="w"> </span><span class="py">rows</span><span class="p">)</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Check</span><span class="w"> </span><span class="py">current</span><span class="w"> </span><span class="py">settings</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">\</span><span class="py">show</span><span class="w"> </span><span class="py">pagesize</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">\</span><span class="py">show</span><span class="w"> </span><span class="py">paging</span><span class="w"> </span></span></span></code></pre></div><p><strong>Default Settings</strong>:</p> <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-fallback" data-lang="fallback"><span class="line"><span class="cl">page_size: 25 </span></span><span class="line"><span class="cl">auto_page: true (auto-enable for &gt; 50 rows) </span></span><span class="line"><span class="cl">threshold: 50 (auto-enable trigger) </span></span></code></pre></div> <h4 id="usage-example" class="position-relative d-flex align-items-center group"> <span>Usage Example</span> <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="usage-example" aria-haspopup="dialog" aria-label="Share link: Usage Example"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="py">geode</span><span class="err">&gt;</span><span class="w"> </span><span class="py">MATCH</span><span class="w"> </span><span class="p">(</span><span class="py">n</span><span class="p">:</span><span class="nc">Person</span><span class="p">)</span><span class="w"> </span><span class="py">RETURN</span><span class="w"> </span><span class="py">n</span><span class="err">.</span><span class="py">name</span><span class="p">,</span><span class="w"> </span><span class="py">n</span><span class="err">.</span><span class="py">age</span><span class="w"> </span><span class="py">LIMIT</span><span class="w"> </span><span class="py">100</span><span class="err">;</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="p">|</span><span class="w"> </span><span class="py">name</span><span class="w"> </span><span class="p">|</span><span class="w"> </span><span class="py">age</span><span class="w"> </span><span class="p">|</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="p">|</span><span class="err">-------</span><span class="p">|</span><span class="err">-----</span><span class="p">|</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="p">|</span><span class="w"> </span><span class="py">Alice</span><span class="w"> </span><span class="p">|</span><span class="w"> </span><span class="py">30</span><span class="w"> </span><span class="p">|</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="p">|</span><span class="w"> </span><span class="py">Bob</span><span class="w"> </span><span class="p">|</span><span class="w"> </span><span class="py">25</span><span class="w"> </span><span class="p">|</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="kd">...</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="p">(</span><span class="py">25</span><span class="w"> </span><span class="py">rows</span><span class="p">)</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">Showing</span><span class="w"> </span><span class="py">rows</span><span class="w"> </span><span class="py">1</span><span class="err">-</span><span class="py">25</span><span class="w"> </span><span class="py">of</span><span class="w"> </span><span class="py">100</span><span class="w"> </span><span class="p">(</span><span class="py">Page</span><span class="w"> </span><span class="py">1</span><span class="err">/</span><span class="py">4</span><span class="p">)</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">Type</span><span class="w"> </span><span class="err">\</span><span class="py">next</span><span class="w"> </span><span class="py">or</span><span class="w"> </span><span class="err">\</span><span class="py">n</span><span class="w"> </span><span class="py">for</span><span class="w"> </span><span class="py">next</span><span class="w"> </span><span class="py">page</span><span class="p">,</span><span class="w"> </span><span class="err">\</span><span class="py">prev</span><span class="w"> </span><span class="py">or</span><span class="w"> </span><span class="err">\</span><span class="py">p</span><span class="w"> </span><span class="py">for</span><span class="w"> </span><span class="py">previous</span><span class="w"> </span><span class="py">page</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">geode</span><span class="err">&gt;</span><span class="w"> </span><span class="err">\</span><span class="py">next</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="p">|</span><span class="w"> </span><span class="py">name</span><span class="w"> </span><span class="p">|</span><span class="w"> </span><span class="py">age</span><span class="w"> </span><span class="p">|</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="p">|</span><span class="err">---------</span><span class="p">|</span><span class="err">-----</span><span class="p">|</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="p">|</span><span class="w"> </span><span class="py">Charlie</span><span class="w"> </span><span class="p">|</span><span class="w"> </span><span class="py">35</span><span class="w"> </span><span class="p">|</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="kd">...</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">Showing</span><span class="w"> </span><span class="py">rows</span><span class="w"> </span><span class="py">26</span><span class="err">-</span><span class="py">50</span><span class="w"> </span><span class="py">of</span><span class="w"> </span><span class="py">100</span><span class="w"> </span><span class="p">(</span><span class="py">Page</span><span class="w"> </span><span class="py">2</span><span class="err">/</span><span class="py">4</span><span class="p">)</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">geode</span><span class="err">&gt;</span><span class="w"> </span><span class="err">\</span><span class="py">page</span><span class="w"> </span><span class="py">4</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">Showing</span><span class="w"> </span><span class="py">rows</span><span class="w"> </span><span class="py">76</span><span class="err">-</span><span class="py">100</span><span class="w"> </span><span class="py">of</span><span class="w"> </span><span class="py">100</span><span class="w"> </span><span class="p">(</span><span class="py">Page</span><span class="w"> </span><span class="py">4</span><span class="err">/</span><span class="py">4</span><span class="p">)</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">geode</span><span class="err">&gt;</span><span class="w"> </span><span class="err">\</span><span class="py">prev</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">Showing</span><span class="w"> </span><span class="py">rows</span><span class="w"> </span><span class="py">51</span><span class="err">-</span><span class="py">75</span><span class="w"> </span><span class="py">of</span><span class="w"> </span><span class="py">100</span><span class="w"> </span><span class="p">(</span><span class="py">Page</span><span class="w"> </span><span class="py">3</span><span class="err">/</span><span class="py">4</span><span class="p">)</span><span class="w"> </span></span></span></code></pre></div> <h4 id="navigation-commands" class="position-relative d-flex align-items-center group"> <span>Navigation Commands</span> <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="navigation-commands" aria-haspopup="dialog" aria-label="Share link: Navigation Commands"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h4><table> <thead> <tr> <th>Command</th> <th>Shorthand</th> <th>Description</th> </tr> </thead> <tbody> <tr> <td><code>\next</code></td> <td><code>\n</code></td> <td>Next page</td> </tr> <tr> <td><code>\prev</code></td> <td><code>\p</code></td> <td>Previous page</td> </tr> <tr> <td><code>\page &lt;n&gt;</code></td> <td>-</td> <td>Jump to page N</td> </tr> <tr> <td><code>\first</code></td> <td>-</td> <td>Jump to first page</td> </tr> <tr> <td><code>\last</code></td> <td>-</td> <td>Jump to last page</td> </tr> </tbody> </table> <h4 id="benefits-1" class="position-relative d-flex align-items-center group"> <span>Benefits</span> <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="benefits-1" aria-haspopup="dialog" aria-label="Share link: Benefits"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h4><ol> <li><strong>Memory Efficient</strong>: Only display current page</li> <li><strong>Improved UX</strong>: No overwhelming output</li> <li><strong>Navigation</strong>: Easy browsing of large datasets</li> <li><strong>Flexible</strong>: Works with all output formats</li> </ol> <h3 id="fuzzy-history-search" class="position-relative d-flex align-items-center group"> <span>Fuzzy History Search</span> <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="fuzzy-history-search" aria-haspopup="dialog" aria-label="Share link: Fuzzy History Search"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h3> <h4 id="overview-3" class="position-relative d-flex align-items-center group"> <span>Overview</span> <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="overview-3" aria-haspopup="dialog" aria-label="Share link: Overview"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h4><p>Intelligent fuzzy matching for history search with smart scoring and real-time filtering.</p> <p><strong>Features</strong>:</p> <ul> <li>Levenshtein distance calculation</li> <li>Multi-factor scoring algorithm</li> <li>Case-insensitive matching</li> <li>Sorted results (best matches first)</li> <li>Interactive finder with real-time feedback</li> </ul> <h4 id="activation" class="position-relative d-flex align-items-center group"> <span>Activation</span> <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="activation" aria-haspopup="dialog" aria-label="Share link: Activation"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-fallback" data-lang="fallback"><span class="line"><span class="cl">Press Ctrl+R to activate fuzzy search </span></span></code></pre></div><p><strong>Interactive Workflow</strong>:</p> <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-fallback" data-lang="fallback"><span class="line"><span class="cl">geode&gt; (Press Ctrl+R) </span></span><span class="line"><span class="cl">(reverse-fuzzy-search)`&#39;: </span></span><span class="line"><span class="cl"> </span></span><span class="line"><span class="cl">(Type &#39;mat&#39;) </span></span><span class="line"><span class="cl">(reverse-fuzzy-search)`mat&#39;: MATCH (n:Person) RETURN n.name </span></span><span class="line"><span class="cl"> </span></span><span class="line"><span class="cl">(Press Enter to select, Esc to cancel, Up/Down to navigate) </span></span></code></pre></div> <h4 id="scoring-algorithm" class="position-relative d-flex align-items-center group"> <span>Scoring Algorithm</span> <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="scoring-algorithm" aria-haspopup="dialog" aria-label="Share link: Scoring Algorithm"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h4><p>The fuzzy search uses a sophisticated scoring system:</p> <ol> <li><strong>Exact match bonus</strong>: +5000</li> <li><strong>Starts with bonus</strong>: +500</li> <li><strong>Contains substring</strong>: +300 - (2 × position)</li> <li><strong>All characters matched</strong>: +200</li> <li><strong>Consecutive matches</strong>: +(matches × 10)</li> <li><strong>Word boundary</strong>: +20 per match</li> <li><strong>Levenshtein penalty</strong>: -(distance × 10)</li> <li><strong>Length penalty</strong>: -(length_diff × 1)</li> </ol> <p><strong>Example Scoring</strong>:</p> <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-fallback" data-lang="fallback"><span class="line"><span class="cl">Query: &#34;match person&#34; </span></span><span class="line"><span class="cl"> </span></span><span class="line"><span class="cl">Results: </span></span><span class="line"><span class="cl">1. &#34;MATCH (n:Person) RETURN n&#34; (score: 5500) - exact + starts with </span></span><span class="line"><span class="cl">2. &#34;MATCH (p:Person) WHERE p.age &gt; 25&#34; (score: 5200) - exact + contains </span></span><span class="line"><span class="cl">3. &#34;RETURN persons&#34; (score: 320) - contains substring </span></span><span class="line"><span class="cl">4. &#34;CREATE (n:PersonNode)&#34; (score: 180) - partial matches </span></span></code></pre></div> <h4 id="keybindings-in-search-mode" class="position-relative d-flex align-items-center group"> <span>Keybindings in Search Mode</span> <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="keybindings-in-search-mode" aria-haspopup="dialog" aria-label="Share link: Keybindings in Search Mode"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h4><table> <thead> <tr> <th>Key</th> <th>Action</th> </tr> </thead> <tbody> <tr> <td><code>Ctrl+R</code></td> <td>Activate/repeat search</td> </tr> <tr> <td>Type</td> <td>Filter results in real-time</td> </tr> <tr> <td><code>Enter</code></td> <td>Select current result</td> </tr> <tr> <td><code>Esc</code></td> <td>Cancel search</td> </tr> <tr> <td><code>Up/Down</code></td> <td>Navigate results</td> </tr> <tr> <td><code>Ctrl+C</code></td> <td>Abort search</td> </tr> </tbody> </table> <h4 id="benefits-2" class="position-relative d-flex align-items-center group"> <span>Benefits</span> <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="benefits-2" aria-haspopup="dialog" aria-label="Share link: Benefits"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h4><ol> <li><strong>Fast Search</strong>: Find commands quickly</li> <li><strong>Typo Tolerant</strong>: Works with minor typos</li> <li><strong>Smart Ranking</strong>: Best matches first</li> <li><strong>Interactive</strong>: Real-time feedback</li> </ol> <h3 id="session-persistence" class="position-relative d-flex align-items-center group"> <span>Session Persistence</span> <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="session-persistence" aria-haspopup="dialog" aria-label="Share link: Session Persistence"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h3> <h4 id="overview-4" class="position-relative d-flex align-items-center group"> <span>Overview</span> <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="overview-4" aria-haspopup="dialog" aria-label="Share link: Overview"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h4><p>Save and restore REPL session state across sessions.</p> <p><strong>Persisted State</strong>:</p> <ul> <li>Current database</li> <li>Transaction state</li> <li>Output format preference</li> <li>Timing display setting</li> <li>Keymap preference (emacs/vi)</li> <li>Last server connection</li> <li>Custom variables</li> </ul> <h4 id="file-format" class="position-relative d-flex align-items-center group"> <span>File Format</span> <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="file-format" aria-haspopup="dialog" aria-label="Share link: File Format"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h4><p>Sessions stored as JSON:</p> <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-json" data-lang="json"><span class="line"><span class="cl"><span class="p">{</span> </span></span><span class="line"><span class="cl"> <span class="nt">&#34;database&#34;</span><span class="p">:</span> <span class="s2">&#34;mydb&#34;</span><span class="p">,</span> </span></span><span class="line"><span class="cl"> <span class="nt">&#34;in_transaction&#34;</span><span class="p">:</span> <span class="kc">false</span><span class="p">,</span> </span></span><span class="line"><span class="cl"> <span class="nt">&#34;format&#34;</span><span class="p">:</span> <span class="s2">&#34;table&#34;</span><span class="p">,</span> </span></span><span class="line"><span class="cl"> <span class="nt">&#34;show_timing&#34;</span><span class="p">:</span> <span class="kc">true</span><span class="p">,</span> </span></span><span class="line"><span class="cl"> <span class="nt">&#34;keymap&#34;</span><span class="p">:</span> <span class="s2">&#34;emacs&#34;</span><span class="p">,</span> </span></span><span class="line"><span class="cl"> <span class="nt">&#34;last_server&#34;</span><span class="p">:</span> <span class="s2">&#34;localhost:3141&#34;</span><span class="p">,</span> </span></span><span class="line"><span class="cl"> <span class="nt">&#34;variables&#34;</span><span class="p">:</span> <span class="p">{</span> </span></span><span class="line"><span class="cl"> <span class="nt">&#34;foo&#34;</span><span class="p">:</span> <span class="s2">&#34;bar&#34;</span><span class="p">,</span> </span></span><span class="line"><span class="cl"> <span class="nt">&#34;baz&#34;</span><span class="p">:</span> <span class="s2">&#34;qux&#34;</span> </span></span><span class="line"><span class="cl"> <span class="p">}</span> </span></span><span class="line"><span class="cl"><span class="p">}</span> </span></span></code></pre></div> <h4 id="file-location" class="position-relative d-flex align-items-center group"> <span>File Location</span> <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="file-location" aria-haspopup="dialog" aria-label="Share link: File Location"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h4><p><strong>Linux</strong>: <code>~/.local/share/geode/session.json</code> <strong>macOS</strong>: <code>~/Library/Application Support/geode/session.json</code> <strong>Windows</strong>: <code>%APPDATA%\geode\session.json</code></p> <h4 id="commands" class="position-relative d-flex align-items-center group"> <span>Commands</span> <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="commands" aria-haspopup="dialog" aria-label="Share link: Commands"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Save</span><span class="w"> </span><span class="py">session</span><span class="w"> </span><span class="py">manually</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">\</span><span class="py">save</span><span class="err">-</span><span class="py">session</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Output</span><span class="p">:</span><span class="w"> </span><span class="nc">Session</span><span class="w"> </span><span class="py">saved</span><span class="w"> </span><span class="py">to</span><span class="w"> </span><span class="err">~/.</span><span class="py">local</span><span class="err">/</span><span class="py">share</span><span class="err">/</span><span class="py">geode</span><span class="err">/</span><span class="py">session</span><span class="err">.</span><span class="py">json</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Load</span><span class="w"> </span><span class="py">session</span><span class="w"> </span><span class="py">manually</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">\</span><span class="py">load</span><span class="err">-</span><span class="py">session</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Output</span><span class="p">:</span><span class="w"> </span><span class="nc">Session</span><span class="w"> </span><span class="py">loaded</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Clear</span><span class="w"> </span><span class="py">session</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">\</span><span class="py">reset</span><span class="err">-</span><span class="py">session</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Output</span><span class="p">:</span><span class="w"> </span><span class="nc">Session</span><span class="w"> </span><span class="py">cleared</span><span class="w"> </span></span></span></code></pre></div><p><strong>Auto-Save</strong>: Sessions are automatically saved on exit and loaded on startup.</p> <h4 id="use-cases" class="position-relative d-flex align-items-center group"> <span>Use Cases</span> <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"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h4><ol> <li><strong>Continuity</strong>: Resume where you left off</li> <li><strong>Convenience</strong>: No need to reconfigure</li> <li><strong>Workflow</strong>: Preserve preferences</li> <li><strong>Multi-Environment</strong>: Different configs for different servers</li> </ol> <h3 id="keybindings" class="position-relative d-flex align-items-center group"> <span>Keybindings</span> <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="keybindings" aria-haspopup="dialog" aria-label="Share link: Keybindings"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h3> <h4 id="emacs-mode-default" class="position-relative d-flex align-items-center group"> <span>Emacs Mode (Default)</span> <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="emacs-mode-default" aria-haspopup="dialog" aria-label="Share link: Emacs Mode (Default)"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h4><table> <thead> <tr> <th>Key</th> <th>Action</th> </tr> </thead> <tbody> <tr> <td><code>Ctrl+A</code></td> <td>Move to start of line</td> </tr> <tr> <td><code>Ctrl+E</code></td> <td>Move to end of line</td> </tr> <tr> <td><code>Ctrl+F</code></td> <td>Move forward one character</td> </tr> <tr> <td><code>Ctrl+B</code></td> <td>Move backward one character</td> </tr> <tr> <td><code>Alt+F</code></td> <td>Move forward one word</td> </tr> <tr> <td><code>Alt+B</code></td> <td>Move backward one word</td> </tr> <tr> <td><code>Ctrl+K</code></td> <td>Kill (cut) to end of line</td> </tr> <tr> <td><code>Ctrl+U</code></td> <td>Kill (cut) to start of line</td> </tr> <tr> <td><code>Ctrl+W</code></td> <td>Kill (cut) previous word</td> </tr> <tr> <td><code>Alt+D</code></td> <td>Kill (cut) next word</td> </tr> <tr> <td><code>Ctrl+Y</code></td> <td>Yank (paste)</td> </tr> <tr> <td><code>Ctrl+R</code></td> <td>Reverse fuzzy search</td> </tr> <tr> <td><code>Ctrl+L</code></td> <td>Clear screen</td> </tr> <tr> <td><code>Ctrl+D</code></td> <td>EOF (exit)</td> </tr> <tr> <td><code>Ctrl+C</code></td> <td>Interrupt/abort</td> </tr> </tbody> </table> <h4 id="vi-mode" class="position-relative d-flex align-items-center group"> <span>Vi Mode</span> <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="vi-mode" aria-haspopup="dialog" aria-label="Share link: Vi Mode"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h4><p>Enable vi mode:</p> <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">\</span><span class="py">set</span><span class="w"> </span><span class="py">keymap</span><span class="w"> </span><span class="py">vi</span><span class="w"> </span></span></span></code></pre></div><p><strong>Normal Mode</strong>:</p> <table> <thead> <tr> <th>Key</th> <th>Action</th> </tr> </thead> <tbody> <tr> <td><code>h</code></td> <td>Move left</td> </tr> <tr> <td><code>l</code></td> <td>Move right</td> </tr> <tr> <td><code>w</code></td> <td>Move forward one word</td> </tr> <tr> <td><code>b</code></td> <td>Move backward one word</td> </tr> <tr> <td><code>0</code></td> <td>Move to start of line</td> </tr> <tr> <td><code>$</code></td> <td>Move to end of line</td> </tr> <tr> <td><code>dd</code></td> <td>Delete line</td> </tr> <tr> <td><code>dw</code></td> <td>Delete word</td> </tr> <tr> <td><code>i</code></td> <td>Insert mode</td> </tr> <tr> <td><code>a</code></td> <td>Append mode</td> </tr> <tr> <td><code>Esc</code></td> <td>Normal mode</td> </tr> </tbody> </table> <p><strong>Insert Mode</strong>:</p> <ul> <li>Standard typing</li> <li><code>Esc</code> returns to normal mode</li> </ul> <h4 id="switching-keymaps" class="position-relative d-flex align-items-center group"> <span>Switching Keymaps</span> <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="switching-keymaps" aria-haspopup="dialog" aria-label="Share link: Switching Keymaps"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Switch</span><span class="w"> </span><span class="py">to</span><span class="w"> </span><span class="py">emacs</span><span class="w"> </span><span class="py">mode</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">\</span><span class="py">set</span><span class="w"> </span><span class="py">keymap</span><span class="w"> </span><span class="py">emacs</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Switch</span><span class="w"> </span><span class="py">to</span><span class="w"> </span><span class="py">vi</span><span class="w"> </span><span class="py">mode</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">\</span><span class="py">set</span><span class="w"> </span><span class="py">keymap</span><span class="w"> </span><span class="py">vi</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Check</span><span class="w"> </span><span class="py">current</span><span class="w"> </span><span class="py">keymap</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">\</span><span class="py">show</span><span class="w"> </span><span class="py">keymap</span><span class="w"> </span></span></span></code></pre></div> <h3 id="meta-commands" class="position-relative d-flex align-items-center group"> <span>Meta Commands</span> <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="meta-commands" aria-haspopup="dialog" aria-label="Share link: Meta Commands"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h3> <h4 id="session-management" class="position-relative d-flex align-items-center group"> <span>Session Management</span> <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="session-management" aria-haspopup="dialog" aria-label="Share link: Session Management"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h4><table> <thead> <tr> <th>Command</th> <th>Description</th> </tr> </thead> <tbody> <tr> <td><code>\connect &lt;host&gt; &lt;port&gt;</code></td> <td>Connect to server</td> </tr> <tr> <td><code>\disconnect</code></td> <td>Disconnect from server</td> </tr> <tr> <td><code>\reconnect</code></td> <td>Reconnect to server</td> </tr> <tr> <td><code>\status</code></td> <td>Show connection status</td> </tr> </tbody> </table> <h4 id="output-formatting" class="position-relative d-flex align-items-center group"> <span>Output Formatting</span> <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="output-formatting" aria-haspopup="dialog" aria-label="Share link: Output Formatting"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h4><table> <thead> <tr> <th>Command</th> <th>Description</th> </tr> </thead> <tbody> <tr> <td><code>\format table</code></td> <td>Table format (default)</td> </tr> <tr> <td><code>\format csv</code></td> <td>CSV format</td> </tr> <tr> <td><code>\format json</code></td> <td>JSON format</td> </tr> <tr> <td><code>\timing on</code></td> <td>Show query execution time</td> </tr> <tr> <td><code>\timing off</code></td> <td>Hide query execution time</td> </tr> </tbody> </table> <h4 id="database-operations" class="position-relative d-flex align-items-center group"> <span>Database Operations</span> <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="database-operations" aria-haspopup="dialog" aria-label="Share link: Database Operations"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h4><table> <thead> <tr> <th>Command</th> <th>Description</th> </tr> </thead> <tbody> <tr> <td><code>\use &lt;database&gt;</code></td> <td>Switch database</td> </tr> <tr> <td><code>\list</code> or <code>\l</code></td> <td>List databases</td> </tr> <tr> <td><code>\dt</code></td> <td>List tables</td> </tr> <tr> <td><code>\di</code></td> <td>List indexes</td> </tr> </tbody> </table> <h4 id="help-and-information" class="position-relative d-flex align-items-center group"> <span>Help and Information</span> <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="help-and-information" aria-haspopup="dialog" aria-label="Share link: Help and Information"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h4><table> <thead> <tr> <th>Command</th> <th>Description</th> </tr> </thead> <tbody> <tr> <td><code>\help</code> or <code>\h</code></td> <td>Show help</td> </tr> <tr> <td><code>\?</code></td> <td>Show meta commands</td> </tr> <tr> <td><code>\version</code></td> <td>Show Geode version</td> </tr> </tbody> </table> <h4 id="scripting" class="position-relative d-flex align-items-center group"> <span>Scripting</span> <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="scripting" aria-haspopup="dialog" aria-label="Share link: Scripting"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h4><table> <thead> <tr> <th>Command</th> <th>Description</th> </tr> </thead> <tbody> <tr> <td><code>\include &lt;file&gt;</code> or <code>\i &lt;file&gt;</code></td> <td>Execute file</td> </tr> <tr> <td><code>\echo &lt;text&gt;</code></td> <td>Print text</td> </tr> <tr> <td><code>\set &lt;var&gt; &lt;value&gt;</code></td> <td>Set variable</td> </tr> <tr> <td><code>\unset &lt;var&gt;</code></td> <td>Unset variable</td> </tr> </tbody> </table> <h3 id="scripting-and-automation" class="position-relative d-flex align-items-center group"> <span>Scripting and Automation</span> <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="scripting-and-automation" aria-haspopup="dialog" aria-label="Share link: Scripting and Automation"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h3> <h4 id="executing-files" class="position-relative d-flex align-items-center group"> <span>Executing Files</span> <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="executing-files" aria-haspopup="dialog" aria-label="Share link: Executing Files"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"><span class="line"><span class="cl"><span class="c1"># Create script file</span> </span></span><span class="line"><span class="cl">cat &gt; setup.gql <span class="s">&lt;&lt; &#39;EOF&#39; </span></span></span><span class="line"><span class="cl"><span class="s">-- setup.gql: Initialize database </span></span></span><span class="line"><span class="cl"><span class="s"> </span></span></span><span class="line"><span class="cl"><span class="s">CREATE (:Config {key: &#39;version&#39;, value: &#39;1.0&#39;}); </span></span></span><span class="line"><span class="cl"><span class="s">CREATE INDEX ON :User(email); </span></span></span><span class="line"><span class="cl"><span class="s"> </span></span></span><span class="line"><span class="cl"><span class="s">\echo &#34;Database initialized&#34; </span></span></span><span class="line"><span class="cl"><span class="s">EOF</span> </span></span><span class="line"><span class="cl"> </span></span><span class="line"><span class="cl"><span class="c1"># Execute in REPL</span> </span></span><span class="line"><span class="cl">geode&gt; <span class="se">\i</span>nclude setup.gql </span></span><span class="line"><span class="cl">-- Or shorthand </span></span><span class="line"><span class="cl">geode&gt; <span class="se">\i</span> setup.gql </span></span></code></pre></div> <h4 id="batch-execution" class="position-relative d-flex align-items-center group"> <span>Batch Execution</span> <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-execution" aria-haspopup="dialog" aria-label="Share link: Batch Execution"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"><span class="line"><span class="cl"><span class="c1"># Execute from command line</span> </span></span><span class="line"><span class="cl">geode query --file setup.gql </span></span><span class="line"><span class="cl"> </span></span><span class="line"><span class="cl"><span class="c1"># Execute multiple files</span> </span></span><span class="line"><span class="cl">geode query --file schema.gql --file data.gql </span></span></code></pre></div> <h4 id="variable-substitution" class="position-relative d-flex align-items-center group"> <span>Variable Substitution</span> <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="variable-substitution" aria-haspopup="dialog" aria-label="Share link: Variable Substitution"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Set</span><span class="w"> </span><span class="py">variables</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">\</span><span class="py">set</span><span class="w"> </span><span class="py">min_age</span><span class="w"> </span><span class="py">25</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">\</span><span class="py">set</span><span class="w"> </span><span class="py">limit</span><span class="w"> </span><span class="py">100</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Use</span><span class="w"> </span><span class="py">in</span><span class="w"> </span><span class="py">queries</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">MATCH</span><span class="w"> </span><span class="p">(</span><span class="py">p</span><span class="p">:</span><span class="nc">Person</span><span class="p">)</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">WHERE</span><span class="w"> </span><span class="py">p</span><span class="err">.</span><span class="py">age</span><span class="w"> </span><span class="err">&gt;</span><span class="p">=</span><span class="w"> </span><span class="nv">$min_age</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">p</span><span class="err">.</span><span class="py">name</span><span class="p">,</span><span class="w"> </span><span class="py">p</span><span class="err">.</span><span class="py">age</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">LIMIT</span><span class="w"> </span><span class="nv">$limit</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Unset</span><span class="w"> </span><span class="py">variables</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">\</span><span class="py">unset</span><span class="w"> </span><span class="py">min_age</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">\</span><span class="py">unset</span><span class="w"> </span><span class="py">limit</span><span class="w"> </span></span></span></code></pre></div> <h4 id="conditional-execution" class="position-relative d-flex align-items-center group"> <span>Conditional Execution</span> <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-execution" aria-haspopup="dialog" aria-label="Share link: Conditional Execution"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Check</span><span class="w"> </span><span class="py">if</span><span class="w"> </span><span class="py">table</span><span class="w"> </span><span class="py">exists</span><span class="w"> </span><span class="py">before</span><span class="w"> </span><span class="py">creating</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">\</span><span class="py">set</span><span class="w"> </span><span class="py">table_exists</span><span class="w"> </span><span class="p">(</span><span class="py">SELECT</span><span class="w"> </span><span class="py">count</span><span class="p">(</span><span class="err">*</span><span class="p">)</span><span class="w"> </span><span class="py">FROM</span><span class="w"> </span><span class="py">information_schema</span><span class="err">.</span><span class="py">tables</span><span class="w"> </span><span class="py">WHERE</span><span class="w"> </span><span class="py">table_name</span><span class="w"> </span><span class="p">=</span><span class="w"> </span><span class="err">&#39;</span><span class="py">users</span><span class="err">&#39;</span><span class="p">)</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Conditional</span><span class="w"> </span><span class="py">logic</span><span class="w"> </span><span class="py">in</span><span class="w"> </span><span class="py">script</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">\</span><span class="py">if</span><span class="w"> </span><span class="nv">$table_exists</span><span class="w"> </span><span class="p">=</span><span class="w"> </span><span class="py">0</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">CREATE</span><span class="w"> </span><span class="py">TABLE</span><span class="w"> </span><span class="py">users</span><span class="w"> </span><span class="p">(</span><span class="py">id</span><span class="w"> </span><span class="py">INTEGER</span><span class="p">,</span><span class="w"> </span><span class="py">name</span><span class="w"> </span><span class="py">STRING</span><span class="p">)</span><span class="err">;</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="err">\</span><span class="py">echo</span><span class="w"> </span><span class="s">&#34;Created users table&#34;</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">\</span><span class="py">else</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="err">\</span><span class="py">echo</span><span class="w"> </span><span class="s">&#34;Users table already exists&#34;</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">\</span><span class="py">endif</span><span class="w"> </span></span></span></code></pre></div> <h3 id="advanced-usage-patterns" class="position-relative d-flex align-items-center group"> <span>Advanced Usage Patterns</span> <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-usage-patterns" aria-haspopup="dialog" aria-label="Share link: Advanced Usage Patterns"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h3> <h4 id="multi-line-queries" class="position-relative d-flex align-items-center group"> <span>Multi-Line Queries</span> <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-line-queries" aria-haspopup="dialog" aria-label="Share link: Multi-Line Queries"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="py">geode</span><span class="err">&gt;</span><span class="w"> </span><span class="py">MATCH</span><span class="w"> </span><span class="p">(</span><span class="py">p</span><span class="p">:</span><span class="nc">Person</span><span class="p">)</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="kd">...</span><span class="w"> </span><span class="py">WHERE</span><span class="w"> </span><span class="py">p</span><span class="err">.</span><span class="py">age</span><span class="w"> </span><span class="err">&gt;</span><span class="w"> </span><span class="py">25</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="kd">...</span><span class="w"> </span><span class="py">RETURN</span><span class="w"> </span><span class="py">p</span><span class="err">.</span><span class="py">name</span><span class="p">,</span><span class="w"> </span><span class="py">p</span><span class="err">.</span><span class="py">age</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="kd">...</span><span class="w"> </span><span class="py">ORDER</span><span class="w"> </span><span class="py">BY</span><span class="w"> </span><span class="py">p</span><span class="err">.</span><span class="py">age</span><span class="w"> </span><span class="py">DESC</span><span class="err">;</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="p">|</span><span class="w"> </span><span class="py">name</span><span class="w"> </span><span class="p">|</span><span class="w"> </span><span class="py">age</span><span class="w"> </span><span class="p">|</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="p">|</span><span class="err">-------</span><span class="p">|</span><span class="err">-----</span><span class="p">|</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="kd">...</span><span class="w"> </span></span></span></code></pre></div><p><strong>Continuation Prompt</strong>: <code>...</code> indicates multi-line input mode</p> <p><strong>Complete Query</strong>: End with semicolon <code>;</code></p> <h4 id="query-history" class="position-relative d-flex align-items-center group"> <span>Query History</span> <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-history" aria-haspopup="dialog" aria-label="Share link: Query History"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">View</span><span class="w"> </span><span class="py">history</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">\</span><span class="py">history</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Execute</span><span class="w"> </span><span class="py">previous</span><span class="w"> </span><span class="kd">query</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">\</span><span class="p">!</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="nc">Execute</span><span class="w"> </span><span class="kd">query</span><span class="w"> </span><span class="nc">N</span><span class="w"> </span><span class="py">from</span><span class="w"> </span><span class="py">history</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">\</span><span class="p">!</span><span class="py">42</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Search</span><span class="w"> </span><span class="py">history</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">\</span><span class="p">!</span><span class="py">search</span><span class="w"> </span><span class="py">pattern</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Clear</span><span class="w"> </span><span class="py">history</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">\</span><span class="py">history</span><span class="w"> </span><span class="py">clear</span><span class="w"> </span></span></span></code></pre></div> <h4 id="aliases" class="position-relative d-flex align-items-center group"> <span>Aliases</span> <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="aliases" aria-haspopup="dialog" aria-label="Share link: Aliases"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Create</span><span class="w"> </span><span class="py">alias</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">\</span><span class="py">alias</span><span class="w"> </span><span class="py">lp</span><span class="w"> </span><span class="s">&#34;MATCH (p:Person) RETURN p LIMIT 10&#34;</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Use</span><span class="w"> </span><span class="py">alias</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">\</span><span class="py">lp</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">List</span><span class="w"> </span><span class="py">aliases</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">\</span><span class="py">alias</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Remove</span><span class="w"> </span><span class="py">alias</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">\</span><span class="py">unalias</span><span class="w"> </span><span class="py">lp</span><span class="w"> </span></span></span></code></pre></div> <h4 id="transactions" class="position-relative d-flex align-items-center group"> <span>Transactions</span> <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="transactions" aria-haspopup="dialog" aria-label="Share link: Transactions"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Begin</span><span class="w"> </span><span class="py">transaction</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">BEGIN</span><span class="err">;</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Execute</span><span class="w"> </span><span class="py">queries</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">CREATE</span><span class="w"> </span><span class="p">(</span><span class="py">n</span><span class="p">:</span><span class="nc">Person</span><span class="w"> </span><span class="p">{</span><span class="py">name</span><span class="p">:</span><span class="w"> </span><span class="err">&#39;</span><span class="nc">Alice</span><span class="err">&#39;</span><span class="p">})</span><span class="err">;</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">CREATE</span><span class="w"> </span><span class="p">(</span><span class="py">n</span><span class="p">:</span><span class="nc">Person</span><span class="w"> </span><span class="p">{</span><span class="py">name</span><span class="p">:</span><span class="w"> </span><span class="err">&#39;</span><span class="nc">Bob</span><span class="err">&#39;</span><span class="p">})</span><span class="err">;</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Commit</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">COMMIT</span><span class="err">;</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Or</span><span class="w"> </span><span class="py">rollback</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">ROLLBACK</span><span class="err">;</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Auto</span><span class="err">-</span><span class="py">commit</span><span class="w"> </span><span class="py">mode</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">\</span><span class="py">set</span><span class="w"> </span><span class="py">autocommit</span><span class="w"> </span><span class="kd">on</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="py">Execute</span><span class="w"> </span><span class="py">each</span><span class="w"> </span><span class="py">statement</span><span class="w"> </span><span class="py">immediately</span><span class="w"> </span><span class="p">(</span><span class="py">default</span><span class="p">)</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">\</span><span class="py">set</span><span class="w"> </span><span class="py">autocommit</span><span class="w"> </span><span class="py">off</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="py">Require</span><span class="w"> </span><span class="py">explicit</span><span class="w"> </span><span class="py">COMMIT</span><span class="w"> </span></span></span></code></pre></div> <h3 id="performance-tips" class="position-relative d-flex align-items-center group"> <span>Performance Tips</span> <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-tips" aria-haspopup="dialog" aria-label="Share link: Performance Tips"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h3> <h4 id="result-limiting" class="position-relative d-flex align-items-center group"> <span>Result Limiting</span> <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="result-limiting" aria-haspopup="dialog" aria-label="Share link: Result Limiting"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h4><p>Always use LIMIT for exploratory queries:</p> <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="err">✅</span><span class="w"> </span><span class="py">Good</span><span class="p">:</span><span class="w"> </span><span class="nc">Limited</span><span class="w"> </span><span class="py">results</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">MATCH</span><span class="w"> </span><span class="p">(</span><span class="py">n</span><span class="p">:</span><span class="nc">Person</span><span class="p">)</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">n</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">LIMIT</span><span class="w"> </span><span class="py">10</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="err">❌</span><span class="w"> </span><span class="py">Bad</span><span class="p">:</span><span class="w"> </span><span class="nc">Unbounded</span><span class="w"> </span><span class="py">results</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">MATCH</span><span class="w"> </span><span class="p">(</span><span class="py">n</span><span class="p">:</span><span class="nc">Person</span><span class="p">)</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">n</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="py">May</span><span class="w"> </span><span class="py">return</span><span class="w"> </span><span class="py">millions</span><span class="w"> </span><span class="py">of</span><span class="w"> </span><span class="py">rows</span><span class="w"> </span></span></span></code></pre></div> <h4 id="timing-queries" class="position-relative d-flex align-items-center group"> <span>Timing Queries</span> <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="timing-queries" aria-haspopup="dialog" aria-label="Share link: Timing Queries"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h4><p>Enable timing to identify slow queries:</p> <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">\</span><span class="py">timing</span><span class="w"> </span><span class="kd">on</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">MATCH</span><span class="w"> </span><span class="p">(</span><span class="py">n</span><span class="p">:</span><span class="nc">Person</span><span class="p">)</span><span class="err">-</span><span class="p">[:</span><span class="nc">KNOWS</span><span class="err">*</span><span class="py">2</span><span class="err">.</span><span class="mf">.4</span><span class="p">]</span><span class="err">-&gt;</span><span class="p">(</span><span class="py">m</span><span class="p">:</span><span class="nc">Person</span><span class="p">)</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">n</span><span class="err">.</span><span class="py">name</span><span class="p">,</span><span class="w"> </span><span class="py">m</span><span class="err">.</span><span class="py">name</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">LIMIT</span><span class="w"> </span><span class="py">100</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Output</span><span class="p">:</span><span class="w"> </span><span class="nc">Query</span><span class="w"> </span><span class="py">executed</span><span class="w"> </span><span class="py">in</span><span class="w"> </span><span class="py">1</span><span class="mf">.234</span><span class="py">s</span><span class="w"> </span></span></span></code></pre></div> <h4 id="using-pagination" class="position-relative d-flex align-items-center group"> <span>Using Pagination</span> <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="using-pagination" aria-haspopup="dialog" aria-label="Share link: Using Pagination"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h4><p>For large result sets, use pagination:</p> <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">\</span><span class="py">pagesize</span><span class="w"> </span><span class="py">25</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">\</span><span class="py">paging</span><span class="w"> </span><span class="kd">on</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">MATCH</span><span class="w"> </span><span class="p">(</span><span class="py">n</span><span class="p">:</span><span class="nc">Person</span><span class="p">)</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">n</span><span class="err">.</span><span class="py">name</span><span class="p">,</span><span class="w"> </span><span class="py">n</span><span class="err">.</span><span class="py">age</span><span class="w"> </span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">ORDER</span><span class="w"> </span><span class="py">BY</span><span class="w"> </span><span class="py">n</span><span class="err">.</span><span class="py">name</span><span class="w"> </span></span></span></code></pre></div> <h3 id="troubleshooting" class="position-relative d-flex align-items-center group"> <span>Troubleshooting</span> <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="troubleshooting" aria-haspopup="dialog" aria-label="Share link: Troubleshooting"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h3> <h4 id="syntax-highlighting-not-working" class="position-relative d-flex align-items-center group"> <span>Syntax Highlighting Not Working</span> <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="syntax-highlighting-not-working" aria-haspopup="dialog" aria-label="Share link: Syntax Highlighting Not Working"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h4><p><strong>Issue</strong>: Colors not displayed</p> <p><strong>Solutions</strong>:</p> <ol> <li> <p>Verify terminal supports colors:</p> <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"><span class="line"><span class="cl"><span class="nb">echo</span> <span class="nv">$TERM</span> <span class="c1"># Should be xterm-256color or similar</span> </span></span></code></pre></div></li> <li> <p>Manually enable:</p> <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">\</span><span class="py">set</span><span class="w"> </span><span class="py">highlight</span><span class="w"> </span><span class="kd">on</span><span class="w"> </span></span></span></code></pre></div></li> <li> <p>Check color support:</p> <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"><span class="line"><span class="cl">tput colors <span class="c1"># Should return 256</span> </span></span></code></pre></div></li> </ol> <h4 id="fuzzy-search-not-finding-results" class="position-relative d-flex align-items-center group"> <span>Fuzzy Search Not Finding Results</span> <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="fuzzy-search-not-finding-results" aria-haspopup="dialog" aria-label="Share link: Fuzzy Search Not Finding Results"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h4><p><strong>Issue</strong>: Expected query not in results</p> <p><strong>Solutions</strong>:</p> <ol> <li> <p>Check history:</p> <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">\</span><span class="py">history</span><span class="w"> </span></span></span></code></pre></div></li> <li> <p>Try broader search terms</p> </li> <li> <p>Clear and rebuild history:</p> <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">\</span><span class="py">history</span><span class="w"> </span><span class="py">clear</span><span class="w"> </span></span></span></code></pre></div></li> </ol> <h4 id="session-not-persisting" class="position-relative d-flex align-items-center group"> <span>Session Not Persisting</span> <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="session-not-persisting" aria-haspopup="dialog" aria-label="Share link: Session Not Persisting"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h4><p><strong>Issue</strong>: Session state lost between sessions</p> <p><strong>Solutions</strong>:</p> <ol> <li> <p>Check session file location:</p> <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"><span class="line"><span class="cl">ls -la ~/.local/share/geode/session.json </span></span></code></pre></div></li> <li> <p>Manually save session:</p> <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">\</span><span class="py">save</span><span class="err">-</span><span class="py">session</span><span class="w"> </span></span></span></code></pre></div></li> <li> <p>Check file permissions:</p> <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"><span class="line"><span class="cl">chmod <span class="m">644</span> ~/.local/share/geode/session.json </span></span></code></pre></div></li> </ol> <h4 id="pagination-issues" class="position-relative d-flex align-items-center group"> <span>Pagination Issues</span> <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="pagination-issues" aria-haspopup="dialog" aria-label="Share link: Pagination Issues"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h4><p><strong>Issue</strong>: Page navigation not working</p> <p><strong>Solutions</strong>:</p> <ol> <li> <p>Verify pagination is enabled:</p> <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">\</span><span class="py">show</span><span class="w"> </span><span class="py">paging</span><span class="w"> </span></span></span></code></pre></div></li> <li> <p>Check page size:</p> <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">\</span><span class="py">show</span><span class="w"> </span><span class="py">pagesize</span><span class="w"> </span></span></span></code></pre></div></li> <li> <p>Re-run query to reset pagination</p> </li> </ol> <h3 id="best-practices" class="position-relative d-flex align-items-center group"> <span>Best Practices</span> <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"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h3> <h4 id="interactive-workflow" class="position-relative d-flex align-items-center group"> <span>Interactive Workflow</span> <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-workflow" aria-haspopup="dialog" aria-label="Share link: Interactive Workflow"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h4><ol> <li><strong>Use tab completion</strong> for commands (when available)</li> <li><strong>Enable timing</strong> to monitor performance</li> <li><strong>Use LIMIT</strong> for exploratory queries</li> <li><strong>Save useful queries</strong> in scripts</li> <li><strong>Use aliases</strong> for frequent commands</li> </ol> <h4 id="script-organization" class="position-relative d-flex align-items-center group"> <span>Script Organization</span> <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="script-organization" aria-haspopup="dialog" aria-label="Share link: Script Organization"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h4><ol> <li><strong>Separate schema and data</strong> into different files</li> <li><strong>Use comments</strong> liberally</li> <li><strong>Version control scripts</strong> with git</li> <li><strong>Test scripts</strong> in development environment first</li> <li><strong>Use variables</strong> for configurable values</li> </ol> <h4 id="productivity" class="position-relative d-flex align-items-center group"> <span>Productivity</span> <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="productivity" aria-haspopup="dialog" aria-label="Share link: Productivity"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h4><ol> <li><strong>Learn keybindings</strong> for your preferred mode (emacs/vi)</li> <li><strong>Use fuzzy search</strong> instead of typing long queries</li> <li><strong>Configure pagination</strong> for your typical result size</li> <li><strong>Save session</strong> to preserve preferences</li> <li><strong>Create aliases</strong> for common operations</li> </ol> <h3 id="next-steps" class="position-relative d-flex align-items-center group"> <span>Next Steps</span> <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="next-steps" aria-haspopup="dialog" aria-label="Share link: Next Steps"> <i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i> <span class="visually-hidden">Share link</span> </button> </h3><p><strong>Explore More</strong>:</p> <ul> <li><a href="/docs/gql/guide/" >GQL Guide</a> - Learn GQL syntax</li> <li><a href="/docs/guides/testing-strategies/" >Testing Strategies</a> - Test your queries</li> <li><a href="/docs/development/lsp-guide/" >LSP Integration</a> - IDE support</li> </ul> <p><strong>Related Topics</strong>:</p> <ul> <li><a href="/docs/query/performance-tuning/" >Query Performance</a> - Optimize queries</li> <li><a href="/docs/transactions/advanced-patterns/" >Transaction Patterns</a> - Advanced transactions</li> <li><a href="/docs/development/" >Scripting</a> - Automation</li> </ul> <p><strong>Tools</strong>:</p> <ul> <li><a href="/docs/reference/cli-and-api/" >Geode CLI</a> - Command-line reference</li> <li><a href="/docs/security/session-management/" >Session Management</a> - Session parameters</li> <li><a href="/docs/ops/telemetry-advanced/" >Monitoring</a> - Performance monitoring</li> </ul> <hr> <p><strong>Features</strong>: Syntax highlighting, fuzzy search, pagination, session persistence <strong>Keymaps</strong>: Emacs (default), Vi <strong>Status</strong>: Production-ready (44 tests passing) <strong>Date</strong>: November 17, 2025</p>