Cap-go
diff --git a/‎.gitignore‎
Lines changed: 1 addition & 0 deletions b/‎.gitignore‎
Lines changed: 1 addition & 0 deletions
diff --git a/‎.gitsecret/paths/mapping.cfg‎
Lines changed: 3 additions & 2 deletions b/‎.gitsecret/paths/mapping.cfg‎
Lines changed: 3 additions & 2 deletions
diff --git a/‎AGENTS.md‎
Lines changed: 19 additions & 0 deletions b/‎AGENTS.md‎
Lines changed: 19 additions & 0 deletions
diff --git a/‎cloudflare_workers/api/index.ts‎
Lines changed: 0 additions & 4 deletions b/‎cloudflare_workers/api/index.ts‎
Lines changed: 0 additions & 4 deletions
diff --git a/‎internal/AuthKey_8P7Y3V99PJ.p8.secret‎
-1 Bytes b/‎internal/AuthKey_8P7Y3V99PJ.p8.secret‎
-1 Bytes
diff --git a/‎internal/CICD.mobileprovision.secret‎
-1 Bytes b/‎internal/CICD.mobileprovision.secret‎
-1 Bytes
diff --git a/‎internal/Certificates.p12.secret‎
4.15 KB b/‎internal/Certificates.p12.secret‎
4.15 KB
diff --git a/‎internal/Certificates_p12.p12.secret‎
-1 Bytes b/‎internal/Certificates_p12.p12.secret‎
-1 Bytes
diff --git a/‎internal/capgo-394818-68ad1517d330.json.secret‎
-2 Bytes b/‎internal/capgo-394818-68ad1517d330.json.secret‎
-2 Bytes
diff --git a/‎internal/cloudflare/.env.local.secret‎
-2 Bytes b/‎internal/cloudflare/.env.local.secret‎
-2 Bytes
@@ -84,3 +84,4 @@ internal/capgo-394818-68ad1517d330.json
 internal/Certificates_p12.p12
 internal/AuthKey_8P7Y3V99PJ.p8
 internal/CICD.mobileprovision
+internal/Certificates.p12
@@ -1,11 +1,12 @@
 internal/how-to-deploy.md:84fb650102327a9a40e845ffe90c9f2e4ab21bdbacee13279fc420bf6a7ddf6a
 internal/supabase/.env.local:4045b99d44963589c422b460a9c9d029a57b6714905440d5d43fd97eff4a5adb
 internal/cloudflare/.env.local:df3e28094bb5cea2dbf71368cef66238af8d6c9631fd617fd9c14bd884826138
-internal/cloudflare/.env.preprod:1c35d6b06c0acd532fdb14fe1c781a42a62fd2c2968edd1ae02ea8fedc8bb30c
-internal/cloudflare/.env.prod:97a1d85b187f681ea25b70d4d5a4752fe0952bdc55c56e62b7200fd659a3dd8b
+internal/cloudflare/.env.preprod:725dd8bb110bbb401e552d4d6b5f7b738261b9af33408aa8658c5c3508275ff1
+internal/cloudflare/.env.prod:d0217460b1ea767ae1e94f7cf82cdfec32970819f35e226f4b4266ba1c543b81
 internal/forgr-key.jks:92f8d5f1e532a1d9d6359a142ff922ad2f835f90cfae004222ab2a5cd17fa999
 internal/forgr-key.jks.base64:0bc27503ed4b743318ac93186a3d731f5326d1e12ea9d50402b8b36bc3efec9e
 internal/capgo-394818-68ad1517d330.json:de826cfbdcf7412174ff8b14f82635edf2c67ceb7d14928d8cb9067538155fa2
 internal/Certificates_p12.p12:eff5bb704d17324573425e6dad6414abe9efa2289aa5b7707e2c5b0a946b5b6e
 internal/AuthKey_8P7Y3V99PJ.p8:f681dfcfd467ec885ccbdf49e0a6dda4ecbd8aa670eb5c3465c589b7464bcb27
 internal/CICD.mobileprovision:e608d28663532adf960152fa8e8a89c4cc38d96ca17b71dcf4a77db8c4228583
+internal/Certificates.p12:12be19e51e498b5fece8f85c02b84ff9f66bd54acf79ecfc4247690bd124d84d
@@ -41,3 +41,22 @@
 - Cover customer-facing flows with the Playwright MCP suite. Add scenarios under
   `playwright/e2e` and run them locally with `bun run test:front` before
   shipping UI changes.
+
+## Database replication
+
+Our main database is hosted on Supabase. We use custom replice hosted in Planet
+scale
+
+We have 5 read replicas for our main database to ensure high availability and
+low latency for read operations. These replicas are synchronized with the
+primary database using logical replication. We have one replicate by continent:
+
+- North America (Ohio)
+- Europe (Frankfurt)
+- Asia (Seoul)
+- Australia (Sydney)
+- South America (Sao Paulo) Applications are configured to read from the nearest
+  replica based on the user's
+
+This repartition is done by Cloudflare snippets
+cloudflare_workers/snippet/index.js
@@ -23,8 +23,6 @@ import { app as ok } from '../../supabase/functions/_backend/public/ok.ts'
 import { app as organization } from '../../supabase/functions/_backend/public/organization/index.ts'
 import { app as replication } from '../../supabase/functions/_backend/public/replication.ts'
 import { app as statistics } from '../../supabase/functions/_backend/public/statistics/index.ts'
-import { app as clear_app_cache } from '../../supabase/functions/_backend/triggers/clear_app_cache.ts'
-import { app as clear_device_cache } from '../../supabase/functions/_backend/triggers/clear_device_cache.ts'
 import { app as cron_clear_versions } from '../../supabase/functions/_backend/triggers/cron_clear_versions.ts'
 import { app as cron_email } from '../../supabase/functions/_backend/triggers/cron_email.ts'
 import { app as cron_stat_app } from '../../supabase/functions/_backend/triggers/cron_stat_app.ts'
@@ -82,8 +80,6 @@ appPrivate.route('/events', events)
 // Triggers
 const functionNameTriggers = 'triggers'
 const appTriggers = createHono(functionNameTriggers, version)
-appTriggers.route('/clear_app_cache', clear_app_cache)
-appTriggers.route('/clear_device_cache', clear_device_cache)
 appTriggers.route('/cron_email', cron_email)
 appTriggers.route('/cron_clear_versions', cron_clear_versions)
 appTriggers.route('/logsnag_insights', logsnag_insights)