cli-8.30.0

🆕 Changelog

Added

• CLI manifest publishing — the CLI now writes manifest rows directly through the private API, making manifest updates faster and more reliable.
• queue_health monitoring endpoint — a new API endpoint for checking queue health is available, giving operators better visibility into background job status.

Fixed

• Billing period stats cron — restored the missing cron job and fixed the period calculation so billing statistics are generated on the correct schedule.
• Stats email calculations — corrected the math used in weekly, monthly, and 24-hour stats emails so reported numbers are accurate.

Changed

• Supabase schema & types — updated the Supabase schema and generated TypeScript types to match the latest database structure.

---

🔗 Full Changelog: cli-8.29.3...cli-8.30.0

cli-8.29.3

🆕 Changelog

Added

• Added Affonso affiliate tracking to Stripe Checkout.

Fixed

• Fixed CLI failures when adding apps while onboarding apps are pending.
• Ensured the "User needs onboarding" analytics event fires only once on first claim.
• Reduced PostHog event spam from the CLI and onboarding flows.
• Fixed Capgo releases to trigger when replica schema synchronization scripts change.
• Allowed Cloud SQL index imports to run outside of an atomic transaction.
• Removed a duplicate "events" key from the English localization file.
• Fixed manifest via a repair script.

Changed

• Removed flaky Cloudflare and Playwright test suites from CI.
• Enabled replica diagnostic SQL execution even when logging is denied.
• Added temporary Cloud SQL replica diagnostics.

---

🔗 Full Changelog: cli-8.29.2...cli-8.29.3

capgo-12.202.0

🆕 Changelog

Added

• Added affiliate tracking for Stripe Checkout via Affonso, enabling attribution of checkout conversions.

Fixed

• Ensured the "User need onboarding" analytics event is emitted only once on first claim, preventing duplicate tracking.
• Reduced PostHog event spam originating from CLI commands and onboarding flows.

Changed

• Removed flaky Cloudflare and Playwright test suites from CI to improve pipeline reliability.

---

🔗 Full Changelog: capgo-12.201.7...capgo-12.202.0

capgo-12.201.7

🆕 Changelog

Added

• Added temporary diagnostics for Cloud SQL replicas to help identify and resolve replication issues.

Fixed

• Fixed Cloud SQL replica index imports so they succeed when run outside of an atomic transaction.
• Fixed replica diagnostic SQL execution so it continues to work even when Cloud Logging access is denied.
• Fixed the release pipeline so a Capgo release is triggered when the replica schema synchronization script changes.

---

🔗 Full Changelog: capgo-12.201.6...capgo-12.201.7

cli-8.29.2

🆕 Changelog

Added

• Enforced limits on concurrent native builds and surfaced clear upgrade prompts when the cap is reached

Changed

• Improved plugin efficiency with a smaller bundle footprint, lower cold-start CPU usage, and faster benchmark performance

Fixed

• Restored accurate bandwidth totals on the organization dashboard by preventing PostgREST row limits from truncating statistics
• Blocked encrypted bundles from being offered as ZIP downloads in preview channels
• Made the Capgo-EU reclaim operation safe to run directly from the SQL Editor
• Hardened queue cleanup so missing pgmq tables are skipped instead of causing failures

---

🔗 Full Changelog: cli-8.29.1...cli-8.29.2

cli-8.29.1

🆕 Changelog

Added

• Added updated_at filtering and sorting to the GET /device API endpoint, making it easier to find recently updated devices.
• Introduced Bento email notifications for plan version block upgrades and downgrades.
• Added an above-plan total card and need-upgrade indicator to the admin trend chart so capacity issues are visible at a glance.

Changed

• Migrated the CLI validation layer from Zod to ArkType for more robust validation and clearer error feedback.
• Improved deletion performance by reclaiming deleted manifests in bulk instead of removing them row by row.
• Upgraded workspace and npm dependencies to their latest compatible versions.

Fixed

• Fixed missing app_versions_manifest_present_idx index by placing it in the correct database migration.
• Excluded the manifest_present index from replicas where only primary nodes benefit from it.
• Strengthened deleted-version cleanup so R2 trash files are removed before corresponding database records are deleted.
• Reduced Capgo-EU database swap pressure without requiring an upgrade.
• Fixed admin analytics to count only paid upgrades to larger plans.
• Isolated CI visual diff captures to prevent cross-test contamination.

---

🔗 Full Changelog: cli-8.29.0...cli-8.29.1

cli-8.29.0

🆕 Changelog

Added

• Added a new admin metric to track 12-month plan upgrade rates, making it easier to spot trends in long-term subscription adoption.
• Expanded /data analytics with breakdowns by country, platform, and application version, so you can segment usage and issues across regions, devices, and releases.

Fixed

• Reduced noisy PostHog console errors in the frontend for a cleaner browser experience.
• Rerouted on_version_update events through Cloudflare and shrank payload sizes to improve delivery reliability and reduce bandwidth.

---

🔗 Full Changelog: cli-8.28.2...cli-8.29.0

capgo-12.201.3

🆕 Changelog

Changed

• Switched the CLI validation engine from Zod to ArkType across all commands and utilities. This modernizes type checking and may improve validation accuracy, but the format and wording of validation errors could differ.
• Breaking: If your scripts, CI checks, or third-party plugins rely on Zod-specific schema behavior or error-message formats when interacting with the CLI, revise them for ArkType-compatible behavior. No command syntax changes are required for normal CLI usage.

---

🔗 Full Changelog: capgo-12.201.2...capgo-12.201.3

capgo-12.201.0

🆕 Changelog

Added

• Device API filtering and sorting — Added updated_at filter and sort options to GET /device, making it easier to locate recently updated devices and build time-ordered device lists.

Changed

• Supabase schema and type synchronization — Updated the Supabase schema and regenerated internal types to stay in sync with the latest database structure.

Fixed

• Admin plan upgrade counting — Fixed upgrade counting so only paying upgrades to larger plans are included, improving the accuracy of billing and plan analytics.

---

🔗 Full Changelog: cli-8.29.0...capgo-12.201.0

capgo-12.200.0

🆕 Changelog

Added

• Added the ability for admins to track the 12-month plan upgrade rate, providing visibility into how many users are upgrading to annual subscriptions.

Changed

• Internal release and dependency alignment changes as part of the 12.200.0 release.

---

🔗 Full Changelog: capgo-12.199.6...capgo-12.200.0