<?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: Can Goktug Ozdem</title>
    <description>The latest articles on DEV Community by Can Goktug Ozdem (@cgozdemm).</description>
    <link>https://dev.to/cgozdemm</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%2F3890443%2Fb28b6f7d-f78f-4a3f-b95d-754d73e43ef0.png</url>
      <title>DEV Community: Can Goktug Ozdem</title>
      <link>https://dev.to/cgozdemm</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/cgozdemm"/>
    <language>en</language>
    <item>
      <title>I built a browser-only SQL practice tool because installing DBeaver is a productivity tax</title>
      <dc:creator>Can Goktug Ozdem</dc:creator>
      <pubDate>Thu, 23 Apr 2026 09:41:55 +0000</pubDate>
      <link>https://dev.to/cgozdemm/i-built-a-browser-only-sql-practice-tool-because-installing-dbeaver-is-a-productivity-tax-310b</link>
      <guid>https://dev.to/cgozdemm/i-built-a-browser-only-sql-practice-tool-because-installing-dbeaver-is-a-productivity-tax-310b</guid>
      <description>&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%2Fsnbx0v3p9c99nrjp7qxe.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%2Fsnbx0v3p9c99nrjp7qxe.png" alt="SQL Quest landing page banner — adaptive SQL tutor that picks your next challenge from your skill radar" width="800" height="420"&gt;&lt;/a&gt;Recently, I was tutoring data analysts through Preply when I noticed something weird.&lt;/p&gt;

&lt;p&gt;Every single student — regardless of whether they were prepping for an Amazon interview, a Snowflake analyst role, or just trying to level up at work — asked me the same two questions in their first session:&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;"Where should I practice SQL?"&lt;/li&gt;
&lt;li&gt;"Do I need to install a database?"&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;These were not beginners. Many of them were already senior BI analysts making $120-180k. They wrote SQL all day in Snowflake or BigQuery. They had interviews coming up. They just needed a clean, ready-to-go place to rehearse window functions, CTEs, and recursive queries without burning 4 hours on infrastructure.&lt;/p&gt;

&lt;p&gt;So I'd walk them through installing Postgres. Or setting up DBeaver. Or loading the Chinook dataset. Every time, the setup alone consumed the entire first tutoring session.&lt;/p&gt;

&lt;p&gt;I started thinking: this is absurd. These people earn more per hour than any bootcamp charges. Why is the lowest-friction path to SQL practice still "install a database locally"?&lt;/p&gt;

&lt;h2&gt;
  
  
  The options that exist today
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;LeetCode SQL&lt;/strong&gt; — limited, feels like 2012&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;HackerRank SQL&lt;/strong&gt; — ditto&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;DataLemur&lt;/strong&gt; — great but paywalled for the meaningful content&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Mode Analytics tutorial&lt;/strong&gt; — stops after the basics&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Your own local Postgres&lt;/strong&gt; — free, but the setup tax is real&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Snowflake free trial&lt;/strong&gt; — 30 days, then you lose your data&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;None of them felt like "open the browser, click challenge, write SQL, get feedback."&lt;/p&gt;

&lt;h2&gt;
  
  
  What I built
&lt;/h2&gt;

&lt;p&gt;&lt;a href="https://sqlquest.app" rel="noopener noreferrer"&gt;SQL Quest&lt;/a&gt;. Browser-only. 126 SQL challenges spanning Easy → Hard. 5 pre-loaded sample databases (e-commerce, HR, movies, Titanic, customer segments). No setup. No signup to start.&lt;/p&gt;

&lt;p&gt;Under the hood:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;SQLite-wasm runs queries client-side — no server round-trip&lt;/li&gt;
&lt;li&gt;Challenges tagged by the companies that ask similar patterns (Amazon, Google, Meta, Stripe, Snowflake, etc.)&lt;/li&gt;
&lt;li&gt;An adaptive coach picks your next challenge based on a 10-skill radar&lt;/li&gt;
&lt;li&gt;Anthropic's Claude powers the in-app AI tutor for hints&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Three lessons from the last month
&lt;/h2&gt;

&lt;h3&gt;
  
  
  1. Landing pages that over-promise are silent killers
&lt;/h3&gt;

&lt;p&gt;My &lt;code&gt;/amazon-sql-interview/&lt;/code&gt; page had an 82% bounce rate. I opened it in incognito, clicked "Practice Amazon Questions" — and landed in a generic 125-item challenge list with zero Amazon framing. Textbook bait-and-switch, written entirely by accident.&lt;/p&gt;

&lt;p&gt;Fixed it by (a) tagging every challenge by which companies ask similar patterns, (b) routing CTAs to pre-filtered views, and (c) adding company-specific scenario copy to the top 15 most-visible challenges across Amazon, Google, and Meta.&lt;/p&gt;

&lt;p&gt;If your landing page promises something specific, the app has to deliver it within 5 seconds of the CTA click. No "welcome tour" in between.&lt;/p&gt;

&lt;h3&gt;
  
  
  2. Mobile is where your trust fixes silently break
&lt;/h3&gt;

