For the love of the game: a World Cup companion with on-chain betting and Snowflake-ready analytics

Short summary

A DEV Weekend Challenge submission building a FIFA World Cup 2026 companion app with two layered features: an on-chain parimutuel betting system using a Solana Anchor program in USDC, and a Snowflake-ready analytics pipeline prototyped locally with DuckDB. The author emphasizes architectural honesty—the Solana program is written and tested but not deployed to devnet, and the Snowflake target is validated via a local DuckDB ELT proof-of-concept rather than premature cloud provisioning. Key design choices include parimutuel odds (no house needed), fee-on-profit subscription tiers, and an append-only event log with idempotent deduplication designed for incremental warehouse loading.

• •World Cup companion app with Solana-based parimutuel betting in USDC and Snowflake-ready analytics
• •Analytics pipeline prototyped with DuckDB ELT before spending on cloud warehouse — append-only event log with star schema
• •Solana program written and tested but not yet deployed; author prioritizes honest architecture over fake demos

Generated with AI, which can make mistakes.