Session Management

Session management in Geode provides stateful connections between clients and the database server, maintaining context for authentication, transactions, temporary data, and user preferences. Proper session management is essential for security, resource efficiency, and application scalability. <h3 id="session-fundamentals" class="position-relative d-flex align-items-center group"> Session Fundamentals <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-fundamentals" aria-haspopup="dialog" aria-label="Share link: Session Fundamentals"> Share link </button> </h3><div id="headingShareModal" class="heading-share-modal" role="dialog" aria-modal="true" aria-labelledby="headingShareTitle" hidden> <div class="hsm-dialog" role="document"> <div class="hsm-header"> <h2 id="headingShareTitle" class="h6 mb-0 fw-bold">Share this section</h2> <button type="button" class="hsm-close" aria-label="Close"> </button> </div> <div class="hsm-body"> <label for="headingShareInput" class="form-label small text-muted mb-1 text-uppercase fw-bold" style="font-size: 0.7rem; letter-spacing: 0.5px;">Permalink</label> <div class="input-group mb-4 hsm-url-group"> <input id="headingShareInput" type="text" class="form-control font-monospace" readonly aria-readonly="true" style="font-size: 0.85rem;" /> <button class="btn btn-primary hsm-copy" type="button" aria-label="Copy" title="Copy"> </button> </div> <div class="small fw-bold mb-2 text-muted text-uppercase" style="font-size: 0.7rem; letter-spacing: 0.5px;">Share via</div> <div class="hsm-share-grid"> <a id="share-twitter" class="btn btn-outline-secondary w-100" target="_blank" rel="noopener noreferrer"> Twitter </a> <a id="share-linkedin" class="btn btn-outline-secondary w-100" target="_blank" rel="noopener noreferrer"> LinkedIn </a> <a id="share-facebook" class="btn btn-outline-secondary w-100" target="_blank" rel="noopener noreferrer"> Facebook </a> </div> </div> </div> </div> <style> .heading-share-modal { position: fixed; inset: 0; display: flex; justify-content: center; align-items: center; background: rgba(0, 0, 0, 0.6); z-index: 1050; padding: 1rem; backdrop-filter: blur(4px); -webkit-backdrop-filter: blur(4px); } .heading-share-modal[hidden] { display: none !important; } .hsm-dialog { max-width: 420px; width: 100%; background: var(--bs-body-bg, #fff); color: var(--bs-body-color, #212529); border: 1px solid var(--bs-border-color, rgba(0,0,0,0.1)); border-radius: 1rem; box-shadow: 0 25px 50px -12px rgba(0, 0, 0, 0.25); overflow: hidden; animation: hsm-fade-in 0.2s ease-out; } @keyframes hsm-fade-in { from { opacity: 0; transform: scale(0.95); } to { opacity: 1; transform: scale(1); } } [data-bs-theme="dark"] .hsm-dialog { background: #1e293b; border-color: rgba(255,255,255,0.1); color: #f8f9fa; } .hsm-header { display: flex; justify-content: space-between; align-items: center; padding: 1rem 1.5rem; border-bottom: 1px solid var(--bs-border-color, rgba(0,0,0,0.1)); background: rgba(0,0,0,0.02); } [data-bs-theme="dark"] .hsm-header { background: rgba(255,255,255,0.02); border-color: rgba(255,255,255,0.1); } .hsm-close { background: transparent; border: none; color: inherit; opacity: 0.5; padding: 0.25rem 0.5rem; border-radius: 0.25rem; font-size: 1.2rem; line-height: 1; transition: opacity 0.2s; } .hsm-close:hover { opacity: 1; } .hsm-body { padding: 1.5rem; } .hsm-url-group { display: flex !important; align-items: stretch; } .hsm-url-group .form-control { flex: 1; min-width: 0; margin: 0; background: var(--bs-secondary-bg, #f8f9fa); border-color: var(--bs-border-color, #dee2e6); border-top-right-radius: 0; border-bottom-right-radius: 0; height: 42px; } .hsm-url-group .btn { flex: 0 0 auto; margin: 0; margin-left: -1px; border-top-left-radius: 0; border-bottom-left-radius: 0; height: 42px; display: flex; align-items: center; justify-content: center; padding: 0 1.25rem; z-index: 2; } [data-bs-theme="dark"] .hsm-url-group .form-control { background: #0f172a; border-color: #334155; color: #e2e8f0; } .hsm-share-grid { display: flex; flex-direction: column; gap: 0.5rem; } .hsm-share-grid .btn { display: flex; align-items: center; justify-content: center; font-size: 0.9rem; padding: 0.6rem; border-color: var(--bs-border-color); width: 100%; } [data-bs-theme="dark"] .hsm-share-grid .btn { color: #e2e8f0; border-color: #475569; } [data-bs-theme="dark"] .hsm-share-grid .btn:hover { background: #334155; border-color: #cbd5e1; } </style> <script> (function(){ const modal = document.getElementById('headingShareModal'); if(!modal) return; const input = modal.querySelector('#headingShareInput'); const copyBtn = modal.querySelector('.hsm-copy'); const twitter = modal.querySelector('#share-twitter'); const linkedin = modal.querySelector('#share-linkedin'); const facebook = modal.querySelector('#share-facebook'); const closeBtn = modal.querySelector('.hsm-close'); let lastFocus=null; let trapBound=false; function buildUrl(id){ return window.location.origin + window.location.pathname + '#' + id; } function isOpen(){ return !modal.hasAttribute('hidden'); } function hydrate(id){ const url=buildUrl(id); input.value=url; const enc=encodeURIComponent(url); const text=encodeURIComponent(document.title); if(twitter) twitter.href=`https://twitter.com/intent/tweet?url=${enc}&text=${text}`; if(linkedin) linkedin.href=`https://www.linkedin.com/sharing/share-offsite/?url=${enc}`; if(facebook) facebook.href=`https://www.facebook.com/sharer/sharer.php?u=${enc}`; } function openModal(id){ lastFocus=document.activeElement; hydrate(id); if(!isOpen()){ modal.removeAttribute('hidden'); } requestAnimationFrame(()=>{ input.focus(); }); trapFocus(); } function closeModal(){ if(!isOpen()) return; modal.setAttribute('hidden',''); if(lastFocus && typeof lastFocus.focus==='function') lastFocus.focus(); } function copyCurrent(){ try{ navigator.clipboard.writeText(input.value).then(()=>feedback(true),()=>fallback()); } catch(e){ fallback(); } } function fallback(){ input.select(); try{ document.execCommand('copy'); feedback(true);}catch(e){ feedback(false);} } function feedback(ok){ if(!copyBtn) return; const icon=copyBtn.querySelector('i'); if(!icon) return; const prev=copyBtn.getAttribute('data-prev')||icon.className; if(!copyBtn.getAttribute('data-prev')) copyBtn.setAttribute('data-prev',prev); icon.className= ok ? 'fa-duotone fa-clipboard-check':'fa-duotone fa-circle-exclamation'; setTimeout(()=>{ icon.className=prev; },1800); } function handleShareClick(e){ e.preventDefault(); const btn=e.currentTarget; const id=btn.getAttribute('data-share-target'); if(id) openModal(id); } function bindShareButtons(){ document.querySelectorAll('.h-share').forEach(btn=>{ if(!btn.dataset.hShareBound){ btn.addEventListener('click', handleShareClick); btn.dataset.hShareBound='1'; } }); } bindShareButtons(); if(document.readyState==='loading'){ document.addEventListener('DOMContentLoaded', bindShareButtons); } else { requestAnimationFrame(bindShareButtons); } document.addEventListener('click', function(e){ const shareBtn=e.target.closest && e.target.closest('.h-share'); if(shareBtn && !shareBtn.dataset.hShareBound){ handleShareClick.call(shareBtn, e); } }, true); document.addEventListener('click', e=>{ if(e.target===modal) closeModal(); if(e.target.closest && e.target.closest('.hsm-close')){ e.preventDefault(); closeModal(); } if(copyBtn && (e.target===copyBtn || (e.target.closest && e.target.closest('.hsm-copy')))) { e.preventDefault(); copyCurrent(); } }); document.addEventListener('keydown', e=>{ if(e.key==='Escape' && isOpen()) closeModal(); }); function trapFocus(){ if(trapBound) return; trapBound=true; modal.addEventListener('keydown', f=>{ if(f.key==='Tab' && isOpen()){ const focusable=[...modal.querySelectorAll('a[href],button,input,textarea,select,[tabindex]:not([tabindex="-1"])')].filter(el=>!el.hasAttribute('disabled')); if(!focusable.length) return; const first=focusable[0]; const last=focusable[focusable.length-1]; if(f.shiftKey && document.activeElement===first){ f.preventDefault(); last.focus(); } else if(!f.shiftKey && document.activeElement===last){ f.preventDefault(); first.focus(); } } }); } if(closeBtn) closeBtn.addEventListener('click', e=>{ e.preventDefault(); closeModal(); }); })(); </script>A session in Geode represents a stateful connection between a client and the server, maintaining: <ul> <li>Authentication Context: User identity and permissions</li> <li>Transaction State: Active transactions and savepoints</li> <li>Session Variables: User-defined configuration and state</li> <li>Temporary Objects: Session-scoped temporary tables and data</li> <li>Query History: Recently executed queries for caching</li> <li>Connection Metadata: Client information and connection details</li> </ul> <h4 id="session-lifecycle" class="position-relative d-flex align-items-center group"> Session Lifecycle <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-lifecycle" aria-haspopup="dialog" aria-label="Share link: Session Lifecycle"> Share link </button> </h4><ol> <li>Connection: Client establishes QUIC connection to server</li> <li>Authentication: Client authenticates with credentials</li> <li>Session Creation: Server creates session with unique identifier</li> <li>Active Usage: Client executes queries, manages transactions</li> <li>Idle Period: Session remains open but inactive</li> <li>Termination: Session closed gracefully or by timeout</li> </ol> <h3 id="creating-and-managing-sessions" class="position-relative d-flex align-items-center group"> Creating and Managing Sessions <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="creating-and-managing-sessions" aria-haspopup="dialog" aria-label="Share link: Creating and Managing Sessions"> Share link </button> </h3> <h4 id="client-side-session-management" class="position-relative d-flex align-items-center group"> Client-Side Session Management <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="client-side-session-management" aria-haspopup="dialog" aria-label="Share link: Client-Side Session Management"> Share link </button> </h4>Python Client <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python">from geode_client import Client client = Client(host="geode.example.com", port=3141, skip_verify=True) async with client.connection() as conn: # Session-scoped variables live on the connection await conn.execute("SET SESSION tenant_id = 'tenant_123'") # Start transaction within the session await conn.begin() try: await conn.execute("CREATE (:Person {name: 'Bob'})") await conn.commit() except Exception: await conn.rollback() raise # Session variables persist for the connection lifetime result, _ = await conn.query("RETURN current_tenant_id() AS tenant_id") tenant_id = result.rows[0]["tenant_id"].as_string </code></pre></div>Go Client <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-go" data-lang="go">import ( "context" "database/sql" "log" _ "geodedb.com/geode" ) db, err := sql.Open("geode", "quic://geode.example.com:3141") if err != nil { log.Fatal(err) } defer db.Close() // Set session variables _, err = db.ExecContext(context.Background(), "SET SESSION tenant_id = 'tenant_123'") // Execute queries in session context rows, err := db.QueryContext( context.Background(), "MATCH (p:Person) WHERE p.tenant_id = current_tenant_id() RETURN p", ) </code></pre></div>Rust Client <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-rust" data-lang="rust">use geode_client::Client; let client = Client::new("geode.example.com", 3141).skip_verify(true); let mut conn = client.connect().await?; conn.query("SET SESSION tenant_id = 'tenant_123'").await?; let (page, _) = conn .query("MATCH (p:Person) WHERE p.tenant_id = current_tenant_id() RETURN p") .await?; </code></pre></div> <h4 id="server-side-session-configuration" class="position-relative d-flex align-items-center group"> Server-Side Session Configuration <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="server-side-session-configuration" aria-haspopup="dialog" aria-label="Share link: Server-Side Session Configuration"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># Configure session behavior geode serve --session-timeout=1800 \ --session-max-idle=900 \ --session-max-lifetime=86400 \ --persistent-sessions=true \ --session-storage=redis </code></pre></div>Configuration file: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-yaml" data-lang="yaml">sessions: timeout: 1800 # 30 minutes max_idle: 900 # 15 minutes max_lifetime: 86400 # 24 hours max_per_user: 5 persistent: true storage: backend: "redis" redis: url: "redis://redis.example.com:6379/0" password_file: "/etc/geode/secrets/redis-password.txt" tls: true pool_size: 100 </code></pre></div> <h3 id="session-variables" class="position-relative d-flex align-items-center group"> Session Variables <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-variables" aria-haspopup="dialog" aria-label="Share link: Session Variables"> Share link </button> </h3>Store session-specific configuration and state: <h4 id="setting-session-variables" class="position-relative d-flex align-items-center group"> Setting Session Variables <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="setting-session-variables" aria-haspopup="dialog" aria-label="Share link: Setting Session Variables"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Set session variables SET SESSION tenant_id = 'tenant_123'; SET SESSION language = 'en-US'; SET SESSION timezone = 'America/New_York'; SET SESSION isolation_level = 'SNAPSHOT'; SET SESSION query_timeout = 300; -- Set multiple variables SET SESSION { tenant_id: 'tenant_123', department: 'Engineering', role: 'Developer' }; </code></pre></div> <h4 id="reading-session-variables" class="position-relative d-flex align-items-center group"> Reading Session Variables <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="reading-session-variables" aria-haspopup="dialog" aria-label="Share link: Reading Session Variables"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Get specific variable RETURN current_session_var('tenant_id'); -- Get all session variables SHOW SESSION VARIABLES; -- Use in queries MATCH (p:Person) WHERE p.tenant_id = current_session_var('tenant_id') RETURN p; </code></pre></div> <h4 id="resetting-session-variables" class="position-relative d-flex align-items-center group"> Resetting Session Variables <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="resetting-session-variables" aria-haspopup="dialog" aria-label="Share link: Resetting Session Variables"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Reset specific variable RESET SESSION tenant_id; -- Reset all variables RESET SESSION ALL; </code></pre></div> <h4 id="session-variable-scope" class="position-relative d-flex align-items-center group"> Session Variable Scope <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-variable-scope" aria-haspopup="dialog" aria-label="Share link: Session Variable Scope"> Share link </button> </h4>Session variables are accessible to: <ul> <li>All queries in the session</li> <li>All transactions in the session</li> <li>Row-Level Security policies</li> <li>User-defined functions called within the session</li> </ul> <h3 id="session-timeout-management" class="position-relative d-flex align-items-center group"> Session Timeout Management <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="session-timeout-management" aria-haspopup="dialog" aria-label="Share link: Session Timeout Management"> Share link </button> </h3> <h4 id="idle-timeout" class="position-relative d-flex align-items-center group"> Idle Timeout <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="idle-timeout" aria-haspopup="dialog" aria-label="Share link: Idle Timeout"> Share link </button> </h4>Sessions terminated after period of inactivity: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-yaml" data-lang="yaml">sessions: max_idle: 900 # Terminate after 15 minutes of inactivity idle_timeout_warning: enabled: true warning_seconds: 60 # Warn client 60 seconds before timeout </code></pre></div>Client receives warning before timeout: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python">import asyncio async with client.connection() as conn: while True: await conn.query("RETURN 1 AS ok") await asyncio.sleep(300) </code></pre></div> <h4 id="absolute-timeout" class="position-relative d-flex align-items-center group"> Absolute Timeout <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="absolute-timeout" aria-haspopup="dialog" aria-label="Share link: Absolute Timeout"> Share link </button> </h4>Maximum session lifetime regardless of activity: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-yaml" data-lang="yaml">sessions: max_lifetime: 86400 # 24 hours maximum enforce_max_lifetime: true </code></pre></div> <h4 id="keep-alive" class="position-relative d-flex align-items-center group"> Keep-Alive <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="keep-alive" aria-haspopup="dialog" aria-label="Share link: Keep-Alive"> Share link </button> </h4>Prevent timeout with periodic ping: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python"># Application-level keep-alive (periodic query) import asyncio client = Client(host="geode.example.com", port=3141, skip_verify=True) async with client.connection() as conn: while True: await conn.query("RETURN 1 AS ok") await asyncio.sleep(300) </code></pre></div>Manual ping: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Send explicit ping PING; -- Response: PONG </code></pre></div> <h3 id="concurrent-session-management" class="position-relative d-flex align-items-center group"> Concurrent Session Management <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="concurrent-session-management" aria-haspopup="dialog" aria-label="Share link: Concurrent Session Management"> Share link </button> </h3> <h4 id="maximum-sessions-per-user" class="position-relative d-flex align-items-center group"> Maximum Sessions Per User <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="maximum-sessions-per-user" aria-haspopup="dialog" aria-label="Share link: Maximum Sessions Per User"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-yaml" data-lang="yaml">sessions: max_per_user: 5 exceed_policy: "terminate_oldest" # terminate_oldest, deny_new, allow_all </code></pre></div>When limit exceeded: <ul> <li>terminate_oldest: Oldest session automatically closed</li> <li>deny_new: New session creation denied</li> <li>allow_all: No limit enforced (not recommended)</li> </ul> <h4 id="session-prioritization" class="position-relative d-flex align-items-center group"> Session Prioritization <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-prioritization" aria-haspopup="dialog" aria-label="Share link: Session Prioritization"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Create high-priority session SET SESSION priority = 'high'; -- Low-priority sessions may be terminated first under resource pressure </code></pre></div> <h4 id="viewing-active-sessions" class="position-relative d-flex align-items-center group"> Viewing Active Sessions <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="viewing-active-sessions" aria-haspopup="dialog" aria-label="Share link: Viewing Active Sessions"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># List all active sessions geode sessions list # Example output: # Session ID | User | Connected | Last Active | Queries # sess_abc123 | [email protected] | 2h 15m ago | 5m ago | 1,234 # sess_def456 | [email protected] | 45m ago | 45m ago | 67 # sess_ghi789 | [email protected] | 10m ago | 2m ago | 345 # Filter sessions geode sessions list --user=[email protected] geode sessions list --idle-longer-than=30m </code></pre></div> <h4 id="terminating-sessions" class="position-relative d-flex align-items-center group"> Terminating Sessions <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="terminating-sessions" aria-haspopup="dialog" aria-label="Share link: Terminating Sessions"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># Terminate specific session geode sessions kill --session-id=sess_abc123 # Terminate all sessions for user geode sessions kill --user=[email protected] # Terminate idle sessions geode sessions cleanup --idle-timeout=1800 # Graceful termination with warning geode sessions kill --session-id=sess_abc123 --graceful --warning-seconds=60 </code></pre></div> <h3 id="session-persistence" class="position-relative d-flex align-items-center group"> Session Persistence <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"> Share link </button> </h3> <h4 id="persistent-sessions" class="position-relative d-flex align-items-center group"> Persistent Sessions <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="persistent-sessions" aria-haspopup="dialog" aria-label="Share link: Persistent Sessions"> Share link </button> </h4>Sessions survive server restarts: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-yaml" data-lang="yaml">sessions: persistent: true storage: backend: "redis" # redis, postgresql, file redis: url: "redis://redis.example.com:6379/0" password_file: "/etc/geode/secrets/redis-password.txt" key_prefix: "geode:session:" ttl: 86400 # Alternative: PostgreSQL # postgresql: # connection: "postgresql://geode:[email protected]/sessions" # table: "geode_sessions" # Alternative: File-based (development only) # file: # directory: "/var/lib/geode/sessions" </code></pre></div>Client reconnection after server restart: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python"># Client automatically reconnects to existing session client = Client( host='geode.example.com', session_id='sess_abc123', # Reuse existing session auto_reconnect=True ) </code></pre></div> <h3 id="transaction-sessions" class="position-relative d-flex align-items-center group"> Transaction Sessions <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="transaction-sessions" aria-haspopup="dialog" aria-label="Share link: Transaction Sessions"> Share link </button> </h3> <h4 id="session-scoped-transactions" class="position-relative d-flex align-items-center group"> Session-Scoped Transactions <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-scoped-transactions" aria-haspopup="dialog" aria-label="Share link: Session-Scoped Transactions"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Begin transaction in session BEGIN; -- Transaction state maintained in session CREATE (:Person {name: 'Alice'}); -- Connection can be lost and restored -- Transaction state persists in session -- Complete transaction COMMIT; </code></pre></div> <h4 id="savepoints" class="position-relative d-flex align-items-center group"> Savepoints <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="savepoints" aria-haspopup="dialog" aria-label="Share link: Savepoints"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">BEGIN; CREATE (:Person {name: 'Bob'}); -- Create savepoint SAVEPOINT after_bob; CREATE (:Person {name: 'Carol'}); -- Rollback to savepoint ROLLBACK TO SAVEPOINT after_bob; -- Bob exists, Carol does not COMMIT; </code></pre></div> <h3 id="temporary-objects" class="position-relative d-flex align-items-center group"> Temporary Objects <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="temporary-objects" aria-haspopup="dialog" aria-label="Share link: Temporary Objects"> Share link </button> </h3> <h4 id="session-scoped-temporary-data" class="position-relative d-flex align-items-center group"> Session-Scoped Temporary Data <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-scoped-temporary-data" aria-haspopup="dialog" aria-label="Share link: Session-Scoped Temporary Data"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Create temporary table for session CREATE TEMPORARY TABLE session_data ( key STRING, value STRING ); -- Insert data visible only in this session INSERT INTO session_data VALUES ('temp_key', 'temp_value'); -- Query temporary data SELECT * FROM session_data; -- Temporary table automatically dropped when session ends </code></pre></div> <h4 id="temporary-graphs" class="position-relative d-flex align-items-center group"> Temporary Graphs <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="temporary-graphs" aria-haspopup="dialog" aria-label="Share link: Temporary Graphs"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Create temporary graph for analysis CREATE TEMPORARY GRAPH analysis_graph; -- Load data into temporary graph INSERT INTO analysis_graph MATCH (p:Person)-[:KNOWS]->(f:Person) RETURN p, f; -- Analyze in temporary graph USE GRAPH analysis_graph; MATCH (p:Person) RETURN count(p); -- Temporary graph automatically removed when session ends </code></pre></div> <h3 id="session-security" class="position-relative d-flex align-items-center group"> Session Security <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-security" aria-haspopup="dialog" aria-label="Share link: Session Security"> Share link </button> </h3> <h4 id="session-token-security" class="position-relative d-flex align-items-center group"> Session Token Security <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-token-security" aria-haspopup="dialog" aria-label="Share link: Session Token Security"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python"># Sessions use secure tokens client = Client( host='geode.example.com', username='[email protected]', password='SecurePassword' ) # Server returns session token # Token format: sess_<cryptographically_secure_random_string> # Token entropy: 256 bits # Token rotation: Automatic on sensitive operations </code></pre></div> <h4 id="session-hijacking-prevention" class="position-relative d-flex align-items-center group"> Session Hijacking Prevention <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-hijacking-prevention" aria-haspopup="dialog" aria-label="Share link: Session Hijacking Prevention"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-yaml" data-lang="yaml">sessions: security: # Bind session to IP address bind_to_ip: true # Bind session to client certificate bind_to_certificate: true # Require periodic re-authentication reauth_interval: 3600 # Re-auth every hour # Detect suspicious session activity anomaly_detection: true terminate_on_anomaly: true </code></pre></div> <h4 id="session-audit-logging" class="position-relative d-flex align-items-center group"> Session Audit Logging <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="session-audit-logging" aria-haspopup="dialog" aria-label="Share link: Session Audit Logging"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-yaml" data-lang="yaml">audit: sessions: log_creation: true log_termination: true log_timeout: true log_variable_changes: true log_authentication: true </code></pre></div>Example audit log: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-json" data-lang="json">{ "event": "session_created", "session_id": "sess_abc123", "user": "[email protected]", "ip_address": "192.168.1.100", "timestamp": "2026-01-24T10:15:32.123Z", "client_info": { "user_agent": "geode-client-python/0.3.19", "platform": "linux" } } </code></pre></div> <h3 id="session-monitoring" class="position-relative d-flex align-items-center group"> Session Monitoring <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-monitoring" aria-haspopup="dialog" aria-label="Share link: Session Monitoring"> Share link </button> </h3> <h4 id="session-metrics" class="position-relative d-flex align-items-center group"> Session Metrics <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="session-metrics" aria-haspopup="dialog" aria-label="Share link: Session Metrics"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># View session statistics geode stats --component=sessions # Example output: # Active Sessions: 1,247 # Peak Sessions (24h): 2,456 # Average Session Duration: 45m 32s # Sessions Terminated by Timeout: 234 # Average Queries per Session: 127 # Session Pool Utilization: 62% </code></pre></div> <h4 id="session-alerts" class="position-relative d-flex align-items-center group"> Session Alerts <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-alerts" aria-haspopup="dialog" aria-label="Share link: Session Alerts"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-yaml" data-lang="yaml">monitoring: alerts: sessions: - name: "too_many_sessions" condition: "active_sessions > 5000" severity: "warning" - name: "session_timeout_spike" condition: "timeout_rate > 100/minute" severity: "critical" - name: "long_running_session" condition: "session_duration > 86400" severity: "info" </code></pre></div> <h3 id="best-practices" class="position-relative d-flex align-items-center group"> Best Practices <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="best-practices" aria-haspopup="dialog" aria-label="Share link: Best Practices"> Share link </button> </h3><ol> <li>Use Connection Pooling: Pool sessions at application layer for efficiency</li> <li>Set Appropriate Timeouts: Balance security with user experience</li> <li>Clean Up Sessions: Explicitly close sessions when done</li> <li>Use Session Variables Wisely: Store only necessary context, not large data</li> <li>Enable Persistence for Critical Applications: Prevent data loss on server restart</li> <li>Monitor Session Metrics: Track session usage patterns and anomalies</li> <li>Implement Graceful Degradation: Handle session timeout gracefully in application</li> <li>Secure Session Tokens: Never expose session tokens in logs or URLs</li> <li>Limit Concurrent Sessions: Prevent resource exhaustion from single user</li> <li>Regular Cleanup: Remove orphaned sessions periodically</li> </ol> <h3 id="troubleshooting" class="position-relative d-flex align-items-center group"> Troubleshooting <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"> Share link </button> </h3> <h4 id="session-timeout-issues" class="position-relative d-flex align-items-center group"> Session Timeout Issues <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="session-timeout-issues" aria-haspopup="dialog" aria-label="Share link: Session Timeout Issues"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># Check session timeout settings geode config show sessions.timeout # View sessions by age geode sessions list --sort-by=age --limit=10 # Identify frequent timeout users geode sessions analyze --metric=timeouts --group-by=user </code></pre></div> <h4 id="session-leaks" class="position-relative d-flex align-items-center group"> Session Leaks <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-leaks" aria-haspopup="dialog" aria-label="Share link: Session Leaks"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># Find long-running sessions geode sessions list --min-duration=24h # Find sessions with no recent activity geode sessions list --idle-longer-than=1h # Force cleanup geode sessions cleanup --force --dry-run geode sessions cleanup --force </code></pre></div> <h4 id="session-performance" class="position-relative d-flex align-items-center group"> Session Performance <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="session-performance" aria-haspopup="dialog" aria-label="Share link: Session Performance"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># Profile session overhead geode profile --component=sessions --duration=60s # Identify slow session operations geode sessions analyze --metric=query-latency </code></pre></div> <h3 id="related-topics" class="position-relative d-flex align-items-center group"> Related Topics <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="related-topics" aria-haspopup="dialog" aria-label="Share link: Related Topics"> Share link </button> </h3><ul> <li><a href="/tags/connections/" >Connections</a> - Connection management and pooling</li> <li><a href="/docs/security/authentication/" >Authentication</a> - User authentication and identity</li> <li><a href="/tags/transactions/" >Transactions</a> - Transaction management within sessions</li> <li><a href="/tags/configuration/" >Configuration</a> - Session configuration options</li> <li><a href="/tags/audit-logging/" >Audit Logging</a> - Session activity auditing</li> <li><a href="/docs/security/" >Security</a> - Session security best practices</li> <li><a href="/docs/operations/monitoring/" >Monitoring</a> - Monitoring session health</li> <li><a href="/docs/client-libraries/" >Client Libraries</a> - Language-specific session management</li> </ul>

Popular

Related Articles

Session Management Guide