&lt;p&gt;54% of traffic is mobile. After shipping the desktop trust fix, I audited the filtered-view flow on an iPhone emulator and found a second bait-and-switch: new mobile users hit a personalization modal that blocked the filtered list, then got dumped into a beginner tutorial on challenge #91 "Your First Query."&lt;/p&gt;

&lt;p&gt;So for 54% of traffic, the fix I was so proud of never shipped. I gated the onboarding flow on URL params (&lt;code&gt;?company=X&lt;/code&gt;) so landing-page visitors skip it entirely.&lt;/p&gt;

&lt;p&gt;The lesson: shipping a mobile-aware fix isn't optional if half your traffic is mobile. Your emulator is not optional either.&lt;/p&gt;

&lt;h3&gt;
  
  
  3. Scenario copy matters as much as SQL correctness
&lt;/h3&gt;

&lt;p&gt;A question that says &lt;em&gt;"Find customers who placed another order within 7 days"&lt;/em&gt; reads generic. The same SQL, framed as &lt;em&gt;"Amazon's Prime retention team defines a repeat buyer as anyone who orders again within 7 days — the strongest early signal they've formed the habit worth nurturing"&lt;/em&gt;, reads like an actual Amazon interview question.&lt;/p&gt;

&lt;p&gt;Same schema. Same SQL. Same difficulty. Massively different trust density.&lt;/p&gt;

&lt;p&gt;DataLemur's moat isn't just their question count — it's that every question feels specifically authored for a specific company. That's copy-editing work, not SQL-engineering work. You can replicate it in an afternoon.&lt;/p&gt;

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

&lt;ul&gt;
&lt;li&gt;Expand the warehouse tracks — Snowflake just shipped with 95 compatible challenges; BigQuery and Databricks next&lt;/li&gt;
&lt;li&gt;Add warehouse-specific syntax (QUALIFY, FLATTEN, UNNEST) for senior roles&lt;/li&gt;
&lt;li&gt;Ship a dialect-translation viewer so you can see each challenge's SQLite version side-by-side with the Snowflake/BigQuery equivalent&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Live at &lt;a href="https://sqlquest.app" rel="noopener noreferrer"&gt;sqlquest.app&lt;/a&gt;. Free to start, Pro is $19/month for unlimited AI tutor and extra challenges.&lt;/p&gt;

&lt;p&gt;Would love feedback from Dev.to — especially if you're currently interviewing for a Snowflake, BigQuery, or Databricks role. What's missing? What's broken? What would make you close DBeaver forever?&lt;/p&gt;

&lt;p&gt;#buildinpublic #data #beginners #sql&lt;/p&gt;

</description>
      <category>learning</category>
      <category>productivity</category>
      <category>showdev</category>
      <category>sql</category>
    </item>
    <item>
      <title>Hit Supabase's free $25 pricing cliff. Any middle-tier options?</title>
      <dc:creator>Can Goktug Ozdem</dc:creator>
      <pubDate>Tue, 21 Apr 2026 08:54:27 +0000</pubDate>
      <link>https://dev.to/cgozdemm/hit-supabases-free-25-pricing-cliff-any-middle-tier-options-2h2m</link>
      <guid>https://dev.to/cgozdemm/hit-supabases-free-25-pricing-cliff-any-middle-tier-options-2h2m</guid>
      <description>&lt;p&gt;Solo builder here. I'm running sqlquest.app — an adaptive SQL tutor — on Supabase's free tier since January. Traffic is tiny, maybe 10-20 real sessions a day. Every page load touches 5-6 tables though, and egress adds up quick when your app does state sync properly.&lt;/p&gt;

&lt;p&gt;Went ~15% over the 5GB/month free egress cap. Instead of a soft warning or overage billing, the project hard-fails. Every API request returns 402. Login breaks. Signups break. Everything user-facing dies.&lt;/p&gt;

&lt;p&gt;Two options:&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;Wait for the billing cycle to reset and hope the "short delay after reset" doesn't stretch into hours (it did)&lt;/li&gt;
&lt;li&gt;Upgrade to Pro at $25/mo, instantly unblocked&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;I was 20 minutes from a live paid student demo when this hit. Paid the $25.&lt;/p&gt;

&lt;p&gt;The $25 tier gives 250GB egress — 50× what I need. There's no middle ground for solo builders who've crossed the free cap but don't need enterprise headroom.&lt;/p&gt;

&lt;p&gt;Questions for HN:&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;Has anyone else hit this? How'd you handle it?&lt;/li&gt;
&lt;li&gt;Any existing workarounds (PostgREST + self-hosted, different provider with better pricing ladder)?&lt;/li&gt;
&lt;li&gt;Is there a case to be made to Supabase for a $5-10/mo "solo" tier between Free and Pro? Or is the $25 tier strategically important for their unit economics?&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;Not trying to bash the product — I love the DX and I'm not switching. Just frustrated with the pricing jump. Curious if the community has opinions.&lt;/p&gt;

</description>
      <category>database</category>
      <category>discuss</category>
      <category>saas</category>
      <category>sideprojects</category>
    </item>
  </channel>
</rss>
