<?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: Shakro Abramishvili</title>
    <description>The latest articles on DEV Community by Shakro Abramishvili (@sonsaur).</description>
    <link>https://dev.to/sonsaur</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%2F3863513%2F03413c49-bcc2-4378-aca9-cdf4de81fd11.png</url>
      <title>DEV Community: Shakro Abramishvili</title>
      <link>https://dev.to/sonsaur</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/sonsaur"/>
    <language>en</language>
    <item>
      <title>How We Built a Gaming Portal with 8,000+ Games Using Next.js and 38-Language Translation</title>
      <dc:creator>Shakro Abramishvili</dc:creator>
      <pubDate>Mon, 06 Apr 2026 08:56:20 +0000</pubDate>
      <link>https://dev.to/sonsaur/how-we-built-a-gaming-portal-with-8000-games-using-nextjs-and-38-language-translation-b18</link>
      <guid>https://dev.to/sonsaur/how-we-built-a-gaming-portal-with-8000-games-using-nextjs-and-38-language-translation-b18</guid>
      <description>&lt;p&gt;We recently relaunched Sonsaur.com, a free browser gaming portal with over 8,000 games. Here's the tech stack and interesting challenges we solved.&lt;/p&gt;

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

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Framework&lt;/strong&gt;: Next.js 16 with App Router&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Database&lt;/strong&gt;: Neon PostgreSQL with Prisma 7 ORM&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Hosting&lt;/strong&gt;: DigitalOcean VPS + Cloudflare CDN&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Image CDN&lt;/strong&gt;: Custom nginx-based CDN (img.sonsaur.com) serving pre-resized AVIF thumbnails&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Search&lt;/strong&gt;: PostgreSQL trigram indexes (pg_trgm) for fuzzy game search&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;AI Translation&lt;/strong&gt;: Gemini API with 60-key rotation for rate limit management&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Process Manager&lt;/strong&gt;: PM2 with auto-restart and memory limits&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  The Image CDN Challenge
&lt;/h2&gt;

&lt;p&gt;With 8,000+ games, each needing thumbnails, image optimization was critical. We built a custom image pipeline:&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;Original images stored as AVIF at 512px&lt;/li&gt;
&lt;li&gt;Pre-resized to 128px (~6KB) and 256px (~13KB) variants&lt;/li&gt;
&lt;li&gt;Served via dedicated nginx subdomain (img.sonsaur.com)&lt;/li&gt;
&lt;li&gt;Zero-JavaScript image components (plain `` tags for zero hydration cost)&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;Result: 84% reduction in image payload for game cards.&lt;/p&gt;

&lt;h2&gt;
  
  
  Translating 8,000 Games into 38 Languages
&lt;/h2&gt;

&lt;p&gt;This was the most interesting challenge. We needed to translate not just the UI (which is straightforward with next-intl) but also game-specific content: descriptions, how-to-play guides, tips, and FAQs.&lt;/p&gt;

&lt;p&gt;Our approach:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;60 Gemini API keys distributed across multiple projects&lt;/li&gt;
&lt;li&gt;Cron job running every 2 minutes, processing 60 games per batch (1 per key)&lt;/li&gt;
&lt;li&gt;Sequential processing to prevent Node.js streaming crashes&lt;/li&gt;
&lt;li&gt;2-minute key cooldown with 10-minute pause when all keys are exhausted&lt;/li&gt;
&lt;li&gt;Tier 1 rate limits: 1,500 requests per day per key per project&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;At full capacity, we translate ~43,200 game pages per day across all languages.&lt;/p&gt;

&lt;h2&gt;
  
  
  Performance Results
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;Lighthouse: Performance 79, Accessibility 93, Best Practices 100, SEO 100&lt;/li&gt;
&lt;li&gt;First game load: under 3 seconds&lt;/li&gt;
&lt;li&gt;Subsequent navigations: near-instant (Next.js prefetching)&lt;/li&gt;
&lt;li&gt;Image CDN: 128px thumbnails average 6KB (vs 34KB originals)&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  What's Next
&lt;/h2&gt;

&lt;p&gt;We're working on native Android and iOS apps, completing full translation coverage for all 38 languages, and continuously adding new games to the library.&lt;/p&gt;

&lt;p&gt;Check it out: &lt;a href="https://sonsaur.com" rel="noopener noreferrer"&gt;sonsaur.com&lt;/a&gt;&lt;/p&gt;




&lt;p&gt;Happy to answer questions about any part of the stack. The combination of Next.js + Neon PostgreSQL + custom image CDN has been great for this use case.&lt;/p&gt;

</description>
      <category>nextjs</category>
      <category>gamedev</category>
      <category>javascript</category>
      <category>dotnet</category>
    </item>
  </channel>
</rss>
