<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:dc="http://purl.org/dc/elements/1.1/">
  <channel>
    <title>Forem: Juan Camilo Chacón A</title>
    <description>The latest articles on Forem by Juan Camilo Chacón A (@rastipunk).</description>
    <link>https://forem.com/rastipunk</link>
    <image>
      <url>https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F3785624%2F6d0747e8-e515-4e33-8dfb-ea4c3452933d.jpg</url>
      <title>Forem: Juan Camilo Chacón A</title>
      <link>https://forem.com/rastipunk</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://forem.com/feed/rastipunk"/>
    <language>en</language>
    <item>
      <title>I built a free football prediction platform for World Cup 2026 — here's the stack</title>
      <dc:creator>Juan Camilo Chacón A</dc:creator>
      <pubDate>Mon, 23 Feb 2026 00:39:15 +0000</pubDate>
      <link>https://forem.com/rastipunk/i-built-a-free-football-prediction-platform-for-world-cup-2026-heres-the-stack-nhk</link>
      <guid>https://forem.com/rastipunk/i-built-a-free-football-prediction-platform-for-world-cup-2026-heres-the-stack-nhk</guid>
      <description>&lt;p&gt;With the FIFA World Cup 2026 just months away, I wanted to build something my friends and I could actually use — a platform to create prediction pools (known as &lt;em&gt;quiniela&lt;/em&gt; in Mexico, &lt;em&gt;polla&lt;/em&gt; in Colombia, &lt;em&gt;prode&lt;/em&gt; in Argentina, or &lt;em&gt;penca&lt;/em&gt; in Uruguay).&lt;/p&gt;

&lt;p&gt;The result is &lt;strong&gt;&lt;a href="https://picks4all.com" rel="noopener noreferrer"&gt;Picks4All&lt;/a&gt;&lt;/strong&gt; — a free, open platform where you can create a pool, invite friends with a code, predict match scores, and compete on a live leaderboard.&lt;/p&gt;

&lt;p&gt;Here's how I built it and what I learned along the way.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F4l63zfis15vnh16wfrfp.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F4l63zfis15vnh16wfrfp.png" alt="Landing page" width="800" height="578"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;h2&gt;
  
  
  The Stack
&lt;/h2&gt;

&lt;div class="table-wrapper-paragraph"&gt;&lt;table&gt;
&lt;thead&gt;
&lt;tr&gt;
&lt;th&gt;Layer&lt;/th&gt;
&lt;th&gt;Technology&lt;/th&gt;
&lt;/tr&gt;
&lt;/thead&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td&gt;Frontend&lt;/td&gt;
&lt;td&gt;Next.js 16 (App Router), React 19, TypeScript&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Backend&lt;/td&gt;
&lt;td&gt;Node.js 22, Express, TypeScript&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Database&lt;/td&gt;
&lt;td&gt;PostgreSQL 16, Prisma ORM&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Auth&lt;/td&gt;
&lt;td&gt;JWT + Google Sign-In&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;i18n&lt;/td&gt;
&lt;td&gt;next-intl (ES/EN/PT)&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Email&lt;/td&gt;
&lt;td&gt;Resend&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Deployment&lt;/td&gt;
&lt;td&gt;Railway&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;&lt;/div&gt;

&lt;p&gt;I chose a &lt;strong&gt;monorepo&lt;/strong&gt; with a clear separation: &lt;code&gt;backend/&lt;/code&gt; for the Express API and &lt;code&gt;frontend-next/&lt;/code&gt; for the Next.js app. Both are TypeScript end-to-end.&lt;/p&gt;

&lt;h2&gt;
  
  
  Key Architecture Decisions
&lt;/h2&gt;

&lt;h3&gt;
  
  
  Template → Instance → Pool
&lt;/h3&gt;

&lt;p&gt;The most important design decision was the data model. Instead of hardcoding tournaments, I built a &lt;strong&gt;template system&lt;/strong&gt;:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Template&lt;/strong&gt;: defines the tournament structure (teams, groups, phases, matches)&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Instance&lt;/strong&gt;: a playable edition of a template (e.g., "Champions League 2025-26")&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Pool&lt;/strong&gt;: a group of friends competing on an instance with their own scoring rules&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;This means adding a new tournament is just creating a new template — no code changes needed.&lt;/p&gt;

&lt;h3&gt;
  
  
  Smart Sync — Automatic Score Updates
&lt;/h3&gt;

