Cloud Run orchestration between ephemeral NoSQL and persistent ACID ledgers.
The Dual-Database Pipeline
PCMTG operates on a fully serverless, event-driven topology within the Google Cloud Platform (GCP)[cite: 438]. Operating a high-speed NoSQL database alongside a rigid relational ledger introduces the classic distributed systems challenge: Eventual Consistency and State Synchronization[cite: 499].
1. Live Game State (Firestore - NoSQL)
Firestore is optimized for massive parallel reads and real-time websocket pushes, used strictly for “in-flight” data like the active Poker Tables[cite: 507].
The Secret Vector Exploit: Firestore client SDKs fetch entire documents[cite: 514]. To prevent players from reverse-engineering the math via Chrome DevTools, the secret_vector is placed in an air-gapped private subcollection (secure_data/solution) that is locked down by Firestore Security Rules and only accessible via the Cloud Run Admin SDK[cite: 516, 517, 520, 530].
2. Core Economy (Neon Postgres - SQL)
The persistent economy requires ACID compliance, ensuring a player cannot spend the same currency twice[cite: 470, 471]. This database handles the CardMasterRegistry and the DynamicExchangeLedger[cite: 471].
3. The Resolution Bridge
The Next.js client never writes directly to Cloud SQL[cite: 502]. Instead, Cloud Scheduler triggers the Cloud Run GameLogicManager, which reads the final Firestore state, calculates the math, opens a secure SQL transaction, and only then updates the Firestore table status[cite: 504, 505].
{"docsConfig":{"$schema":"https://mintlify.com/docs.json","theme":"mint","name":"PCMTG Project Bible","colors":{"primary":"#FF4500","light":"#FFA07A","dark":"#8B0000"},"favicon":"https://mintlify.s3.us-west-1.amazonaws.com/pcmtg/favicon.png","logo":{"light":"https://mintlify.s3.us-west-1.amazonaws.com/pcmtg/logo/light.svg","dark":"https://mintlify.s3.us-west-1.amazonaws.com/pcmtg/logo/dark.svg"},"navbar":{"links":[{"label":"GitHub Monorepo","href":"https://github.com/PCMTG-Studios/pcmtg-core"}],"primary":null},"styling":{"latex":true},"navigation":{"pages":[]}},"deployment":{"deploymentMetadataValue":{"subdomain":"pcmtg","hasAudioNarration":false,"actualSubdomain":"pcmtg","customDomains":["docs.pcm.game"],"gitSource":{"type":"github","owner":"pcmtg-studios","repo":"pcmtg-core","deployBranch":"main","contentDirectory":"docs","isPrivate":true,"mountPath":"","label":""},"entitlements":{"AI_CHAT":{"status":"DISABLED"}},"buildId":"6ae9585ff034dd2525b1f358:success","clientVersion":"0.0.4205","searchFilterCounts":[{"language":"default","tag":"III. Roadmaps","count":12},{"language":"default","tag":"VI. Sprint Artifacts","count":5},{"language":"default","tag":"II. System Architecture","count":4},{"language":"default","tag":"I. Executive Summary","count":3},{"language":"default","tag":"IV. Architecture","count":2},{"language":"default","tag":"V. Game Theory","count":2}]},"assistantConfig":{"enableAskAiButton":false,"enableStarterQuestions":false,"enableContextualStarterQuestions":false,"enableAskAiSearchBar":true},"basePath":"","hasChatPermissions":false,"hasWebMcpPermissions":false,"toggles":[{"name":"kill-isr","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-rbac-roles","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-mintlify-slack","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-integrations-settings","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"rbac-expansion","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-pr-grouping","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-prefix","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"analytics-v7","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"user-flows-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"no-publish-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-onboarding","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving-live","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"stripTemperatureMiddleware","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"support-platform-pylon-zendesk","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"instant-rollback","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications-server","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-fable","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fixed-ai-action-pricing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automation-resolve-merge-conflict","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"scoped-publishing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"mintql","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"page-level-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-version-history-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-page-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"full-page-search","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workspace-projects","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"assistant-v5","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fork-pr-previews","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"revalidation-jwt","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-sso-scim","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"hobby-abuse-scan","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"dashboard-inbox","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-signup","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-dual-write","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-enabled","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"approve-review-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-metadata","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"sso-setup-deadline-banner","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-serve","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"live-agents","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"starter-pricing","enabled":true,"variant":{"name":"treatment","enabled":true,"payload":{"type":"string","value":"treatment"},"feature_enabled":true},"impressionData":false},{"name":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"wildcard-email-auth","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"googleFontsInlined":false},"customCss":[],"page":{"pagePath":"architecture/dual-database-pipeline","slug":"/architecture/dual-database-pipeline","pageMetadata":{"title":"The Dual-Database Pipeline","description":"Cloud Run orchestration between ephemeral NoSQL and persistent ACID ledgers.","href":"/architecture/dual-database-pipeline"},"description":{"compiledSource":"\"use strict\";\nconst {jsx: _jsx} = arguments[0];\nconst {useMDXComponents: _provideComponents} = arguments[0];\nfunction _createMdxContent(props) {\n const _components = {\n p: \"p\",\n ..._provideComponents(),\n ...props.components\n };\n return _jsx(_components.p, {\n children: \"Cloud Run orchestration between ephemeral NoSQL and persistent ACID ledgers.\"\n });\n}\nfunction MDXContent(props = {}) {\n const {wrapper: MDXLayout} = {\n ..._provideComponents(),\n ...props.components\n };\n return MDXLayout ? _jsx(MDXLayout, {\n ...props,\n children: _jsx(_createMdxContent, {\n ...props\n })\n }) : _createMdxContent(props);\n}\nreturn {\n default: MDXContent\n};\n","frontmatter":{},"scope":{}},"pageType":"default","mdx":{"mdxSource":{"compiledSource":"\"use strict\";const{Fragment:_Fragment,jsx:_jsx,jsxs:_jsxs}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];function _createMdxContent(props){const _components={code:`code`,p:`p`,strong:`strong`,..._provideComponents(),...props.components},{Heading,Warning}=_components;if(!Heading)_missingMdxReference(`Heading`,true);if(!Warning)_missingMdxReference(`Warning`,true);return _jsxs(_Fragment,{children:[_jsx(Heading,{level:`1`,id:`the-dual-database-pipeline`,children:`The Dual-Database Pipeline`}),`\n`,_jsx(_components.p,{children:`PCMTG operates on a fully serverless, event-driven topology within the Google Cloud Platform (GCP)[cite: 438]. Operating a high-speed NoSQL database alongside a rigid relational ledger introduces the classic distributed systems challenge: Eventual Consistency and State Synchronization[cite: 499].`}),`\n`,_jsx(Heading,{level:`2`,id:`1-live-game-state-firestore-nosql`,children:`1. Live Game State (Firestore - NoSQL)`}),`\n`,_jsx(_components.p,{children:`Firestore is optimized for massive parallel reads and real-time websocket pushes, used strictly for “in-flight” data like the active Poker Tables[cite: 507].`}),`\n`,_jsx(Warning,{children:_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`The Secret Vector Exploit:`}),` Firestore client SDKs fetch entire documents[cite: 514]. To prevent players from reverse-engineering the math via Chrome DevTools, the `,_jsx(_components.code,{children:`secret_vector`}),` is placed in an air-gapped private subcollection (`,_jsx(_components.code,{children:`secure_data/solution`}),`) that is locked down by Firestore Security Rules and only accessible via the Cloud Run Admin SDK[cite: 516, 517, 520, 530].`]})}),`\n`,_jsx(Heading,{level:`2`,id:`2-core-economy-neon-postgres-sql`,children:`2. Core Economy (Neon Postgres - SQL)`}),`\n`,_jsxs(_components.p,{children:[`The persistent economy requires ACID compliance, ensuring a player cannot spend the same currency twice[cite: 470, 471]. This database handles the `,_jsx(_components.code,{children:`CardMasterRegistry`}),` and the `,_jsx(_components.code,{children:`DynamicExchangeLedger`}),`[cite: 471].`]}),`\n`,_jsx(Heading,{level:`2`,id:`3-the-resolution-bridge`,children:`3. The Resolution Bridge`}),`\n`,_jsxs(_components.p,{children:[`The Next.js client never writes directly to Cloud SQL[cite: 502]. Instead, Cloud Scheduler triggers the Cloud Run `,_jsx(_components.code,{children:`GameLogicManager`}),`, which reads the final Firestore state, calculates the math, opens a secure SQL transaction, and only then updates the Firestore table status[cite: 504, 505].`]})]})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{default:MDXContent};function _missingMdxReference(id,component){throw new Error(`Expected `+(component?`component`:`object`)+\" `\"+id+\"` to be defined: you likely forgot to import, pass, or provide it.\")}","frontmatter":{},"scope":{"config":{},"pageMetadata":{"title":"The Dual-Database Pipeline","description":"Cloud Run orchestration between ephemeral NoSQL and persistent ACID ledgers.","href":"/architecture/dual-database-pipeline"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[{"title":"The Dual-Database Pipeline","slug":"the-dual-database-pipeline","depth":1,"children":[]},{"title":"1. Live Game State (Firestore - NoSQL)","slug":"1-live-game-state-firestore-nosql","depth":2,"children":[]},{"title":"2. Core Economy (Neon Postgres - SQL)","slug":"2-core-economy-neon-postgres-sql","depth":2,"children":[]},{"title":"3. The Resolution Bridge","slug":"3-the-resolution-bridge","depth":2,"children":[]}],"codeExamples":{}},"jsLinks":[],"subdomain":"pcmtg","siteName":"PCMTG Project Bible","title":"The Dual-Database Pipeline - PCMTG Project Bible","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{}},"lastModified":"2026-05-26T05:11:42.788Z","originalFileLocation":"architecture/dual-database-pipeline.mdx"},"headHtml":"\u003cscript data-mint-head>(function(){var d=document.documentElement,p=null;if(!p){try{p=localStorage.getItem(\"isDarkMode\")}catch(e){}if(p==='true')p='dark';else if(p==='false')p='light';if(p!=='light'\u0026\u0026p!=='dark'\u0026\u0026p!=='system')p=\"system\"}var r=p==='system'?(matchMedia(\"(prefers-color-scheme: dark)\").matches?'dark':'light'):p;d.classList.remove(r==='dark'?'light':'dark');d.classList.add(r);d.setAttribute(\"data-theme-preference\",p)})();\u003c/script>\u003cmeta data-mint-head name=\"description\" content=\"Cloud Run orchestration between ephemeral NoSQL and persistent ACID ledgers.\">\u003cmeta data-mint-head name=\"application-name\" content=\"PCMTG Project Bible\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"apple-touch-icon\" type=\"image/png\" sizes=\"180x180\" href=\"https://mintlify.s3.us-west-1.amazonaws.com/pcmtg/favicon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"https://mintlify.s3.us-west-1.amazonaws.com/pcmtg/favicon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"https://mintlify.s3.us-west-1.amazonaws.com/pcmtg/favicon.png\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/png\" href=\"https://mintlify.s3.us-west-1.amazonaws.com/pcmtg/favicon.png\">\u003cmeta data-mint-head property=\"og:title\" content=\"The Dual-Database Pipeline - PCMTG Project Bible\">\u003cmeta data-mint-head property=\"og:description\" content=\"Cloud Run orchestration between ephemeral NoSQL and persistent ACID ledgers.\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"PCMTG Project Bible\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://docs.pcm.game/architecture/dual-database-pipeline\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://pcmtg.mintlify.site/_mintlify/api/og/v2?division=IV.+Architecture\u0026amp;title=The+Dual-Database+Pipeline\u0026amp;description=Cloud+Run+orchestration+between+ephemeral+NoSQL+and+persistent+ACID+ledgers.\u0026amp;theme=4a87c928a4486e961517955b\u0026amp;signature=ae159055717ead2937b9fb890884cc23910cfae91ad7b424553dcad7bb254257\">\u003cmeta data-mint-head property=\"og:image:width\" content=\"1200\">\u003cmeta data-mint-head property=\"og:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"twitter:card\" content=\"summary_large_image\">\u003cmeta data-mint-head name=\"twitter:title\" content=\"The Dual-Database Pipeline - PCMTG Project Bible\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"Cloud Run orchestration between ephemeral NoSQL and persistent ACID ledgers.\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://pcmtg.mintlify.site/_mintlify/api/og/v2?division=IV.+Architecture\u0026amp;title=The+Dual-Database+Pipeline\u0026amp;description=Cloud+Run+orchestration+between+ephemeral+NoSQL+and+persistent+ACID+ledgers.\u0026amp;theme=4a87c928a4486e961517955b\u0026amp;signature=ae159055717ead2937b9fb890884cc23910cfae91ad7b424553dcad7bb254257\">\u003cmeta data-mint-head name=\"twitter:image:width\" content=\"1200\">\u003cmeta data-mint-head name=\"twitter:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"msapplication-config\" content=\"https://mintlify.s3.us-west-1.amazonaws.com/pcmtg/_generated/favicon/browserconfig.xml?v=3\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"PCMTG Project Bible\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#FF4500\">\u003clink data-mint-head rel=\"canonical\" href=\"https://docs.pcm.game/architecture/dual-database-pipeline\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/architecture/dual-database-pipeline.md\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://docs.pcm.game/#organization\",\"name\":\"PCMTG Project Bible\",\"url\":\"https://docs.pcm.game\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintlify.s3.us-west-1.amazonaws.com/pcmtg/logo/light.svg\"}},{\"@type\":\"WebSite\",\"@id\":\"https://docs.pcm.game#website\",\"name\":\"PCMTG Project Bible\",\"url\":\"https://docs.pcm.game\",\"publisher\":{\"@id\":\"https://docs.pcm.game/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://docs.pcm.game/architecture/dual-database-pipeline#webpage\",\"url\":\"https://docs.pcm.game/architecture/dual-database-pipeline\",\"name\":\"The Dual-Database Pipeline\",\"description\":\"Cloud Run orchestration between ephemeral NoSQL and persistent ACID ledgers.\",\"dateModified\":\"2026-05-26T05:11:42.788Z\",\"isPartOf\":{\"@id\":\"https://docs.pcm.game#website\"},\"breadcrumb\":{\"@id\":\"https://docs.pcm.game/architecture/dual-database-pipeline#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://docs.pcm.game/architecture/dual-database-pipeline#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"PCMTG Project Bible\",\"item\":\"https://docs.pcm.game\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The Dual-Database Pipeline\",\"item\":\"https://docs.pcm.game/architecture/dual-database-pipeline\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://docs.pcm.game/architecture/dual-database-pipeline#article\",\"headline\":\"The Dual-Database Pipeline\",\"name\":\"The Dual-Database Pipeline\",\"description\":\"Cloud Run orchestration between ephemeral NoSQL and persistent ACID ledgers.\",\"url\":\"https://docs.pcm.game/architecture/dual-database-pipeline\",\"mainEntityOfPage\":{\"@id\":\"https://docs.pcm.game/architecture/dual-database-pipeline#webpage\"},\"dateModified\":\"2026-05-26T05:11:42.788Z\",\"publisher\":{\"@id\":\"https://docs.pcm.game/#organization\"},\"isPartOf\":{\"@id\":\"https://docs.pcm.game#website\"}}]}\u003c/script>\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@type\":\"WebSite\",\"name\":\"PCMTG Project Bible\",\"publisher\":{\"@type\":\"Organization\",\"name\":\"PCMTG Project Bible\"},\"provider\":{\"@type\":\"Organization\",\"name\":\"Mintlify\",\"url\":\"https://mintlify.com\"}}\u003c/script>","agentPointerHref":"/architecture/dual-database-pipeline.md","siteName":"PCMTG Project Bible","nav":{"global":null,"groups":[{"group":"I. Executive Summary","pages":[{"title":"I. Executive Summary \u0026 Core Philosophy","href":"/introduction"},{"title":"II. Game Mechanics \u0026 The Core Loop","href":"/mechanics/core-loop"},{"title":"III. Cards, Progression \u0026 Euclidean ELO","href":"/mechanics/euclidean-elo"}]},{"group":"II. System Architecture","pages":[{"title":"IV. System Architecture \u0026 Infrastructure","href":"/architecture/gcp-topology"},{"title":"V. Database Strategy \u0026 Schemas","href":"/architecture/dual-database"},{"title":"VI. The Automated Content Factory","href":"/architecture/content-factory"},{"title":"VII. Operations \u0026 Security","href":"/architecture/operations"}]},{"group":"III. Roadmaps","pages":[{"title":"Sprint 10: Infinite Loops \u0026 Macro Visibility","href":"/sprint-10"},{"title":"Sprint 11: Progression \u0026 Ranked Play","href":"/sprint-11"},{"title":"Sprint 12: Stack \u0026 Shift Overhaul","href":"/sprint-12"},{"title":"Sprint 13: Core Hardening \u0026 Security","href":"/sprint-13"},{"title":"Sprint 14: Infrastructure Automation \u0026 The Autonomous Factory","href":"/sprint-14"},{"title":"Sprint 15: The Global Market \u0026 Gacha System","href":"/sprint-15"},{"title":"Sprint 16: The Pill Box \u0026 Grand Consensus","href":"/sprint-16"},{"title":"Sprint 17: Telemetry \u0026 Analytics","href":"/sprint-17"},{"title":"Sprint 18: The Crucible and the Cutover","href":"/sprint-18"},{"title":"Sprint 19: Identity Hydration \u0026 Precision Math","href":"/sprint-19"},{"title":"Sprint 20: The Shadow Logger \u0026 Diagnostic Observability","href":"/sprint-20"},{"title":"Sprint 21: Interactions API Integration","description":"Migrating the Python Content Factory to the GA Gemini Interactions API for background compute offloading.","href":"/sprint-21"}]},{"group":"IV. Architecture","pages":[{"title":"The Dual-Database Pipeline","href":"/architecture/dual-database-pipeline"},{"title":"The AI Content Factory","description":"Autonomous RSS ingestion and 3D coordinate mapping via Gemini.","href":"/architecture/ai-content-factory"}]},{"group":"V. Game Theory","pages":[{"title":"Euclidean Math \u0026 Combat","href":"/game-theory/euclidean-math"},{"title":"Macro-Economy \u0026 GIP","href":"/game-theory/economy-and-gip"}]},{"group":"VI. Sprint Artifacts","pages":[{"title":null,"href":"/walkthrough"},{"title":null,"href":"/implementation/sprint-15"},{"title":null,"href":"/implementation/implementation_plan_18.1"},{"title":null,"href":"/implementation/implementation_plan_18.2"},{"title":null,"href":"/implementation/sprint-20"}]}]},"basePath":"","title":"The Dual-Database Pipeline - PCMTG Project Bible","deploymentId":"dpl_FZMKUpaaKiVETbfqhoUe4sPFDTmY","buildId":"dpl_FZMKUpaaKiVETbfqhoUe4sPFDTmY","dynamics":[],"chunks":[]}