Schema Constraints

<h2 id="schema-constraints" class="position-relative d-flex align-items-center group"> Schema Constraints <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="schema-constraints" aria-haspopup="dialog" aria-label="Share link: Schema Constraints"> 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>Schema constraints are declarative rules that enforce data integrity and consistency in your Geode graph database. By defining constraints at the schema level, you ensure that invalid data never enters the system, maintaining high quality across all nodes, edges, and properties. Geode implements constraints according to the ISO/IEC 39075:2024 GQL standard while optimizing enforcement at the graph storage layer. <h3 id="understanding-constraints-in-graph-context" class="position-relative d-flex align-items-center group"> Understanding Constraints in Graph Context <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="understanding-constraints-in-graph-context" aria-haspopup="dialog" aria-label="Share link: Understanding Constraints in Graph Context"> Share link </button> </h3>Unlike relational databases where constraints apply to tables and columns, Geode enforces constraints on node types, edge types, and their properties. This graph-native approach ensures that your property graph maintains structural and semantic integrity while preserving the flexibility that makes graph databases powerful. Constraints in Geode serve multiple purposes: <ul> <li>Data Integrity: Prevent invalid data from entering the system</li> <li>Business Logic: Encode domain rules directly in the schema</li> <li>Performance: Enable query optimizer to make assumptions about data</li> <li>Documentation: Schema constraints self-document data requirements</li> <li>Client Safety: Provide early error detection before complex transactions</li> </ul> <h3 id="core-constraint-types" class="position-relative d-flex align-items-center group"> Core Constraint 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="core-constraint-types" aria-haspopup="dialog" aria-label="Share link: Core Constraint Types"> Share link </button> </h3> <h4 id="not-null-constraints" class="position-relative d-flex align-items-center group"> NOT NULL Constraints <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="not-null-constraints" aria-haspopup="dialog" aria-label="Share link: NOT NULL Constraints"> Share link </button> </h4>NOT NULL constraints ensure that required properties always have values, preventing incomplete data from degrading graph quality. In graph databases, missing property values can break traversal logic and analytical queries. <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Define required properties for Person nodes CREATE NODE TYPE Person ( id STRING NOT NULL, name STRING NOT NULL, email STRING NOT NULL, phone STRING, -- Optional field, nullable by default middle_name STRING, -- Explicitly nullable created_at TIMESTAMP NOT NULL DEFAULT NOW() ); -- Edge type with required relationship metadata CREATE EDGE TYPE WORKS_FOR ( start_date DATE NOT NULL, end_date DATE, -- NULL means current employment position STRING NOT NULL, department STRING NOT NULL ); </code></pre></div>When inserting nodes without required values, Geode immediately rejects the operation: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python"># Python client - constraint violation from geode_client import Client, ConstraintViolationError client = Client(host="localhost", port=3141) async with client.connection() as conn: try: # Missing required 'name' field await conn.execute( "INSERT (p:Person {email: $email})", {"email": "[email protected]"} ) except ConstraintViolationError as e: print(f"Missing required field: {e.field}") # Output: Missing required field: name </code></pre></div> <h4 id="unique-constraints" class="position-relative d-flex align-items-center group"> UNIQUE Constraints <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="unique-constraints" aria-haspopup="dialog" aria-label="Share link: UNIQUE Constraints"> Share link </button> </h4>UNIQUE constraints prevent duplicate values across nodes or edges of the same type. Geode automatically creates indexes for UNIQUE columns to provide O(1) duplicate checking and fast lookups. <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Single-column uniqueness CREATE NODE TYPE Person ( id STRING PRIMARY KEY, -- Implicitly UNIQUE and NOT NULL email STRING UNIQUE NOT NULL, -- Business key uniqueness ssn STRING UNIQUE, -- Nullable but unique when present username STRING UNIQUE NOT NULL ); -- Multi-column uniqueness (composite keys) CREATE NODE TYPE Employee ( employee_id STRING NOT NULL, department STRING NOT NULL, badge_number STRING NOT NULL, CONSTRAINT unique_dept_badge UNIQUE (department, badge_number) ); -- Edge uniqueness prevents duplicate relationships CREATE EDGE TYPE FOLLOWS ( followed_at TIMESTAMP NOT NULL DEFAULT NOW(), CONSTRAINT unique_follow UNIQUE (FROM, TO) ); </code></pre></div>Application-level usage: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-go" data-lang="go">// Go client - checking uniqueness before insert package main import ( "context" "fmt" "geodedb.com/geode" ) func createUser(ctx context.Context, db *geode.DB, email string) error { // UNIQUE constraint enforced automatically _, err := db.ExecContext(ctx, "INSERT (u:Person {email: $1, name: $2})", email, "Alice Smith") if geode.IsConstraintViolation(err) { return fmt.Errorf("email already exists: %s", email) } return err } </code></pre></div> <h4 id="check-constraints" class="position-relative d-flex align-items-center group"> CHECK Constraints <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="check-constraints" aria-haspopup="dialog" aria-label="Share link: CHECK Constraints"> Share link </button> </h4>CHECK constraints enforce business rules using boolean expressions. These constraints validate property values against complex conditions, encoding domain logic directly in the schema. <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Simple range checks CREATE NODE TYPE Person ( age INTEGER CHECK (age >= 0 AND age <= 150), salary DECIMAL CHECK (salary >= 0), email STRING CHECK (email LIKE '%@%.%') ); -- Pattern validation CREATE NODE TYPE Product ( sku STRING CHECK (sku ~ '^[A-Z]{3}-[0-9]{6}$'), -- Format: ABC-123456 price DECIMAL CHECK (price > 0), discount_pct DECIMAL CHECK (discount_pct >= 0 AND discount_pct <= 100) ); -- Enumeration constraints CREATE NODE TYPE Order ( status STRING CHECK (status IN ('pending', 'processing', 'shipped', 'delivered', 'cancelled')), priority STRING CHECK (priority IN ('low', 'normal', 'high', 'urgent')) ); -- Multi-property constraints CREATE NODE TYPE Booking ( check_in DATE NOT NULL, check_out DATE NOT NULL, guests INTEGER CHECK (guests > 0 AND guests <= 10), CONSTRAINT valid_date_range CHECK (check_out > check_in), CONSTRAINT min_stay CHECK (check_out >= check_in + INTERVAL '1 day') ); -- Conditional constraints based on other properties CREATE NODE TYPE Employee ( type STRING CHECK (type IN ('full_time', 'part_time', 'contractor')), salary DECIMAL, hourly_rate DECIMAL, benefits_eligible BOOLEAN, CONSTRAINT compensation_model CHECK ( (type = 'full_time' AND salary IS NOT NULL AND hourly_rate IS NULL) OR (type IN ('part_time', 'contractor') AND salary IS NULL AND hourly_rate IS NOT NULL) ), CONSTRAINT benefits_rule CHECK ( type = 'full_time' OR benefits_eligible = false ) ); </code></pre></div>Geode evaluates CHECK constraints on every INSERT and UPDATE operation, providing immediate feedback: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-rust" data-lang="rust">// Rust client - handling CHECK constraint violations use geode_client::{Client, Error, ErrorKind}; async fn create_product(client: &Client, sku: &str, price: f64) -> Result<(), Error> { let result = client.execute( "INSERT (p:Product {sku: $sku, price: $price})", &[("sku", sku), ("price", &price)] ).await; match result { Err(Error { kind: ErrorKind::ConstraintViolation, .. }) => { eprintln!("Invalid product data: SKU format or price constraint failed"); Err(Error::validation_failed("Product validation failed")) } other => other } } </code></pre></div> <h4 id="foreign-key-constraints-referential-integrity" class="position-relative d-flex align-items-center group"> FOREIGN KEY Constraints (Referential Integrity) <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="foreign-key-constraints-referential-integrity" aria-haspopup="dialog" aria-label="Share link: FOREIGN KEY Constraints (Referential Integrity)"> Share link </button> </h4>Foreign key constraints ensure that relationships reference existing nodes, maintaining referential integrity across the graph. Geode enforces these constraints by validating that referenced nodes exist before creating edges. <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Edge type with foreign key constraints CREATE EDGE TYPE WORKS_FOR ( employee_id STRING REFERENCES Person(id), company_id STRING REFERENCES Company(id), start_date DATE NOT NULL ); -- Cascade options for deletions CREATE EDGE TYPE MANAGES ( manager_id STRING REFERENCES Employee(id) ON DELETE CASCADE, team_id STRING REFERENCES Team(id) ON DELETE SET NULL ); -- Self-referential constraints CREATE EDGE TYPE REPORTS_TO ( from_id STRING REFERENCES Employee(id), to_id STRING REFERENCES Employee(id), CONSTRAINT no_self_reporting CHECK (from_id != to_id) ); </code></pre></div> <h3 id="complex-constraint-patterns" class="position-relative d-flex align-items-center group"> Complex Constraint Patterns <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="complex-constraint-patterns" aria-haspopup="dialog" aria-label="Share link: Complex Constraint Patterns"> Share link </button> </h3> <h4 id="cross-property-validation" class="position-relative d-flex align-items-center group"> Cross-Property Validation <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="cross-property-validation" aria-haspopup="dialog" aria-label="Share link: Cross-Property Validation"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Price consistency across currencies CREATE NODE TYPE Product ( base_price_usd DECIMAL NOT NULL CHECK (base_price_usd > 0), price_eur DECIMAL, price_gbp DECIMAL, CONSTRAINT currency_consistency CHECK ( (price_eur IS NULL AND price_gbp IS NULL) OR (price_eur > 0 AND price_gbp > 0) ) ); -- Temporal validity CREATE NODE TYPE Contract ( signed_date DATE NOT NULL, effective_date DATE NOT NULL, expiry_date DATE, CONSTRAINT chronological_order CHECK ( effective_date >= signed_date AND (expiry_date IS NULL OR expiry_date > effective_date) ) ); </code></pre></div> <h4 id="graph-specific-constraints" class="position-relative d-flex align-items-center group"> Graph-Specific Constraints <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="graph-specific-constraints" aria-haspopup="dialog" aria-label="Share link: Graph-Specific Constraints"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Degree constraints on relationships CREATE NODE TYPE Person ( max_connections INTEGER DEFAULT 5000, CONSTRAINT connection_limit CHECK ( (SELECT COUNT(*) FROM MATCH (this)-[:FOLLOWS]->() ) <= max_connections ) ); -- Path length constraints CREATE EDGE TYPE REFERENCES ( depth INTEGER CHECK (depth >= 0 AND depth < 10), CONSTRAINT no_cycles CHECK ( NOT EXISTS( MATCH (a)-[:REFERENCES*1..10]->(b)-[:REFERENCES]->(a) WHERE a = FROM_NODE ) ) ); </code></pre></div> <h3 id="managing-constraints-dynamically" class="position-relative d-flex align-items-center group"> Managing Constraints Dynamically <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="managing-constraints-dynamically" aria-haspopup="dialog" aria-label="Share link: Managing Constraints Dynamically"> Share link </button> </h3> <h4 id="adding-constraints-to-existing-types" class="position-relative d-flex align-items-center group"> Adding Constraints to Existing 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="adding-constraints-to-existing-types" aria-haspopup="dialog" aria-label="Share link: Adding Constraints to Existing Types"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Add new constraint to existing node type ALTER NODE TYPE Person ADD CONSTRAINT check_adult CHECK (age >= 18); -- Add uniqueness constraint ALTER NODE TYPE Person ADD CONSTRAINT unique_phone UNIQUE (phone); -- Add multi-column constraint ALTER NODE TYPE Employee ADD CONSTRAINT unique_dept_position UNIQUE (department, position_id); </code></pre></div> <h4 id="modifying-constraints" class="position-relative d-flex align-items-center group"> Modifying Constraints <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="modifying-constraints" aria-haspopup="dialog" aria-label="Share link: Modifying Constraints"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Remove outdated constraint ALTER NODE TYPE Person DROP CONSTRAINT check_adult; -- Replace constraint with updated rule ALTER NODE TYPE Person DROP CONSTRAINT email_format; ALTER NODE TYPE Person ADD CONSTRAINT email_format_v2 CHECK ( email ~ '^[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\.[a-zA-Z]{2,}$' ); </code></pre></div> <h4 id="bulk-operations-with-constraint-suspension" class="position-relative d-flex align-items-center group"> Bulk Operations with Constraint Suspension <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="bulk-operations-with-constraint-suspension" aria-haspopup="dialog" aria-label="Share link: Bulk Operations with Constraint Suspension"> Share link </button> </h4>For large data migrations, temporarily disable constraints: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python"># Python - bulk load with constraint management async def bulk_migrate_users(client, user_data): async with client.connection() as tx: await tx.begin() # Disable constraints for bulk operation await tx.execute("ALTER NODE TYPE Person DISABLE CONSTRAINTS") try: # Bulk insert for batch in chunked(user_data, 1000): await tx.execute(""" UNWIND $batch AS row CREATE (p:Person { id: row.id, email: row.email, age: row.age }) """, {"batch": batch}) # Re-enable and validate await tx.execute("ALTER NODE TYPE Person ENABLE CONSTRAINTS") # Check for violations violations, _ = await tx.query(""" MATCH (p:Person) WHERE p.age < 0 OR p.age > 150 OR p.email NOT LIKE '%@%.%' RETURN p.id, p.email, p.age """) if violations.rows: raise ValueError(f"Found {len(violations)} constraint violations") await tx.commit() except Exception: await tx.rollback() raise </code></pre></div> <h3 id="constraint-violation-handling" class="position-relative d-flex align-items-center group"> Constraint Violation 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="constraint-violation-handling" aria-haspopup="dialog" aria-label="Share link: Constraint Violation Handling"> Share link </button> </h3> <h4 id="error-responses" class="position-relative d-flex align-items-center group"> Error Responses <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-responses" aria-haspopup="dialog" aria-label="Share link: Error Responses"> Share link </button> </h4>Geode provides detailed error information when constraints fail: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-json" data-lang="json">{ "type": "ERROR", "code": "22001", "message": "CHECK constraint violation", "constraint": "check_adult", "field": "age", "value": 15, "query": "INSERT (p:Person {name: 'Bob', age: 15})" } </code></pre></div> <h4 id="client-side-error-handling" class="position-relative d-flex align-items-center group"> Client-Side 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="client-side-error-handling" aria-haspopup="dialog" aria-label="Share link: Client-Side Error Handling"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-go" data-lang="go">// Go - comprehensive constraint error handling type ConstraintError struct { Constraint string Field string Value interface{} Message string } func (e *ConstraintError) Error() string { return fmt.Sprintf("constraint %s violated on field %s: %s", e.Constraint, e.Field, e.Message) } func parseConstraintError(err error) *ConstraintError { if dbErr, ok := err.(*geode.Error); ok && dbErr.Code == "22001" { return &ConstraintError{ Constraint: dbErr.Constraint, Field: dbErr.Field, Value: dbErr.Value, Message: dbErr.Message, } } return nil } </code></pre></div> <h3 id="performance-considerations" class="position-relative d-flex align-items-center group"> Performance Considerations <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-considerations" aria-haspopup="dialog" aria-label="Share link: Performance Considerations"> Share link </button> </h3>Constraints impact write performance but improve overall system reliability: <ul> <li>NOT NULL: Minimal overhead, checked in memory</li> <li>UNIQUE: O(log n) index lookup per insert</li> <li>CHECK: Expression evaluation overhead, typically microseconds</li> <li>FOREIGN KEY: Node existence check, index lookup</li> </ul> To optimize constraint checking: <ol> <li>Index UNIQUE Columns: Geode auto-indexes, but verify with EXPLAIN</li> <li>Simple CHECK Expressions: Avoid subqueries in CHECK constraints</li> <li>Batch Operations: Use transactions to amortize constraint checking</li> <li>Deferred Constraints: Validate at transaction commit for complex rules</li> </ol> <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>Define Constraints Early: Add constraints during schema design, not as afterthoughts</li> <li>Document Business Rules: Use meaningful constraint names that explain the rule</li> <li>Test Constraint Violations: Write tests that verify constraints properly reject invalid data</li> <li>Prefer Schema Constraints: Choose schema-level constraints over application validation when possible</li> <li>Use Appropriate Types: Match constraint type to data requirement (NOT NULL vs DEFAULT)</li> <li>Version Constraints: Track constraint changes in migration scripts</li> <li>Monitor Violations: Log constraint failures to detect data quality issues</li> <li>Balance Strictness: Too many constraints can hinder legitimate operations</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>Constraint preventing legitimate inserts: Review CHECK expressions for edge cases Performance degradation on writes: Analyze constraint evaluation with EXPLAIN PROFILE Cascade failures on deletes: Review ON DELETE policies for foreign keys Bulk load failures: Consider temporarily disabling constraints for validated migration <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/validation" >Validation</a> - Application-level data validation patterns</li> <li><a href="/tags/data-quality" >Data Quality</a> - Comprehensive data quality management</li> <li><a href="/tags/nullable" >Nullable</a> - NULL handling and optional fields</li> <li><a href="/tags/defaults" >Defaults</a> - Default property values</li> <li><a href="/tags/indexes" >Indexes</a> - Index management for constraint enforcement</li> <li><a href="/tags/transactions" >Transactions</a> - Constraint checking in transactional context</li> </ul>

Popular

Related Articles

Constraints and Indexes Guide