<!-- 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’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&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">"geode> "</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">'</span><span class="py">Alice</span><span class="err">'</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">></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 (> 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 > 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">></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">></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">></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">></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 <n></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> (Press Ctrl+R)
</span></span><span class="line"><span class="cl">(reverse-fuzzy-search)`':
</span></span><span class="line"><span class="cl">
</span></span><span class="line"><span class="cl">(Type 'mat')
</span></span><span class="line"><span class="cl">(reverse-fuzzy-search)`mat': 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: "match person"
</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. "MATCH (n:Person) RETURN n" (score: 5500) - exact + starts with
</span></span><span class="line"><span class="cl">2. "MATCH (p:Person) WHERE p.age > 25" (score: 5200) - exact + contains
</span></span><span class="line"><span class="cl">3. "RETURN persons" (score: 320) - contains substring
</span></span><span class="line"><span class="cl">4. "CREATE (n:PersonNode)" (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">"database"</span><span class="p">:</span> <span class="s2">"mydb"</span><span class="p">,</span>
</span></span><span class="line"><span class="cl"> <span class="nt">"in_transaction"</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">"format"</span><span class="p">:</span> <span class="s2">"table"</span><span class="p">,</span>
</span></span><span class="line"><span class="cl"> <span class="nt">"show_timing"</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">"keymap"</span><span class="p">:</span> <span class="s2">"emacs"</span><span class="p">,</span>
</span></span><span class="line"><span class="cl"> <span class="nt">"last_server"</span><span class="p">:</span> <span class="s2">"localhost:3141"</span><span class="p">,</span>
</span></span><span class="line"><span class="cl"> <span class="nt">"variables"</span><span class="p">:</span> <span class="p">{</span>
</span></span><span class="line"><span class="cl"> <span class="nt">"foo"</span><span class="p">:</span> <span class="s2">"bar"</span><span class="p">,</span>
</span></span><span class="line"><span class="cl"> <span class="nt">"baz"</span><span class="p">:</span> <span class="s2">"qux"</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 <host> <port></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 <database></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 <file></code> or <code>\i <file></code></td>
<td>Execute file</td>
</tr>
<tr>
<td><code>\echo <text></code></td>
<td>Print text</td>
</tr>
<tr>
<td><code>\set <var> <value></code></td>
<td>Set variable</td>
</tr>
<tr>
<td><code>\unset <var></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 > setup.gql <span class="s"><< 'EOF'
</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: 'version', value: '1.0'});
</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 "Database initialized"
</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> <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> <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">></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">'</span><span class="py">users</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="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">"Created users table"</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">"Users table already exists"</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">></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">></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">"MATCH (p:Person) RETURN p LIMIT 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="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">'</span><span class="nc">Alice</span><span class="err">'</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">'</span><span class="nc">Bob</span><span class="err">'</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">-></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>
Advanced REPL Features Guide
Complete guide to Geode's advanced REPL features including syntax highlighting, fuzzy search, result pagination, session persistence, scripting, and productivity enhancements.