Go Client | Geode Database

<h2 id="geode-go-client-library" class="position-relative d-flex align-items-center group"> Geode Go Client Library <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="geode-go-client-library" aria-haspopup="dialog" aria-label="Share link: Geode Go Client Library"> Share link </button> </h2><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 production-ready Go <code>database/sql</code> driver for the Geode graph database with dual transport support (QUIC default, gRPC optional) and Protobuf wire protocol. <h3 id="installation" class="position-relative d-flex align-items-center group"> Installation <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="installation" aria-haspopup="dialog" aria-label="Share link: Installation"> Share link </button> </h3><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash">go get geodedb.com/geode </code></pre></div> <h3 id="features" class="position-relative d-flex align-items-center group"> Features <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="features" aria-haspopup="dialog" aria-label="Share link: Features"> Share link </button> </h3><ul> <li>✅ Full <code>database/sql</code> driver - Standard Go database interface</li> <li>✅ Dual transport - QUIC (default) and gRPC</li> <li>✅ Protobuf wire protocol - Efficient binary messaging</li> <li>✅ TLS 1.3 security - QUIC always uses TLS</li> <li>✅ Connection pooling - Built into <code>database/sql</code></li> <li>✅ Prepared statements - Query parameter support</li> <li>✅ Transaction support - ACID transactions with savepoints</li> <li>✅ Context cancellation - Graceful query cancellation</li> <li>✅ Rich error types - ISO/IEC 39075 status codes</li> <li>✅ Unicode utilities - UTF-8/UTF-16 conversion helpers</li> </ul> <h3 id="quick-start" class="position-relative d-flex align-items-center group"> Quick Start <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="quick-start" aria-haspopup="dialog" aria-label="Share link: Quick Start"> Share link </button> </h3> <h4 id="basic-connection" class="position-relative d-flex align-items-center group"> Basic Connection <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="basic-connection" aria-haspopup="dialog" aria-label="Share link: Basic Connection"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-go" data-lang="go">package main import ( "context" "database/sql" "log" "time" _ "geodedb.com/geode" ) func main() { // Connect to Geode server (QUIC default) db, err := sql.Open("geode", "quic://localhost:3141?insecure_tls_skip_verify=true") if err != nil { log.Fatal(err) } defer db.Close() // Or connect via gRPC // db, err := sql.Open("geode", "grpc://localhost:50051?tls=0") // Configure connection pool db.SetMaxOpenConns(10) db.SetMaxIdleConns(5) db.SetConnMaxLifetime(5 * time.Minute) ctx, cancel := context.WithTimeout(context.Background(), 10*time.Second) defer cancel() // Execute a query rows, err := db.QueryContext(ctx, "MATCH (n:Person) RETURN n.name LIMIT 10") if err != nil { log.Fatal(err) } defer rows.Close() for rows.Next() { var name string if err := rows.Scan(&name); err != nil { log.Fatal(err) } log.Println(name) } if err := rows.Err(); err != nil { log.Fatal(err) } } </code></pre></div> <h3 id="dsn-format" class="position-relative d-flex align-items-center group"> DSN Format <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="dsn-format" aria-haspopup="dialog" aria-label="Share link: DSN Format"> Share link </button> </h3><blockquote> Note: See the official <a href="/docs/reference/dsn/" >DSN specification</a> for complete details. </blockquote> The Data Source Name (DSN) supports multiple formats: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-fallback" data-lang="fallback">quic://host:port?options # QUIC transport (recommended) grpc://host:port?options # gRPC transport host:port?options # Scheme-less defaults to QUIC host:port host </code></pre></div> <h4 id="dsn-examples" class="position-relative d-flex align-items-center group"> DSN Examples <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="dsn-examples" aria-haspopup="dialog" aria-label="Share link: DSN Examples"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-go" data-lang="go">// Development (skip TLS verification) db, _ := sql.Open("geode", "quic://localhost:3141?insecure_tls_skip_verify=true") // Production with CA certificate db, _ := sql.Open("geode", "quic://localhost:3141?ca=/path/to/ca.crt") // Mutual TLS (mTLS) db, _ := sql.Open("geode", "quic://localhost:3141?ca=/path/to/ca.crt&cert=/path/to/client.crt&key=/path/to/client.key") // Custom page size db, _ := sql.Open("geode", "quic://localhost:3141?page_size=5000") </code></pre></div> <h4 id="dsn-options" class="position-relative d-flex align-items-center group"> DSN Options <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="dsn-options" aria-haspopup="dialog" aria-label="Share link: DSN Options"> Share link </button> </h4><table> <thead> <tr> <th>Option</th> <th>Description</th> <th>Default</th> </tr> </thead> <tbody> <tr> <td><code>page_size</code></td> <td>Results page size</td> <td>1000</td> </tr> <tr> <td><code>hello_name</code></td> <td>Client name for HELLO</td> <td>geode-go</td> </tr> <tr> <td><code>hello_ver</code></td> <td>Client version for HELLO</td> <td>0.1</td> </tr> <tr> <td><code>conformance</code></td> <td>GQL conformance level</td> <td>min</td> </tr> <tr> <td><code>ca</code></td> <td>Path to CA certificate</td> <td></td> </tr> <tr> <td><code>cert</code></td> <td>Path to client certificate (mTLS)</td> <td></td> </tr> <tr> <td><code>key</code></td> <td>Path to client key (mTLS)</td> <td></td> </tr> <tr> <td><code>insecure_tls_skip_verify</code></td> <td>Skip TLS verification (testing only)</td> <td>false</td> </tr> <tr> <td><code>tls</code></td> <td>Enable/disable TLS (gRPC only)</td> <td>true</td> </tr> <tr> <td><code>user</code> / <code>username</code></td> <td>Authentication username</td> <td></td> </tr> <tr> <td><code>pass</code> / <code>password</code></td> <td>Authentication password</td> <td></td> </tr> </tbody> </table> <h4 id="environment-variables" class="position-relative d-flex align-items-center group"> Environment 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="environment-variables" aria-haspopup="dialog" aria-label="Share link: Environment Variables"> Share link </button> </h4><table> <thead> <tr> <th>Variable</th> <th>Description</th> </tr> </thead> <tbody> <tr> <td><code>GEODE_HOST</code></td> <td>Default host</td> </tr> <tr> <td><code>GEODE_PORT</code></td> <td>Default port</td> </tr> <tr> <td><code>GEODE_TLS_CA</code></td> <td>Default CA certificate path</td> </tr> <tr> <td><code>GEODE_TRANSPORT</code></td> <td>Default transport (<code>quic</code> or <code>grpc</code>)</td> </tr> <tr> <td><code>GEODE_USERNAME</code></td> <td>Default username</td> </tr> <tr> <td><code>GEODE_PASSWORD</code></td> <td>Default password</td> </tr> </tbody> </table> <h3 id="querying" class="position-relative d-flex align-items-center group"> Querying <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="querying" aria-haspopup="dialog" aria-label="Share link: Querying"> Share link </button> </h3> <h4 id="simple-queries" class="position-relative d-flex align-items-center group"> Simple Queries <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="simple-queries" aria-haspopup="dialog" aria-label="Share link: Simple Queries"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-go" data-lang="go">ctx := context.Background() // Execute query returning rows rows, err := db.QueryContext(ctx, "MATCH (n:Person) RETURN n.name, n.age") if err != nil { log.Fatal(err) } defer rows.Close() for rows.Next() { var name string var age int if err := rows.Scan(&name, &age); err != nil { log.Fatal(err) } fmt.Printf("%s is %d years old\n", name, age) } </code></pre></div> <h4 id="parameterized-queries" class="position-relative d-flex align-items-center group"> Parameterized Queries <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="parameterized-queries" aria-haspopup="dialog" aria-label="Share link: Parameterized Queries"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-go" data-lang="go">// Using ? placeholders rows, err := db.QueryContext(ctx, "MATCH (p:Person {name: ?}) RETURN p.age", "Alice") // Multiple parameters rows, err := db.QueryContext(ctx, "MATCH (p:Person) WHERE p.age > ? AND p.city = ? RETURN p", 30, "Seattle") </code></pre></div> <h4 id="executing-non-query-statements" class="position-relative d-flex align-items-center group"> Executing Non-Query Statements <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="executing-non-query-statements" aria-haspopup="dialog" aria-label="Share link: Executing Non-Query Statements"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-go" data-lang="go">// Create node result, err := db.ExecContext(ctx, "CREATE (p:Person {name: ?, age: ?})", "Bob", 25) if err != nil { log.Fatal(err) } rowsAffected, _ := result.RowsAffected() fmt.Printf("Created %d node(s)\n", rowsAffected) </code></pre></div> <h4 id="query-with-timeout" class="position-relative d-flex align-items-center group"> Query with 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="query-with-timeout" aria-haspopup="dialog" aria-label="Share link: Query with Timeout"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-go" data-lang="go">ctx, cancel := context.WithTimeout(context.Background(), 5*time.Second) defer cancel() rows, err := db.QueryContext(ctx, "MATCH (n) RETURN n LIMIT 1000000") if err != nil { if ctx.Err() == context.DeadlineExceeded { log.Println("Query timed out") } log.Fatal(err) } </code></pre></div> <h3 id="prepared-statements" class="position-relative d-flex align-items-center group"> Prepared Statements <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="prepared-statements" aria-haspopup="dialog" aria-label="Share link: Prepared Statements"> Share link </button> </h3>Prepared statements improve performance for frequently executed queries: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-go" data-lang="go">// Prepare statement stmt, err := db.PrepareContext(ctx, "MATCH (n:Person {name: ?}) RETURN n.age") if err != nil { log.Fatal(err) } defer stmt.Close() // Execute multiple times for _, name := range []string{"Alice", "Bob", "Charlie"} { var age int err := stmt.QueryRowContext(ctx, name).Scan(&age) if err != nil { log.Printf("No age found for %s\n", name) continue } fmt.Printf("%s is %d years old\n", name, age) } </code></pre></div> <h3 id="transactions" class="position-relative d-flex align-items-center group"> 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="transactions" aria-haspopup="dialog" aria-label="Share link: Transactions"> Share link </button> </h3> <h4 id="basic-transactions" class="position-relative d-flex align-items-center group"> Basic 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="basic-transactions" aria-haspopup="dialog" aria-label="Share link: Basic Transactions"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-go" data-lang="go">// Begin transaction tx, err := db.BeginTx(ctx, nil) if err != nil { log.Fatal(err) } // Execute operations _, err = tx.ExecContext(ctx, "CREATE (n:Person {name: 'Alice', age: 30})") if err != nil { tx.Rollback() log.Fatal(err) } _, err = tx.ExecContext(ctx, "CREATE (n:Person {name: 'Bob', age: 25})") if err != nil { tx.Rollback() log.Fatal(err) } // Commit transaction if err := tx.Commit(); err != nil { log.Fatal(err) } </code></pre></div> <h4 id="transaction-isolation-levels" class="position-relative d-flex align-items-center group"> Transaction Isolation Levels <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="transaction-isolation-levels" aria-haspopup="dialog" aria-label="Share link: Transaction Isolation Levels"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-go" data-lang="go">import "database/sql" // Serializable isolation tx, err := db.BeginTx(ctx, &sql.TxOptions{ Isolation: sql.LevelSerializable, ReadOnly: false, }) // Read-only transaction tx, err := db.BeginTx(ctx, &sql.TxOptions{ ReadOnly: true, }) </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-go" data-lang="go">tx, _ := db.BeginTx(ctx, nil) // Create initial data tx.ExecContext(ctx, "CREATE (n:Person {name: 'Alice', age: 30})") // Create savepoint _, err := tx.ExecContext(ctx, "SAVEPOINT before_update") // Make changes tx.ExecContext(ctx, "MATCH (n:Person {name: 'Alice'}) SET n.age = 40") // Rollback to savepoint _, err = tx.ExecContext(ctx, "ROLLBACK TO before_update") // Alice's age is still 30 tx.Commit() </code></pre></div> <h3 id="error-handling" class="position-relative d-flex align-items-center group"> Error Handling <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="error-handling" aria-haspopup="dialog" aria-label="Share link: Error Handling"> Share link </button> </h3>The driver provides rich error types with diagnostic information: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-go" data-lang="go">import ( "errors" "geodedb.com/geode" ) rows, err := db.QueryContext(ctx, "INVALID QUERY") if err != nil { var derr *geode.DriverError if errors.As(err, &derr) { log.Printf("Code: %s", derr.Code) log.Printf("Message: %s", derr.Message) log.Printf("Diagnostic: %s", derr.Diagnostic) if derr.IsRetryable() { log.Println("Error is retryable") } } } </code></pre></div> <h4 id="error-types" class="position-relative d-flex align-items-center group"> Error Types <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="error-types" aria-haspopup="dialog" aria-label="Share link: Error Types"> Share link </button> </h4><ul> <li>DriverError - Server errors with ISO/IEC 39075 status codes</li> <li>TransportError - Network/QUIC failures</li> <li>ConfigError - DSN parsing errors</li> <li>SecurityError - TLS/validation failures</li> <li>StateError - Invalid connection state transitions</li> </ul> <h4 id="common-error-codes" class="position-relative d-flex align-items-center group"> Common Error Codes <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="common-error-codes" aria-haspopup="dialog" aria-label="Share link: Common Error Codes"> Share link </button> </h4><table> <thead> <tr> <th>Code</th> <th>Description</th> </tr> </thead> <tbody> <tr> <td><code>00000</code></td> <td>Success</td> </tr> <tr> <td><code>42000</code></td> <td>Syntax error</td> </tr> <tr> <td><code>42001</code></td> <td>Undefined object</td> </tr> <tr> <td><code>42002</code></td> <td>Duplicate object</td> </tr> <tr> <td><code>22000</code></td> <td>Data exception</td> </tr> <tr> <td><code>23000</code></td> <td>Integrity constraint violation</td> </tr> </tbody> </table> <h3 id="connection-pooling" class="position-relative d-flex align-items-center group"> Connection Pooling <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="connection-pooling" aria-haspopup="dialog" aria-label="Share link: Connection Pooling"> Share link </button> </h3>Configure the connection pool for optimal performance: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-go" data-lang="go">// Maximum open connections db.SetMaxOpenConns(100) // Maximum idle connections db.SetMaxIdleConns(25) // Maximum connection lifetime db.SetConnMaxLifetime(5 * time.Minute) // Maximum idle time db.SetConnMaxIdleTime(1 * time.Minute) </code></pre></div>Guidelines: <ul> <li>Read-heavy: Higher <code>MaxOpenConns</code> (100-200)</li> <li>Write-heavy: Lower <code>MaxOpenConns</code> (10-50)</li> <li>Mixed: Medium <code>MaxOpenConns</code> (50-100)</li> </ul> <h3 id="unicode-utilities" class="position-relative d-flex align-items-center group"> Unicode Utilities <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="unicode-utilities" aria-haspopup="dialog" aria-label="Share link: Unicode Utilities"> Share link </button> </h3>Helper functions for Unicode conversion: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-go" data-lang="go">import "geodedb.com/geode" // UTF-8 to UTF-16 utf16 := geode.Utf8ToUtf16("Hello 🌍") // UTF-16 to UTF-8 utf8 := geode.Utf16ToUtf8(utf16) // WTF-8 lossy decode (replaces invalid sequences with U+FFFD) safe := geode.Wtf8Lossy([]byte{0x61, 0x80, 0x62}) </code></pre></div> <h3 id="testing" class="position-relative d-flex align-items-center group"> Testing <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="testing" aria-haspopup="dialog" aria-label="Share link: Testing"> Share link </button> </h3> <h4 id="unit-tests-no-server-required" class="position-relative d-flex align-items-center group"> Unit Tests (No Server Required) <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="unit-tests-no-server-required" aria-haspopup="dialog" aria-label="Share link: Unit Tests (No Server Required)"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash">go test -v -short ./... </code></pre></div> <h4 id="integration-tests-with-docker" class="position-relative d-flex align-items-center group"> Integration Tests with Docker <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="integration-tests-with-docker" aria-haspopup="dialog" aria-label="Share link: Integration Tests with Docker"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># Automatic Docker integration tests go test -v -tags=integration ./... # With custom Geode image GEODE_IMAGE="myregistry/geode:tag" go test -v -tags=integration ./... </code></pre></div> <h4 id="integration-tests-with-manual-server" class="position-relative d-flex align-items-center group"> Integration Tests with Manual Server <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="integration-tests-with-manual-server" aria-haspopup="dialog" aria-label="Share link: Integration Tests with Manual Server"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># Start Geode server ./geode serve --listen 0.0.0.0:3141 # Run tests GEODE_TEST_DSN="localhost:3141?insecure_tls_skip_verify=true" go test -v ./... </code></pre></div> <h4 id="benchmarks" class="position-relative d-flex align-items-center group"> Benchmarks <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="benchmarks" aria-haspopup="dialog" aria-label="Share link: Benchmarks"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># Unit benchmarks (no server required) go test -bench=. -benchmem ./... # Docker-based benchmarks go test -tags=integration -bench=BenchmarkDocker -benchmem ./... </code></pre></div> <h4 id="fuzzing" class="position-relative d-flex align-items-center group"> Fuzzing <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="fuzzing" aria-haspopup="dialog" aria-label="Share link: Fuzzing"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># Fuzz DSN parsing go test -fuzz=FuzzParseDSN -fuzztime=30s # Fuzz protocol frame parsing go test -fuzz=FuzzParseFrame -fuzztime=30s </code></pre></div> <h3 id="examples" class="position-relative d-flex align-items-center group"> Examples <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="examples" aria-haspopup="dialog" aria-label="Share link: Examples"> Share link </button> </h3> <h4 id="social-network-query" class="position-relative d-flex align-items-center group"> Social Network Query <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="social-network-query" aria-haspopup="dialog" aria-label="Share link: Social Network Query"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-go" data-lang="go">rows, err := db.QueryContext(ctx, ` MATCH (person:Person {name: ?})-[:KNOWS*1..2]->(friend:Person) WHERE friend <> person RETURN DISTINCT friend.name AS name, friend.age AS age ORDER BY friend.age DESC LIMIT 10 `, "Alice") for rows.Next() { var name string var age int rows.Scan(&name, &age) fmt.Printf("%s (age %d)\n", name, age) } </code></pre></div> <h4 id="aggregation-query" class="position-relative d-flex align-items-center group"> Aggregation Query <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="aggregation-query" aria-haspopup="dialog" aria-label="Share link: Aggregation Query"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-go" data-lang="go">rows, err := db.QueryContext(ctx, ` MATCH (p:Person) RETURN p.city AS city, count(*) AS population GROUP BY p.city ORDER BY population DESC LIMIT 5 `) for rows.Next() { var city string var population int rows.Scan(&city, &population) fmt.Printf("%s: %d people\n", city, population) } </code></pre></div> <h4 id="batch-insert" class="position-relative d-flex align-items-center group"> Batch Insert <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-insert" aria-haspopup="dialog" aria-label="Share link: Batch Insert"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-go" data-lang="go">tx, _ := db.BeginTx(ctx, nil) stmt, _ := tx.PrepareContext(ctx, "CREATE (p:Person {name: ?, age: ?})") defer stmt.Close() people := []struct{ name string; age int }{ {"Alice", 30}, {"Bob", 25}, {"Charlie", 35}, } for _, p := range people { _, err := stmt.ExecContext(ctx, p.name, p.age) if err != nil { tx.Rollback() log.Fatal(err) } } tx.Commit() </code></pre></div> <h3 id="performance-tips" class="position-relative d-flex align-items-center group"> Performance Tips <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"> Share link </button> </h3><ol> <li>Use connection pooling with appropriate limits</li> <li>Reuse prepared statements for repeated queries</li> <li>Batch operations in transactions</li> <li>Use context timeouts to prevent hanging queries</li> <li>Close rows/statements to prevent resource leaks</li> <li>Monitor pool metrics with <code>db.Stats()</code></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="connection-refused" class="position-relative d-flex align-items-center group"> Connection Refused <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="connection-refused" aria-haspopup="dialog" aria-label="Share link: Connection Refused"> Share link </button> </h4>Ensure Geode server is running: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash">./geode serve --listen 0.0.0.0:3141 </code></pre></div> <h4 id="tls-verification-errors" class="position-relative d-flex align-items-center group"> TLS Verification Errors <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="tls-verification-errors" aria-haspopup="dialog" aria-label="Share link: TLS Verification Errors"> Share link </button> </h4>For development, skip verification: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-go" data-lang="go">db, _ := sql.Open("geode", "localhost:3141?insecure_tls_skip_verify=true") </code></pre></div>For production, provide CA certificate: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-go" data-lang="go">db, _ := sql.Open("geode", "localhost:3141?ca=/path/to/ca.crt") </code></pre></div> <h4 id="connection-pool-exhaustion" class="position-relative d-flex align-items-center group"> Connection Pool Exhaustion <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="connection-pool-exhaustion" aria-haspopup="dialog" aria-label="Share link: Connection Pool Exhaustion"> Share link </button> </h4>Monitor pool stats: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-go" data-lang="go">stats := db.Stats() fmt.Printf("Open: %d, Idle: %d, InUse: %d\n", stats.OpenConnections, stats.Idle, stats.InUse) </code></pre></div>Increase pool size if needed: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-go" data-lang="go">db.SetMaxOpenConns(200) </code></pre></div> <h3 id="next-steps" class="position-relative d-flex align-items-center group"> Next Steps <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"> Share link </button> </h3><ul> <li><a href="/docs/gql-reference/" >GQL Reference</a> - Query language guide</li> <li><a href="/docs/transactions/advanced-patterns/" >Transaction Patterns</a> - Advanced transaction features</li> <li><a href="/docs/reference/error-codes/" >Error Codes</a> - Complete error reference</li> <li><a href="/docs/query/performance-tuning/" >Performance Tuning</a> - Optimize performance</li> </ul>