<?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>DEV Community: LapScore</title>
    <description>The latest articles on DEV Community by LapScore (@lapscore).</description>
    <link>https://dev.to/lapscore</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%2F3900037%2F86747297-c767-40ff-8ec3-bb78192a5fe9.png</url>
      <title>DEV Community: LapScore</title>
      <link>https://dev.to/lapscore</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/lapscore"/>
    <language>en</language>
    <item>
      <title>How I Built a 10-Language Sports Analytics Platform with FastAPI, SQLite, and Claude AI (As a Solo Non-Technical Founder)</title>
      <dc:creator>LapScore</dc:creator>
      <pubDate>Mon, 27 Apr 2026 08:54:43 +0000</pubDate>
      <link>https://dev.to/lapscore/how-i-built-a-10-language-sports-analytics-platform-with-fastapi-sqlite-and-claude-ai-as-a-solo-3gob</link>
      <guid>https://dev.to/lapscore/how-i-built-a-10-language-sports-analytics-platform-with-fastapi-sqlite-and-claude-ai-as-a-solo-3gob</guid>
      <description>&lt;p&gt;I'm a solo founder with &lt;strong&gt;zero formal coding background&lt;/strong&gt;. Yet, I built &lt;a href="https://lapscore.com" rel="noopener noreferrer"&gt;LapScore&lt;/a&gt; — a free sports analytics platform tracking 14,000+ daily matches in 10 languages — in about 3 weeks using Claude AI as my primary development tool.&lt;/p&gt;

&lt;p&gt;This post is a transparent technical breakdown of the stack, key decisions, and surprising lessons.&lt;/p&gt;

&lt;h2&gt;
  
  
  The Stack (Simpler Than You'd Think)Backend:    FastAPI (Python)
&lt;/h2&gt;

&lt;p&gt;Database:   SQLite (WAL mode)&lt;br&gt;
Templates:  Jinja2 + lightweight SPA&lt;br&gt;
Server:     Vultr VPS (Seoul)&lt;br&gt;
AI:         Anthropic Claude&lt;br&gt;
Sports API: api-sports.io&lt;/p&gt;

&lt;p&gt;That's it. No Postgres, no Redis, no microservices, no Kubernetes. One Python process serving 14K+ matches across 122,170 SEO pages.&lt;/p&gt;
&lt;h2&gt;
  
  
  Why FastAPI + SQLite (and not Postgres)?
&lt;/h2&gt;

&lt;p&gt;The "scale at all costs" advice is mostly wrong for early-stage products.&lt;/p&gt;

&lt;p&gt;SQLite with WAL mode handles:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;14,358 daily match records&lt;/li&gt;
&lt;li&gt;122,170 server-rendered SEO pages&lt;/li&gt;
&lt;li&gt;Concurrent reads (essentially unlimited)&lt;/li&gt;
&lt;li&gt;Background jobs writing every minute&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Single-file backups. No connection pool config. No "is the database down?" panics.&lt;/p&gt;

&lt;p&gt;When LapScore actually needs Postgres (10K concurrent writes), I'll know. Until then, SQLite is a feature, not a limitation.&lt;/p&gt;
&lt;h2&gt;
  
  
  The Background Scheduler That Almost Broke
&lt;/h2&gt;

&lt;p&gt;LapScore generates predictions twice daily via APScheduler:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;_scheduled_lappick_morning,
'cron', hour=1, minute=0, id='lappick_morning'  # KST 10:00
)
scheduler.add_job(
_scheduled_lappick_evening,
'cron', hour=13, minute=0, id='lappick_evening'  # KST 22:00
)

Yesterday I noticed today's picks were missing. Diagnosis revealed the morning function had:

&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;

&lt;p&gt;&lt;br&gt;
pythonBug&lt;br&gt;
await generate_daily_lappick(hours_ahead=0, max_picks=3, job_name="morning")Fix (added hours_ahead_min=2)&lt;br&gt;
await generate_daily_lappick(hours_ahead=0, max_picks=3,&lt;br&gt;
job_name="morning", hours_ahead_min=2)&lt;/p&gt;

&lt;p&gt;Default &lt;code&gt;hours_ahead_min=4&lt;/code&gt; meant "only consider matches starting 4+ hours from now." On a slow match day, every match got skipped.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Lesson&lt;/strong&gt;: Default parameters in shared functions are silent bombs.&lt;/p&gt;

