Social Network Analysis | Geode Database

<h2 id="social-network-analysis" class="position-relative d-flex align-items-center group"> Social Network Analysis <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-analysis" aria-haspopup="dialog" aria-label="Share link: Social Network Analysis"> 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>Build scalable social networks with Geode for community detection, influence analysis, and real-time engagement tracking. <h3 id="overview" class="position-relative d-flex align-items-center group"> Overview <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="overview" aria-haspopup="dialog" aria-label="Share link: Overview"> Share link </button> </h3>Social networks model connections between people, organizations, and content. Geode’s graph database provides natural support for social network analysis with efficient traversals, pattern matching, and real-time analytics. <h4 id="key-capabilities" class="position-relative d-flex align-items-center group"> Key Capabilities <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="key-capabilities" aria-haspopup="dialog" aria-label="Share link: Key Capabilities"> Share link </button> </h4><ul> <li>Community Detection: Discover natural groupings and clusters</li> <li>Influence Analysis: Identify thought leaders and key influencers</li> <li>Viral Content Tracking: Monitor content spread through network</li> <li>Friend Recommendations: Suggest connections based on mutual friends</li> <li>Engagement Metrics: Track likes, shares, comments in real-time</li> <li>Path Analysis: Find degrees of separation, shortest paths</li> </ul> <h3 id="use-case-scenarios" class="position-relative d-flex align-items-center group"> Use Case Scenarios <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="use-case-scenarios" aria-haspopup="dialog" aria-label="Share link: Use Case Scenarios"> Share link </button> </h3> <h4 id="1-professional-networking-platform" class="position-relative d-flex align-items-center group"> 1. Professional Networking Platform <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="1-professional-networking-platform" aria-haspopup="dialog" aria-label="Share link: 1. Professional Networking Platform"> Share link </button> </h4>Challenge: Connect professionals based on skills, interests, and connections Solution: Build professional graph with: <ul> <li>User profiles and skills</li> <li>Connection types (colleague, mentor, classmate)</li> <li>Companies and positions</li> <li>Endorsements and recommendations</li> </ul> Benefits: <ul> <li>Smart connection suggestions</li> <li>Skill-based search</li> <li>Career path discovery</li> <li>Networking event recommendations</li> </ul> <h4 id="2-content-distribution-network" class="position-relative d-flex align-items-center group"> 2. Content Distribution Network <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="2-content-distribution-network" aria-haspopup="dialog" aria-label="Share link: 2. Content Distribution Network"> Share link </button> </h4>Challenge: Track how content spreads through network Solution: Model content propagation: <ul> <li>Posts and shares</li> <li>Engagement (likes, comments, reactions)</li> <li>Viral coefficient tracking</li> <li>Influence chains</li> </ul> Benefits: <ul> <li>Identify viral content early</li> <li>Detect trending topics</li> <li>Target influential users</li> <li>Optimize content strategy</li> </ul> <h4 id="3-gaming-and-social-platforms" class="position-relative d-flex align-items-center group"> 3. Gaming and Social Platforms <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="3-gaming-and-social-platforms" aria-haspopup="dialog" aria-label="Share link: 3. Gaming and Social Platforms"> Share link </button> </h4>Challenge: Build engaging social features for multiplayer games Solution: Create social gaming graph: <ul> <li>Players and friendships</li> <li>Teams and guilds</li> <li>Achievements and leaderboards</li> <li>In-game transactions</li> </ul> Benefits: <ul> <li>Friend invites and referrals</li> <li>Team formation recommendations</li> <li>Social competitions</li> <li>Viral game mechanics</li> </ul> <h3 id="data-model" class="position-relative d-flex align-items-center group"> Data Model <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="data-model" aria-haspopup="dialog" aria-label="Share link: Data Model"> Share link </button> </h3> <h4 id="user-profiles" class="position-relative d-flex align-items-center group"> User Profiles <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="user-profiles" aria-haspopup="dialog" aria-label="Share link: User Profiles"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">CREATE GRAPH SocialNetwork; USE SocialNetwork; -- User nodes CREATE (:User { id: 'u1', username: 'alice_dev', name: 'Alice Johnson', bio: 'Software engineer passionate about graphs', location: 'San Francisco, CA', joined: date('2022-01-15'), verified: true }), (:User { id: 'u2', username: 'bob_data', name: 'Bob Smith', bio: 'Data scientist | ML enthusiast', location: 'Seattle, WA', joined: date('2021-06-20'), verified: false }); </code></pre></div> <h4 id="relationships-and-interactions" class="position-relative d-flex align-items-center group"> Relationships and Interactions <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="relationships-and-interactions" aria-haspopup="dialog" aria-label="Share link: Relationships and Interactions"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Friendship (bidirectional) MATCH (alice:User {id: 'u1'}), (bob:User {id: 'u2'}) CREATE (alice)-[:FOLLOWS {since: timestamp()}]->(bob); -- Close friends (stronger connection) MATCH (alice:User {id: 'u1'}), (carol:User {id: 'u3'}) CREATE (alice)-[:CLOSE_FRIEND { since: timestamp(), interaction_score: 0.95 }]->(carol); -- Professional connections MATCH (alice:User {id: 'u1'}), (david:User {id: 'u4'}) CREATE (alice)-[:COLLEAGUE { company: 'TechCorp', start_date: date('2022-03-01'), department: 'Engineering' }]->(david); </code></pre></div> <h4 id="content-and-engagement" class="position-relative d-flex align-items-center group"> Content and Engagement <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="content-and-engagement" aria-haspopup="dialog" aria-label="Share link: Content and Engagement"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Posts CREATE (:Post { id: 'p1', content: 'Just launched my first graph database app!', timestamp: timestamp(), type: 'text', visibility: 'public' }), (:Post { id: 'p2', content: 'Check out this amazing graph visualization', timestamp: timestamp(), media_url: 'https://example.com/viz.png', type: 'image' }); -- Authorship MATCH (alice:User {id: 'u1'}), (post:Post {id: 'p1'}) CREATE (alice)-[:POSTED {timestamp: timestamp()}]->(post); -- Engagement MATCH (bob:User {id: 'u2'}), (post:Post {id: 'p1'}) CREATE (bob)-[:LIKED {timestamp: timestamp()}]->(post); MATCH (carol:User {id: 'u3'}), (post:Post {id: 'p1'}) CREATE (carol)-[:SHARED { timestamp: timestamp(), comment: 'This is awesome!' }]->(post); </code></pre></div> <h3 id="implementation-guide" class="position-relative d-flex align-items-center group"> Implementation Guide <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="implementation-guide" aria-haspopup="dialog" aria-label="Share link: Implementation Guide"> Share link </button> </h3> <h4 id="step-1-friend-recommendations" class="position-relative d-flex align-items-center group"> Step 1: Friend Recommendations <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="step-1-friend-recommendations" aria-haspopup="dialog" aria-label="Share link: Step 1: Friend Recommendations"> Share link </button> </h4> <h5 id="mutual-friends-algorithm" class="position-relative d-flex align-items-center group"> Mutual Friends Algorithm <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="mutual-friends-algorithm" aria-haspopup="dialog" aria-label="Share link: Mutual Friends Algorithm"> Share link </button> </h5><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Find users with mutual friends MATCH (me:User {id: 'u1'})-[:FOLLOWS]->(mutual:User)<-[:FOLLOWS]-(candidate:User) WHERE NOT EXISTS((me)-[:FOLLOWS]->(candidate)) AND candidate <> me WITH candidate, count(DISTINCT mutual) AS mutual_count, collect(DISTINCT mutual.username) AS mutual_friends RETURN candidate.id, candidate.username, candidate.name, mutual_count, mutual_friends ORDER BY mutual_count DESC LIMIT 10; </code></pre></div><div class="docs-tabs mb-4"> <ul class="nav nav-tabs" id="tabs-1774880892480901679" role="tablist"><li class="nav-item" role="presentation"> <button class="nav-link active" id="tabs-1774880892480901679-tab-0-tab" data-bs-toggle="tab" data-bs-target="#tabs-1774880892480901679-tab-0" type="button" role="tab" aria-controls="tabs-1774880892480901679-tab-0" aria-selected="true" > Go </button> </li><li class="nav-item" role="presentation"> <button class="nav-link" id="tabs-1774880892480901679-tab-1-tab" data-bs-toggle="tab" data-bs-target="#tabs-1774880892480901679-tab-1" type="button" role="tab" aria-controls="tabs-1774880892480901679-tab-1" aria-selected="false" > Python </button> </li><li class="nav-item" role="presentation"> <button class="nav-link" id="tabs-1774880892480901679-tab-2-tab" data-bs-toggle="tab" data-bs-target="#tabs-1774880892480901679-tab-2" type="button" role="tab" aria-controls="tabs-1774880892480901679-tab-2" aria-selected="false" > Rust </button> </li><li class="nav-item" role="presentation"> <button class="nav-link" id="tabs-1774880892480901679-tab-3-tab" data-bs-toggle="tab" data-bs-target="#tabs-1774880892480901679-tab-3" type="button" role="tab" aria-controls="tabs-1774880892480901679-tab-3" aria-selected="false" > Node.js </button> </li><li class="nav-item" role="presentation"> <button class="nav-link" id="tabs-1774880892480901679-tab-4-tab" data-bs-toggle="tab" data-bs-target="#tabs-1774880892480901679-tab-4" type="button" role="tab" aria-controls="tabs-1774880892480901679-tab-4" aria-selected="false" > Zig </button> </li></ul> <div class="tab-content border border-top-0 rounded-bottom p-3" id="tabs-1774880892480901679-content"><div class="tab-pane fade show active" id="tabs-1774880892480901679-tab-0" role="tabpanel" aria-labelledby="tabs-1774880892480901679-tab-0-tab" > <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-go" data-lang="go">func getFriendRecommendations(ctx context.Context, db *sql.DB, userID string) ([]Recommendation, error) { rows, err := db.QueryContext(ctx, ` MATCH (me:User {id: ?})-[:FOLLOWS]->(mutual:User)<-[:FOLLOWS]-(candidate:User) WHERE NOT EXISTS((me)-[:FOLLOWS]->(candidate)) AND candidate <> me WITH candidate, count(DISTINCT mutual) AS mutual_count RETURN candidate.id, candidate.username, candidate.name, mutual_count ORDER BY mutual_count DESC LIMIT 10 `, userID) if err != nil { return nil, err } defer rows.Close() var recommendations []Recommendation for rows.Next() { var r Recommendation rows.Scan(&r.ID, &r.Username, &r.Name, &r.MutualCount) recommendations = append(recommendations, r) } return recommendations, nil } </code></pre></div> </div><div class="tab-pane fade" id="tabs-1774880892480901679-tab-1" role="tabpanel" aria-labelledby="tabs-1774880892480901679-tab-1-tab" > <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python">async def get_friend_recommendations(conn, user_id: str, limit: int = 10): page, _ = await conn.query(""" MATCH (me:User {id: $user_id})-[:FOLLOWS]->(mutual:User)<-[:FOLLOWS]-(candidate:User) WHERE NOT EXISTS((me)-[:FOLLOWS]->(candidate)) AND candidate <> me WITH candidate, count(DISTINCT mutual) AS mutual_count, collect(DISTINCT mutual.username) AS mutual_friends RETURN candidate.id, candidate.username, candidate.name, mutual_count, mutual_friends ORDER BY mutual_count DESC LIMIT $limit """, {"user_id": user_id, "limit": limit}) return [ { "id": row["candidate.id"].as_string, "username": row["candidate.username"].as_string, "mutual_count": row["mutual_count"].as_int, "mutual_friends": row["mutual_friends"].as_array } for row in page.rows ] </code></pre></div> </div><div class="tab-pane fade" id="tabs-1774880892480901679-tab-2" role="tabpanel" aria-labelledby="tabs-1774880892480901679-tab-2-tab" > <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-rust" data-lang="rust">async fn get_friend_recommendations(conn: &mut Connection, user_id: &str) -> Result<Vec<Recommendation>> { let params = [("user_id", Value::string(user_id))].into(); let (page, _) = conn.query_with_params(r#" MATCH (me:User {id: $user_id})-[:FOLLOWS]->(mutual:User)<-[:FOLLOWS]-(candidate:User) WHERE NOT EXISTS((me)-[:FOLLOWS]->(candidate)) AND candidate <> me WITH candidate, count(DISTINCT mutual) AS mutual_count RETURN candidate.id, candidate.username, candidate.name, mutual_count ORDER BY mutual_count DESC LIMIT 10 "#, &params).await?; let recommendations = page.rows.iter().map(|row| Recommendation { id: row.get("candidate.id").unwrap().as_string().unwrap(), username: row.get("candidate.username").unwrap().as_string().unwrap(), mutual_count: row.get("mutual_count").unwrap().as_int().unwrap() as i32, }).collect(); Ok(recommendations) } </code></pre></div> </div><div class="tab-pane fade" id="tabs-1774880892480901679-tab-3" role="tabpanel" aria-labelledby="tabs-1774880892480901679-tab-3-tab" > <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-typescript" data-lang="typescript">async function getFriendRecommendations(userId: string, limit = 10) { const rows = await client.queryAll(` MATCH (me:User {id: $userId})-[:FOLLOWS]->(mutual:User)<-[:FOLLOWS]-(candidate:User) WHERE NOT EXISTS((me)-[:FOLLOWS]->(candidate)) AND candidate <> me WITH candidate, count(DISTINCT mutual) AS mutualCount, collect(DISTINCT mutual.username) AS mutualFriends RETURN candidate.id, candidate.username, candidate.name, mutualCount, mutualFriends ORDER BY mutualCount DESC LIMIT $limit `, { params: { userId, limit } }); return rows.map(row => ({ id: row.get('candidate.id')?.asString, username: row.get('candidate.username')?.asString, mutualCount: row.get('mutualCount')?.asNumber, mutualFriends: row.get('mutualFriends')?.asArray?.map(v => v.asString) })); } </code></pre></div> </div><div class="tab-pane fade" id="tabs-1774880892480901679-tab-4" role="tabpanel" aria-labelledby="tabs-1774880892480901679-tab-4-tab" > <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-zig" data-lang="zig">fn getFriendRecommendations(client: *GeodeClient, allocator: std.mem.Allocator, user_id: []const u8) ![]Recommendation { // Build params JSON object var params = std.json.ObjectMap.init(allocator); defer params.deinit(); try params.put("user_id", .{ .string = user_id }); const query = \\MATCH (me:User {id: $user_id})-[:FOLLOWS]->(mutual:User)<-[:FOLLOWS]-(candidate:User) \\WHERE NOT EXISTS((me)-[:FOLLOWS]->(candidate)) AND candidate <> me \\WITH candidate, count(DISTINCT mutual) AS mutual_count \\RETURN candidate.id, candidate.username, mutual_count \\ORDER BY mutual_count DESC LIMIT 10 ; try client.sendRunGql(1, query, .{ .object = params }); const schema = try client.receiveMessage(30000); allocator.free(schema); try client.sendPull(1, 1000); const result = try client.receiveMessage(30000); defer allocator.free(result); return parseRecommendations(allocator, result); } </code></pre></div> </div></div> </div> <h5 id="common-interests" class="position-relative d-flex align-items-center group"> Common Interests <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-interests" aria-haspopup="dialog" aria-label="Share link: Common Interests"> Share link </button> </h5><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Recommend based on shared interests MATCH (me:User {id: 'u1'})-[:INTERESTED_IN]->(interest:Topic), (interest)<-[:INTERESTED_IN]-(candidate:User) WHERE NOT EXISTS((me)-[:FOLLOWS]->(candidate)) AND candidate <> me WITH candidate, collect(DISTINCT interest.name) AS common_interests WHERE size(common_interests) >= 2 RETURN candidate.username, common_interests, size(common_interests) AS match_score ORDER BY match_score DESC LIMIT 10; </code></pre></div> <h4 id="step-2-community-detection" class="position-relative d-flex align-items-center group"> Step 2: Community Detection <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="step-2-community-detection" aria-haspopup="dialog" aria-label="Share link: Step 2: Community Detection"> Share link </button> </h4> <h5 id="louvain-algorithm" class="position-relative d-flex align-items-center group"> Louvain Algorithm <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="louvain-algorithm" aria-haspopup="dialog" aria-label="Share link: Louvain Algorithm"> Share link </button> </h5><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Detect communities CALL graph.louvain('SocialNetwork', { relationship_type: 'FOLLOWS', max_iterations: 10 }) YIELD node, community WITH community, collect(node.username) AS members, count(*) AS size ORDER BY size DESC RETURN community, size, members[0..5] AS sample_members; </code></pre></div> <h5 id="label-propagation" class="position-relative d-flex align-items-center group"> Label Propagation <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="label-propagation" aria-haspopup="dialog" aria-label="Share link: Label Propagation"> Share link </button> </h5><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Alternative community detection CALL graph.labelPropagation('SocialNetwork', { relationship_type: 'FOLLOWS', max_iterations: 20 }) YIELD node, community RETURN community, count(*) AS community_size ORDER BY community_size DESC; </code></pre></div> <h4 id="step-3-influence-analysis" class="position-relative d-flex align-items-center group"> Step 3: Influence Analysis <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="step-3-influence-analysis" aria-haspopup="dialog" aria-label="Share link: Step 3: Influence Analysis"> Share link </button> </h4> <h5 id="pagerank-for-influence" class="position-relative d-flex align-items-center group"> PageRank for Influence <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="pagerank-for-influence" aria-haspopup="dialog" aria-label="Share link: PageRank for Influence"> Share link </button> </h5><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Calculate user influence CALL graph.pageRank('SocialNetwork', { relationship_type: 'FOLLOWS', iterations: 20, damping_factor: 0.85 }) YIELD node, score RETURN node.username, node.name, score AS influence_score ORDER BY influence_score DESC LIMIT 20; </code></pre></div> <h5 id="betweenness-centrality" class="position-relative d-flex align-items-center group"> Betweenness Centrality <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="betweenness-centrality" aria-haspopup="dialog" aria-label="Share link: Betweenness Centrality"> Share link </button> </h5><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Find bridge users (connectors between communities) CALL graph.betweennessCentrality('SocialNetwork', { relationship_type: 'FOLLOWS', normalized: true }) YIELD node, score RETURN node.username, score AS bridge_score ORDER BY score DESC LIMIT 20; </code></pre></div> <h4 id="step-4-viral-content-tracking" class="position-relative d-flex align-items-center group"> Step 4: Viral Content Tracking <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="step-4-viral-content-tracking" aria-haspopup="dialog" aria-label="Share link: Step 4: Viral Content Tracking"> Share link </button> </h4> <h5 id="track-content-spread" class="position-relative d-flex align-items-center group"> Track Content Spread <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="track-content-spread" aria-haspopup="dialog" aria-label="Share link: Track Content Spread"> Share link </button> </h5><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Find viral posts MATCH (post:Post)<-[engagement]-(user:User) WHERE type(engagement) IN ['LIKED', 'SHARED', 'COMMENTED'] WITH post, count(DISTINCT user) AS reach, count(CASE WHEN type(engagement) = 'SHARED' THEN 1 END) AS shares, count(CASE WHEN type(engagement) = 'LIKED' THEN 1 END) AS likes RETURN post.id, post.content, reach, shares, likes, (shares * 1.0 / reach) AS viral_coefficient ORDER BY viral_coefficient DESC, reach DESC LIMIT 10; </code></pre></div> <h5 id="propagation-path-analysis" class="position-relative d-flex align-items-center group"> Propagation Path Analysis <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="propagation-path-analysis" aria-haspopup="dialog" aria-label="Share link: Propagation Path Analysis"> Share link </button> </h5><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Trace how content spread MATCH path = (original_poster:User)-[:POSTED]->(post:Post)<-[:SHARED*1..3]-(sharer:User) RETURN original_poster.username AS author, post.content AS content, length(path) AS hops, [n IN nodes(path)[2..] | n.username] AS propagation_chain; </code></pre></div> <h4 id="step-5-engagement-metrics" class="position-relative d-flex align-items-center group"> Step 5: Engagement 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="step-5-engagement-metrics" aria-haspopup="dialog" aria-label="Share link: Step 5: Engagement Metrics"> Share link </button> </h4> <h5 id="real-time-engagement-dashboard" class="position-relative d-flex align-items-center group"> Real-Time Engagement Dashboard <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="real-time-engagement-dashboard" aria-haspopup="dialog" aria-label="Share link: Real-Time Engagement Dashboard"> Share link </button> </h5><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- User engagement summary (last 24 hours) MATCH (user:User {id: 'u1'})-[:POSTED]->(post:Post) WHERE post.timestamp > timestamp() - (24 * 60 * 60 * 1000) OPTIONAL MATCH (post)<-[:LIKED]-(liker:User) OPTIONAL MATCH (post)<-[:SHARED]-(sharer:User) OPTIONAL MATCH (post)<-[:COMMENTED]-(commenter:User) RETURN user.username, count(DISTINCT post) AS posts, count(DISTINCT liker) AS total_likes, count(DISTINCT sharer) AS total_shares, count(DISTINCT commenter) AS total_comments; </code></pre></div> <h5 id="trending-topics" class="position-relative d-flex align-items-center group"> Trending 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="trending-topics" aria-haspopup="dialog" aria-label="Share link: Trending Topics"> Share link </button> </h5><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Find trending hashtags (last hour) MATCH (post:Post)-[:TAGGED]->(tag:Hashtag) WHERE post.timestamp > timestamp() - (60 * 60 * 1000) WITH tag, count(DISTINCT post) AS post_count ORDER BY post_count DESC LIMIT 10 MATCH (tag)<-[:TAGGED]-(trending_post:Post) WHERE trending_post.timestamp > timestamp() - (60 * 60 * 1000) RETURN tag.name, post_count, collect(trending_post.content)[0..3] AS sample_posts; </code></pre></div> <h3 id="advanced-patterns" class="position-relative d-flex align-items-center group"> Advanced 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="advanced-patterns" aria-haspopup="dialog" aria-label="Share link: Advanced Patterns"> Share link </button> </h3> <h4 id="graph-projections-for-analysis" class="position-relative d-flex align-items-center group"> Graph Projections for Analysis <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-projections-for-analysis" aria-haspopup="dialog" aria-label="Share link: Graph Projections for Analysis"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Create projection of strong connections only CALL graph.project('StrongConnections', { node_filter: 'User', relationship_filter: 'CLOSE_FRIEND OR (FOLLOWS AND interaction_score > 0.7)' }) YIELD graph_name, node_count, relationship_count; -- Run algorithms on projection CALL graph.pageRank('StrongConnections', { relationship_type: '*', iterations: 20 }) YIELD node, score RETURN node.username, score ORDER BY score DESC; </code></pre></div> <h4 id="temporal-network-analysis" class="position-relative d-flex align-items-center group"> Temporal Network Analysis <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="temporal-network-analysis" aria-haspopup="dialog" aria-label="Share link: Temporal Network Analysis"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Find new connections in time window MATCH (u1:User)-[f:FOLLOWS]->(u2:User) WHERE f.since > timestamp() - (7 * 24 * 60 * 60 * 1000) -- Last week WITH u1, count(f) AS new_connections ORDER BY new_connections DESC LIMIT 10 RETURN u1.username, new_connections; -- Analyze engagement over time MATCH (user:User)-[:POSTED]->(post:Post) WHERE post.timestamp > timestamp() - (30 * 24 * 60 * 60 * 1000) -- Last month WITH user, duration.between(datetime(post.timestamp), datetime()).days AS days_ago, post WITH user, (days_ago / 7) AS week, count(post) AS posts_per_week RETURN user.username, week, posts_per_week ORDER BY user.username, week; </code></pre></div> <h4 id="activity-streams" class="position-relative d-flex align-items-center group"> Activity Streams <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="activity-streams" aria-haspopup="dialog" aria-label="Share link: Activity Streams"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Generate personalized activity feed MATCH (me:User {id: 'u1'})-[:FOLLOWS]->(friend:User)-[action]->(target) WHERE type(action) IN ['POSTED', 'LIKED', 'SHARED', 'COMMENTED'] AND action.timestamp > timestamp() - (24 * 60 * 60 * 1000) WITH friend, action, target ORDER BY action.timestamp DESC LIMIT 50 RETURN { actor: friend.username, action: type(action), timestamp: action.timestamp, target: CASE WHEN target:Post THEN target.content WHEN target:User THEN target.username ELSE 'unknown' END } AS activity; </code></pre></div> <h3 id="real-time-features" class="position-relative d-flex align-items-center group"> Real-Time 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="real-time-features" aria-haspopup="dialog" aria-label="Share link: Real-Time Features"> Share link </button> </h3> <h4 id="live-notifications" class="position-relative d-flex align-items-center group"> Live Notifications <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="live-notifications" aria-haspopup="dialog" aria-label="Share link: Live Notifications"> Share link </button> </h4>Poll for new notifications and display them to users. <div class="docs-tabs mb-4"> <ul class="nav nav-tabs" id="tabs-1774880892492894268" role="tablist"><li class="nav-item" role="presentation"> <button class="nav-link active" id="tabs-1774880892492894268-tab-0-tab" data-bs-toggle="tab" data-bs-target="#tabs-1774880892492894268-tab-0" type="button" role="tab" aria-controls="tabs-1774880892492894268-tab-0" aria-selected="true" > Go </button> </li><li class="nav-item" role="presentation"> <button class="nav-link" id="tabs-1774880892492894268-tab-1-tab" data-bs-toggle="tab" data-bs-target="#tabs-1774880892492894268-tab-1" type="button" role="tab" aria-controls="tabs-1774880892492894268-tab-1" aria-selected="false" > Python </button> </li><li class="nav-item" role="presentation"> <button class="nav-link" id="tabs-1774880892492894268-tab-2-tab" data-bs-toggle="tab" data-bs-target="#tabs-1774880892492894268-tab-2" type="button" role="tab" aria-controls="tabs-1774880892492894268-tab-2" aria-selected="false" > Rust </button> </li><li class="nav-item" role="presentation"> <button class="nav-link" id="tabs-1774880892492894268-tab-3-tab" data-bs-toggle="tab" data-bs-target="#tabs-1774880892492894268-tab-3" type="button" role="tab" aria-controls="tabs-1774880892492894268-tab-3" aria-selected="false" > Node.js </button> </li><li class="nav-item" role="presentation"> <button class="nav-link" id="tabs-1774880892492894268-tab-4-tab" data-bs-toggle="tab" data-bs-target="#tabs-1774880892492894268-tab-4" type="button" role="tab" aria-controls="tabs-1774880892492894268-tab-4" aria-selected="false" > Zig </button> </li></ul> <div class="tab-content border border-top-0 rounded-bottom p-3" id="tabs-1774880892492894268-content"><div class="tab-pane fade show active" id="tabs-1774880892492894268-tab-0" role="tabpanel" aria-labelledby="tabs-1774880892492894268-tab-0-tab" > <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-go" data-lang="go">func pollNotifications(ctx context.Context, db *sql.DB, userID string) { var lastSeen *int64 ticker := time.NewTicker(2 * time.Second) defer ticker.Stop() for { select { case <-ctx.Done(): return case <-ticker.C: rows, err := db.QueryContext(ctx, ` MATCH (u:User {id: ?})<-[r]-() WHERE ? IS NULL OR r.timestamp > ? RETURN type(r) AS rel_type, r.timestamp AS ts ORDER BY ts DESC LIMIT 20 `, userID, lastSeen, lastSeen) if err != nil { continue } for rows.Next() { var relType string var ts int64 rows.Scan(&relType, &ts) switch relType { case "LIKED": fmt.Println("Someone liked your post!") case "FOLLOWED": fmt.Println("New follower!") case "COMMENTED": fmt.Println("New comment!") } if lastSeen == nil || ts > *lastSeen { lastSeen = &ts } } rows.Close() } } } </code></pre></div> </div><div class="tab-pane fade" id="tabs-1774880892492894268-tab-1" role="tabpanel" aria-labelledby="tabs-1774880892492894268-tab-1-tab" > <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python">async def poll_notifications(user_id): last_seen = None async with client.connection() as conn: while True: page, _ = await conn.query(""" MATCH (u:User {id: $user_id})<-[r]-() WHERE $last_seen IS NULL OR r.timestamp > $last_seen RETURN type(r) AS rel_type, r.timestamp AS ts ORDER BY ts DESC LIMIT 20 """, {"user_id": user_id, "last_seen": last_seen}) for row in page.rows: rel_type = row["rel_type"].raw_value if rel_type == "LIKED": print("Someone liked your post!") elif rel_type == "FOLLOWED": print("New follower!") elif rel_type == "COMMENTED": print("New comment!") if page.rows: last_seen = page.rows[0]["ts"].raw_value await asyncio.sleep(2) </code></pre></div> </div><div class="tab-pane fade" id="tabs-1774880892492894268-tab-2" role="tabpanel" aria-labelledby="tabs-1774880892492894268-tab-2-tab" > <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-rust" data-lang="rust">async fn poll_notifications(conn: &mut Connection, user_id: &str) -> Result<()> { let mut last_seen: Option<i64> = None; loop { let params = [ ("user_id", Value::string(user_id)), ("last_seen", last_seen.map(Value::int).unwrap_or(Value::null())), ].into(); let (page, _) = conn.query_with_params(r#" MATCH (u:User {id: $user_id})<-[r]-() WHERE $last_seen IS NULL OR r.timestamp > $last_seen RETURN type(r) AS rel_type, r.timestamp AS ts ORDER BY ts DESC LIMIT 20 "#, &params).await?; for row in &page.rows { let rel_type = row.get("rel_type").unwrap().as_string()?; match rel_type.as_str() { "LIKED" => println!("Someone liked your post!"), "FOLLOWED" => println!("New follower!"), "COMMENTED" => println!("New comment!"), _ => {} } if let Some(ts) = row.get("ts").and_then(|v| v.as_int().ok()) { last_seen = Some(ts.max(last_seen.unwrap_or(0))); } } tokio::time::sleep(Duration::from_secs(2)).await; } } </code></pre></div> </div><div class="tab-pane fade" id="tabs-1774880892492894268-tab-3" role="tabpanel" aria-labelledby="tabs-1774880892492894268-tab-3-tab" > <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-typescript" data-lang="typescript">async function pollNotifications(userId: string) { let lastSeen: number | null = null; while (true) { const rows = await client.queryAll(` MATCH (u:User {id: $userId})<-[r]-() WHERE $lastSeen IS NULL OR r.timestamp > $lastSeen RETURN type(r) AS relType, r.timestamp AS ts ORDER BY ts DESC LIMIT 20 `, { params: { userId, lastSeen } }); for (const row of rows) { const relType = row.get('relType')?.asString; switch (relType) { case 'LIKED': console.log('Someone liked your post!'); break; case 'FOLLOWED': console.log('New follower!'); break; case 'COMMENTED': console.log('New comment!'); break; } const ts = row.get('ts')?.asNumber; if (ts && (!lastSeen || ts > lastSeen)) lastSeen = ts; } await new Promise(r => setTimeout(r, 2000)); } } </code></pre></div> </div><div class="tab-pane fade" id="tabs-1774880892492894268-tab-4" role="tabpanel" aria-labelledby="tabs-1774880892492894268-tab-4-tab" > <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-zig" data-lang="zig">fn pollNotifications(client: *GeodeClient, allocator: std.mem.Allocator, user_id: []const u8) !void { var last_seen: ?i64 = null; var request_id: u64 = 1; while (true) { var params = std.json.ObjectMap.init(allocator); defer params.deinit(); try params.put("user_id", .{ .string = user_id }); try params.put("last_seen", if (last_seen) |ts| .{ .integer = ts } else .null); const query = \\MATCH (u:User {id: $user_id})<-[r]-() \\WHERE $last_seen IS NULL OR r.timestamp > $last_seen \\RETURN type(r) AS rel_type, r.timestamp AS ts \\ORDER BY ts DESC LIMIT 20 ; try client.sendRunGql(request_id, query, .{ .object = params }); request_id += 1; const schema = try client.receiveMessage(30000); allocator.free(schema); try client.sendPull(request_id - 1, 1000); const result = try client.receiveMessage(30000); defer allocator.free(result); // Parse JSON and handle notifications std.time.sleep(2 * std.time.ns_per_s); } } </code></pre></div> </div></div> </div> <h4 id="real-time-feed-updates" class="position-relative d-flex align-items-center group"> Real-Time Feed Updates <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="real-time-feed-updates" aria-haspopup="dialog" aria-label="Share link: Real-Time Feed Updates"> Share link </button> </h4><div class="docs-tabs mb-4"> <ul class="nav nav-tabs" id="tabs-1774880892508539230" role="tablist"><li class="nav-item" role="presentation"> <button class="nav-link active" id="tabs-1774880892508539230-tab-0-tab" data-bs-toggle="tab" data-bs-target="#tabs-1774880892508539230-tab-0" type="button" role="tab" aria-controls="tabs-1774880892508539230-tab-0" aria-selected="true" > Go </button> </li><li class="nav-item" role="presentation"> <button class="nav-link" id="tabs-1774880892508539230-tab-1-tab" data-bs-toggle="tab" data-bs-target="#tabs-1774880892508539230-tab-1" type="button" role="tab" aria-controls="tabs-1774880892508539230-tab-1" aria-selected="false" > Python </button> </li><li class="nav-item" role="presentation"> <button class="nav-link" id="tabs-1774880892508539230-tab-2-tab" data-bs-toggle="tab" data-bs-target="#tabs-1774880892508539230-tab-2" type="button" role="tab" aria-controls="tabs-1774880892508539230-tab-2" aria-selected="false" > Rust </button> </li><li class="nav-item" role="presentation"> <button class="nav-link" id="tabs-1774880892508539230-tab-3-tab" data-bs-toggle="tab" data-bs-target="#tabs-1774880892508539230-tab-3" type="button" role="tab" aria-controls="tabs-1774880892508539230-tab-3" aria-selected="false" > Node.js </button> </li><li class="nav-item" role="presentation"> <button class="nav-link" id="tabs-1774880892508539230-tab-4-tab" data-bs-toggle="tab" data-bs-target="#tabs-1774880892508539230-tab-4" type="button" role="tab" aria-controls="tabs-1774880892508539230-tab-4" aria-selected="false" > Zig </button> </li></ul> <div class="tab-content border border-top-0 rounded-bottom p-3" id="tabs-1774880892508539230-content"><div class="tab-pane fade show active" id="tabs-1774880892508539230-tab-0" role="tabpanel" aria-labelledby="tabs-1774880892508539230-tab-0-tab" > <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-go" data-lang="go">func pollLiveFeed(ctx context.Context, db *sql.DB, userID string) { var lastSeen *int64 for { rows, _ := db.QueryContext(ctx, ` MATCH (me:User {id: ?})-[:FOLLOWS]->(friend:User)-[:POSTED]->(p:Post) WHERE ? IS NULL OR p.created_at > ? RETURN friend.username AS username, p.content AS content, p.created_at ORDER BY p.created_at DESC LIMIT 50 `, userID, lastSeen, lastSeen) for rows.Next() { var username, content string var createdAt int64 rows.Scan(&username, &content, &createdAt) fmt.Printf("New post from %s: %s\n", username, content) if lastSeen == nil || createdAt > *lastSeen { lastSeen = &createdAt } } rows.Close() time.Sleep(3 * time.Second) } } </code></pre></div> </div><div class="tab-pane fade" id="tabs-1774880892508539230-tab-1" role="tabpanel" aria-labelledby="tabs-1774880892508539230-tab-1-tab" > <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python">async def poll_live_feed(user_id): last_seen = None async with client.connection() as conn: while True: page, _ = await conn.query(""" MATCH (me:User {id: $user_id})-[:FOLLOWS]->(friend:User)-[:POSTED]->(p:Post) WHERE $last_seen IS NULL OR p.created_at > $last_seen RETURN friend.username AS username, p.content AS content, p.created_at ORDER BY p.created_at DESC LIMIT 50 """, {"user_id": user_id, "last_seen": last_seen}) for row in page.rows: print(f"New post from {row['username'].raw_value}: {row['content'].raw_value}") if page.rows: last_seen = page.rows[0]["p.created_at"].raw_value await asyncio.sleep(3) </code></pre></div> </div><div class="tab-pane fade" id="tabs-1774880892508539230-tab-2" role="tabpanel" aria-labelledby="tabs-1774880892508539230-tab-2-tab" > <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-rust" data-lang="rust">async fn poll_live_feed(conn: &mut Connection, user_id: &str) -> Result<()> { let mut last_seen: Option<i64> = None; loop { let params = [ ("user_id", Value::string(user_id)), ("last_seen", last_seen.map(Value::int).unwrap_or(Value::null())), ].into(); let (page, _) = conn.query_with_params(r#" MATCH (me:User {id: $user_id})-[:FOLLOWS]->(friend:User)-[:POSTED]->(p:Post) WHERE $last_seen IS NULL OR p.created_at > $last_seen RETURN friend.username AS username, p.content AS content, p.created_at ORDER BY p.created_at DESC LIMIT 50 "#, &params).await?; for row in &page.rows { println!("New post from {}: {}", row.get("username").unwrap().as_string()?, row.get("content").unwrap().as_string()?); } tokio::time::sleep(Duration::from_secs(3)).await; } } </code></pre></div> </div><div class="tab-pane fade" id="tabs-1774880892508539230-tab-3" role="tabpanel" aria-labelledby="tabs-1774880892508539230-tab-3-tab" > <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-typescript" data-lang="typescript">async function pollLiveFeed(userId: string) { let lastSeen: number | null = null; while (true) { const rows = await client.queryAll(` MATCH (me:User {id: $userId})-[:FOLLOWS]->(friend:User)-[:POSTED]->(p:Post) WHERE $lastSeen IS NULL OR p.created_at > $lastSeen RETURN friend.username AS username, p.content AS content, p.created_at AS createdAt ORDER BY createdAt DESC LIMIT 50 `, { params: { userId, lastSeen } }); for (const row of rows) { console.log(`New post from ${row.get('username')?.asString}: ${row.get('content')?.asString}`); const ts = row.get('createdAt')?.asNumber; if (ts && (!lastSeen || ts > lastSeen)) lastSeen = ts; } await new Promise(r => setTimeout(r, 3000)); } } </code></pre></div> </div><div class="tab-pane fade" id="tabs-1774880892508539230-tab-4" role="tabpanel" aria-labelledby="tabs-1774880892508539230-tab-4-tab" > <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-zig" data-lang="zig">fn pollLiveFeed(client: *GeodeClient, allocator: std.mem.Allocator, user_id: []const u8) !void { var last_seen: ?i64 = null; var request_id: u64 = 1; while (true) { var params = std.json.ObjectMap.init(allocator); defer params.deinit(); try params.put("user_id", .{ .string = user_id }); try params.put("last_seen", if (last_seen) |ts| .{ .integer = ts } else .null); const query = \\MATCH (me:User {id: $user_id})-[:FOLLOWS]->(friend:User)-[:POSTED]->(p:Post) \\WHERE $last_seen IS NULL OR p.created_at > $last_seen \\RETURN friend.username AS username, p.content AS content, p.created_at \\ORDER BY p.created_at DESC LIMIT 50 ; try client.sendRunGql(request_id, query, .{ .object = params }); request_id += 1; const schema = try client.receiveMessage(30000); allocator.free(schema); try client.sendPull(request_id - 1, 1000); const result = try client.receiveMessage(30000); defer allocator.free(result); // Process feed items and update last_seen std.time.sleep(3 * std.time.ns_per_s); } } </code></pre></div> </div></div> </div> <h3 id="performance-optimization" class="position-relative d-flex align-items-center group"> Performance Optimization <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-optimization" aria-haspopup="dialog" aria-label="Share link: Performance Optimization"> Share link </button> </h3> <h4 id="indexing-strategy" class="position-relative d-flex align-items-center group"> Indexing Strategy <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="indexing-strategy" aria-haspopup="dialog" aria-label="Share link: Indexing Strategy"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Core indexes CREATE INDEX user_id_idx ON User(id) USING hash; CREATE INDEX user_username_idx ON User(username) USING hash; CREATE INDEX post_timestamp_idx ON Post(timestamp) USING btree; -- Composite indexes CREATE INDEX user_location_verified_idx ON User(location, verified) USING btree; -- Full-text search CREATE INDEX user_bio_ft_idx ON User(bio, name) USING fulltext; CREATE INDEX post_content_ft_idx ON Post(content) USING fulltext; </code></pre></div> <h4 id="query-optimization" class="position-relative d-flex align-items-center group"> Query Optimization <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-optimization" aria-haspopup="dialog" aria-label="Share link: Query Optimization"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Use LIMIT to restrict results MATCH (me:User {id: 'u1'})-[:FOLLOWS]->(friend:User)-[:POSTED]->(post:Post) WHERE post.timestamp > timestamp() - (24 * 60 * 60 * 1000) RETURN post ORDER BY post.timestamp DESC LIMIT 50; -- Don't fetch more than needed -- Use EXISTS for filtering MATCH (user:User) WHERE EXISTS((user)-[:FOLLOWS]->(:User {verified: true})) RETURN user.username; </code></pre></div> <h4 id="caching" class="position-relative d-flex align-items-center group"> Caching <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="caching" aria-haspopup="dialog" aria-label="Share link: Caching"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python"># Cache frequently accessed data from geode_client import Client client = Client(host="geode.example.com", port=3141) profile_cache = {} followers_cache = {} async def get_user_profile(conn, user_id): """Cache user profiles""" if user_id in profile_cache: return profile_cache[user_id] page, _ = await conn.query(""" MATCH (u:User {id: $id}) RETURN u.username, u.name, u.bio, u.verified """, {'id': user_id}) profile = page.rows[0] if page.rows else None profile_cache[user_id] = profile return profile async def get_follower_count(conn, user_id): """Cache follower counts""" if user_id in followers_cache: return followers_cache[user_id] page, _ = await conn.query(""" MATCH (:User {id: $id})<-[:FOLLOWS]-(follower) RETURN count(follower) AS count """, {'id': user_id}) count = page.rows[0]["count"].raw_value if page.rows else 0 followers_cache[user_id] = count return count # Usage # async with client.connection() as conn: # profile = await get_user_profile(conn, "u1") # count = await get_follower_count(conn, "u1") </code></pre></div> <h3 id="metrics-and-kpis" class="position-relative d-flex align-items-center group"> Metrics and KPIs <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="metrics-and-kpis" aria-haspopup="dialog" aria-label="Share link: Metrics and KPIs"> Share link </button> </h3> <h4 id="network-health-metrics" class="position-relative d-flex align-items-center group"> Network Health 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="network-health-metrics" aria-haspopup="dialog" aria-label="Share link: Network Health Metrics"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Average degree (connections per user) MATCH (u:User) OPTIONAL MATCH (u)-[:FOLLOWS]-() WITH u, count(*) AS degree RETURN avg(degree) AS avg_connections_per_user; -- Network density MATCH (u:User) WITH count(u) AS total_users MATCH ()-[f:FOLLOWS]->() WITH total_users, count(f) AS total_edges RETURN total_edges * 1.0 / (total_users * (total_users - 1)) AS network_density; -- Clustering coefficient (how connected are friends of friends) CALL graph.clusteringCoefficient('SocialNetwork', { relationship_type: 'FOLLOWS' }) YIELD node, coefficient RETURN avg(coefficient) AS avg_clustering_coefficient; </code></pre></div> <h4 id="engagement-kpis" class="position-relative d-flex align-items-center group"> Engagement KPIs <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="engagement-kpis" aria-haspopup="dialog" aria-label="Share link: Engagement KPIs"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Daily Active Users (DAU) MATCH (u:User)-[action]->() WHERE action.timestamp > timestamp() - (24 * 60 * 60 * 1000) AND type(action) IN ['POSTED', 'LIKED', 'SHARED', 'COMMENTED'] RETURN count(DISTINCT u) AS dau; -- Posts per active user MATCH (u:User)-[:POSTED]->(p:Post) WHERE p.timestamp > timestamp() - (24 * 60 * 60 * 1000) WITH u, count(p) AS posts RETURN avg(posts) AS avg_posts_per_active_user; -- Viral coefficient (average shares per post) MATCH (post:Post)<-[:SHARED]-(user) WITH post, count(user) AS shares RETURN avg(shares) AS avg_shares_per_post; </code></pre></div> <h3 id="privacy-and-security" class="position-relative d-flex align-items-center group"> Privacy and 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="privacy-and-security" aria-haspopup="dialog" aria-label="Share link: Privacy and Security"> Share link </button> </h3> <h4 id="content-visibility" class="position-relative d-flex align-items-center group"> Content Visibility <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="content-visibility" aria-haspopup="dialog" aria-label="Share link: Content Visibility"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Respect privacy settings MATCH (viewer:User {id: 'u1'}), (author:User)-[:POSTED]->(post:Post) WHERE ( post.visibility = 'public' OR (post.visibility = 'friends' AND EXISTS((viewer)-[:FOLLOWS]->(author))) OR (post.visibility = 'private' AND viewer = author) ) RETURN post; </code></pre></div> <h4 id="block-and-mute" class="position-relative d-flex align-items-center group"> Block and Mute <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="block-and-mute" aria-haspopup="dialog" aria-label="Share link: Block and Mute"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Implement blocking MATCH (blocker:User {id: 'u1'}), (blocked:User {id: 'u2'}) CREATE (blocker)-[:BLOCKED {timestamp: timestamp()}]->(blocked); -- Filter blocked users from results MATCH (me:User {id: 'u1'})-[:FOLLOWS]->(friend:User)-[:POSTED]->(post:Post) WHERE NOT EXISTS((me)-[:BLOCKED]->(friend)) AND NOT EXISTS((friend)-[:BLOCKED]->(me)) RETURN post; </code></pre></div> <h3 id="complete-example-twitter-like-platform" class="position-relative d-flex align-items-center group"> Complete Example: Twitter-Like Platform <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="complete-example-twitter-like-platform" aria-haspopup="dialog" aria-label="Share link: Complete Example: Twitter-Like Platform"> Share link </button> </h3><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Create users CREATE (:User {id: 'u1', username: '@alice', followers: 0, following: 0}), (:User {id: 'u2', username: '@bob', followers: 0, following: 0}), (:User {id: 'u3', username: '@carol', followers: 0, following: 0}); -- Follow relationships MATCH (alice:User {id: 'u1'}), (bob:User {id: 'u2'}) CREATE (alice)-[:FOLLOWS {since: timestamp()}]->(bob); -- Create tweets MATCH (bob:User {id: 'u2'}) CREATE (bob)-[:POSTED {timestamp: timestamp()}]->(:Tweet { id: 't1', content: 'Graph databases are amazing! #graphs #database', timestamp: timestamp(), retweets: 0, likes: 0 }); -- Like tweet MATCH (alice:User {id: 'u1'}), (tweet:Tweet {id: 't1'}) CREATE (alice)-[:LIKED {timestamp: timestamp()}]->(tweet); -- Retweet MATCH (alice:User {id: 'u1'}), (original:Tweet {id: 't1'}) CREATE (alice)-[:RETWEETED { timestamp: timestamp(), comment: 'Totally agree!' }]->(original); -- Get personalized timeline MATCH (me:User {id: 'u1'})-[:FOLLOWS]->(friend:User)-[posted:POSTED]->(tweet:Tweet) WHERE posted.timestamp > timestamp() - (24 * 60 * 60 * 1000) OPTIONAL MATCH (tweet)<-[:LIKED]-(liker) OPTIONAL MATCH (tweet)<-[:RETWEETED]-(retweeter) RETURN tweet.content, friend.username AS author, posted.timestamp, count(DISTINCT liker) AS likes, count(DISTINCT retweeter) AS retweets ORDER BY posted.timestamp DESC LIMIT 50; </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/analytics/graph-algorithms/" >Graph Algorithms</a> - Community detection, PageRank, centrality</li> <li><a href="/docs/analytics/real-time-analytics/" >Real-Time Analytics</a> - Streaming analytics and CDC</li> <li><a href="/docs/performance/" >Performance Tuning</a> - Optimize social network queries</li> <li><a href="/docs/guides/schema-design/" >Schema Design Guide</a> - Model complex social relationships</li> </ul> <h3 id="references" class="position-relative d-flex align-items-center group"> References <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="references" aria-haspopup="dialog" aria-label="Share link: References"> Share link </button> </h3><ul> <li><a href="/docs/model/data-model-and-types/" >Data Model Guide</a> - Property graph modeling</li> <li><a href="/docs/gql/guide/" >GQL Guide</a> - Query language reference</li> <li><a href="/docs/tutorials/indexing-tutorial/" >Indexing Tutorial</a> - Optimize query performance</li> <li><a href="/docs/tutorials/graph-algorithms-tutorial/" >Graph Algorithms Tutorial</a> - Hands-on algorithm usage</li> </ul> <hr> License: Apache License 2.0 Copyright: 2024-2025 CodePros Last Updated: January 2026