&lt;p&gt;Nobody wants to manually enter scores for 64 matches. I integrated with &lt;strong&gt;API-Football&lt;/strong&gt; to build a "Smart Sync" system:&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;A cron job checks for live/finished matches every minute&lt;/li&gt;
&lt;li&gt;When a match finishes, it fetches the score and publishes the result&lt;/li&gt;
&lt;li&gt;The leaderboard updates automatically&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;The tricky part was handling edge cases: delayed matches, score corrections, and rate limits on the free API tier (100 requests/day).&lt;/p&gt;

&lt;h3&gt;
  
  
  i18n with next-intl
&lt;/h3&gt;

&lt;p&gt;The app supports Spanish, English, and Portuguese. I used &lt;a href="https://next-intl.dev/" rel="noopener noreferrer"&gt;next-intl v4&lt;/a&gt; with a &lt;code&gt;localePrefix: 'as-needed'&lt;/code&gt; strategy:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;code&gt;picks4all.com/&lt;/code&gt; → Spanish (default, no prefix)&lt;/li&gt;
&lt;li&gt;
&lt;code&gt;picks4all.com/en/&lt;/code&gt; → English&lt;/li&gt;
&lt;li&gt;
&lt;code&gt;picks4all.com/pt/&lt;/code&gt; → Portuguese&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Each locale has its own SEO metadata, JSON-LD structured data, Open Graph images, and sitemap entries. This was more work than I expected, but it's essential for reaching users across Latin America, Spain, Brazil, and English-speaking countries.&lt;/p&gt;

&lt;h2&gt;
  
  
  What the App Looks Like
&lt;/h2&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fghlmwmkvu4znq78h7j74.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fghlmwmkvu4znq78h7j74.png" alt="Pool page with matches and predictions" width="800" height="590"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;Inside a pool you can:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Browse matches by phase (group stage, round of 16, etc.)&lt;/li&gt;
&lt;li&gt;Submit your score predictions before the deadline&lt;/li&gt;
&lt;li&gt;See official results with scoring breakdowns&lt;/li&gt;
&lt;li&gt;Track your position on the leaderboard&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Deployment
&lt;/h2&gt;

&lt;p&gt;Everything runs on &lt;strong&gt;Railway&lt;/strong&gt; — three services:&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;
&lt;strong&gt;Backend&lt;/strong&gt; (Express API)&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Frontend&lt;/strong&gt; (Next.js standalone)&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;PostgreSQL&lt;/strong&gt; database&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;DNS is on Cloudflare, pointing &lt;code&gt;picks4all.com&lt;/code&gt; to the frontend and &lt;code&gt;api.picks4all.com&lt;/code&gt; to the backend. Total cost is under $10/month.&lt;/p&gt;

&lt;h2&gt;
  
  
  Lessons Learned
&lt;/h2&gt;

&lt;ol&gt;
&lt;li&gt;&lt;p&gt;&lt;strong&gt;Start with the data model.&lt;/strong&gt; I spent more time on the template/instance/pool schema than on any UI component, and it paid off — adding Champions League after World Cup took hours, not days.&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;&lt;strong&gt;i18n is never "just translations."&lt;/strong&gt; It touches routing, SEO, metadata, legal pages, URL structure, and even date formatting. Plan for it early or pay the price later.&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;&lt;strong&gt;Rate limits are a feature, not a bug.&lt;/strong&gt; The API-Football free tier forced me to build a smarter sync system — checking only active matches, batching requests, caching results. The paid tier would have let me be lazy.&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;&lt;strong&gt;Ship early, iterate with real users.&lt;/strong&gt; My friends found UX issues in the first 10 minutes that I never would have caught alone.&lt;/p&gt;&lt;/li&gt;
&lt;/ol&gt;

&lt;h2&gt;
  
  
  Try It / Check the Code
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Live app&lt;/strong&gt;: &lt;a href="https://picks4all.com" rel="noopener noreferrer"&gt;picks4all.com&lt;/a&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Source code&lt;/strong&gt;: &lt;a href="https://github.com/Rastipunk/Quiniela-Platform" rel="noopener noreferrer"&gt;github.com/Rastipunk/Quiniela-Platform&lt;/a&gt;
&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;World Cup 2026 is coming. If you've ever organized a quiniela on a spreadsheet, give this a try. It's free, no ads, no gambling — just friendly competition.&lt;/p&gt;




&lt;p&gt;Questions about the architecture or stack? Drop a comment — happy to go deeper on any part of it.&lt;/p&gt;

</description>
      <category>nextjs</category>
      <category>typescript</category>
      <category>webdev</category>
      <category>footbal</category>
    </item>
  </channel>
</rss>