&lt;h2&gt;
  
  
  SEO: 122K Pages Without Writing 122K Pages
&lt;/h2&gt;

&lt;p&gt;I generate one Jinja2 template, then render it for every match × every language:/match/lazio-vs-udinese-serie-a-1234              (English)&lt;br&gt;
/match/lazio-vs-udinese-serie-a-1234?lang=de      (German)&lt;br&gt;
/match/lazio-vs-udinese-serie-a-1234?lang=pt      (Portuguese)&lt;br&gt;
... × 10 languages&lt;/p&gt;

&lt;p&gt;Combined with proper &lt;code&gt;hreflang&lt;/code&gt; tags and a 12,437-URL sitemap submitted to Google Search Console, this beats trying to compete for "livescore" (DR 90+ giants own that SERP).&lt;/p&gt;

&lt;p&gt;Long-tail wins.&lt;/p&gt;

&lt;h2&gt;
  
  
  The LAP Prediction System
&lt;/h2&gt;

&lt;p&gt;LAP picks are tracked publicly with a virtual $1,000 bankroll:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Started: 2026-04-22&lt;/li&gt;
&lt;li&gt;Current: $1,103.72 (+10.37% ROI)&lt;/li&gt;
&lt;li&gt;Win rate: 60% (15/25)&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Every pick. Every result. No deletions.&lt;/p&gt;

&lt;p&gt;The Claude API analyzes 50-100 daily matches, looks for &lt;strong&gt;edge &amp;gt;8%&lt;/strong&gt;, and publishes only when confident. Some days produce 6 picks, some days produce 2. That's the point.&lt;/p&gt;

&lt;h2&gt;
  
  
  What Working with Claude Actually Looks Like
&lt;/h2&gt;

&lt;p&gt;I don't write code. I describe what I want, paste errors, paste logs, and iterate.&lt;/p&gt;

&lt;p&gt;A typical exchange:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Me: "The morning picks didn't generate today. Here's the log: [paste]"&lt;/li&gt;
&lt;li&gt;Claude: "The &lt;code&gt;hours_ahead_min=4&lt;/code&gt; default is filtering out everything. Fix: [code]"&lt;/li&gt;
&lt;li&gt;Me: I SSH in, paste the fix, verify, redeploy.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;This works because:&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;
&lt;strong&gt;I know my product cold&lt;/strong&gt; (what should happen, what shouldn't)&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;I can read code&lt;/strong&gt; even though I can't write it from scratch&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;I keep extensive backups&lt;/strong&gt; (&lt;code&gt;*.bak_YYYYMMDD_HHMMSS&lt;/code&gt; for every change)&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;Non-technical doesn't mean &lt;strong&gt;uninvolved&lt;/strong&gt;. It means I trade syntax knowledge for product clarity.&lt;/p&gt;

&lt;h2&gt;
  
  
  The Real Multipliers
&lt;/h2&gt;

&lt;p&gt;After 3 weeks of building, the things that mattered most weren't technical:&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;
&lt;strong&gt;Public bankroll tracking&lt;/strong&gt; — radical transparency beats marketing claims&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;10 languages from day one&lt;/strong&gt; — most sports sites are English-only or single-locale&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Free, no signup&lt;/strong&gt; — friction kills adoption faster than bad UX&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Long-tail SEO&lt;/strong&gt; — 122K pages of low-competition match content&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;The stack barely matters. The decisions around it do.&lt;/p&gt;




&lt;h2&gt;
  
  
  Try It
&lt;/h2&gt;

&lt;p&gt;&lt;a href="https://lapscore.com" rel="noopener noreferrer"&gt;LapScore&lt;/a&gt; — Free sports scores and predictions in 10 languages.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://lapscore.com/lappick" rel="noopener noreferrer"&gt;LAP Pick Bankroll&lt;/a&gt; — Public ROI tracker.&lt;/p&gt;

&lt;p&gt;If you're a solo founder building something with AI assistance, I'd love to hear what stack you're using. Drop a comment.&lt;/p&gt;

</description>
      <category>fastapi</category>
      <category>sqlite</category>
      <category>ai</category>
      <category>buildinpublic</category>
    </item>
  </channel>
</rss>
