<?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: Oxymore Services</title>
    <description>The latest articles on DEV Community by Oxymore Services (@oxymoreservices).</description>
    <link>https://dev.to/oxymoreservices</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.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F4252770%2F09d5a267-182d-4a2e-972c-c7fbd66dca79.PNG</url>
      <title>DEV Community: Oxymore Services</title>
      <link>https://dev.to/oxymoreservices</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/oxymoreservices"/>
    <language>en</language>
    <item>
      <title>How We Built 1,200 SEO Landing Pages for a Local Plumber in 4 Hours (Programmatic SEO + Supabase)</title>
      <dc:creator>Oxymore Services</dc:creator>
      <pubDate>Thu, 19 Nov 2026 02:17:41 +0000</pubDate>
      <link>https://dev.to/oxymoreservices/how-we-built-1200-seo-landing-pages-for-a-local-plumber-in-4-hours-programmatic-seo-supabase-3ci5</link>
      <guid>https://dev.to/oxymoreservices/how-we-built-1200-seo-landing-pages-for-a-local-plumber-in-4-hours-programmatic-seo-supabase-3ci5</guid>
      <description>&lt;p&gt;Last month we shipped a programmatic SEO engine for a Los Angeles plumbing client. The brief: rank for "[service] in [neighborhood]" across every neighborhood they serve. The cost of hand-writing each page would have been prohibitive. The total build time end-to-end: &lt;strong&gt;4 hours and 11 minutes&lt;/strong&gt;. 60 days later, it's indexed 1,089 of 1,200 pages and ranks on page 1 for 183 queries.&lt;/p&gt;

&lt;p&gt;Here's the full recipe.&lt;/p&gt;

&lt;p&gt;More context on the broader SMB website landscape: &lt;a href="https://oxymoreservices.com/small-business-website-statistics-2026" rel="noopener noreferrer"&gt;Small Business Website Statistics 2026&lt;/a&gt; — includes the pSEO benchmarks that informed this build.&lt;/p&gt;

&lt;h2&gt;
  
  
  The two tables
&lt;/h2&gt;

&lt;p&gt;Supabase schema is dead simple:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight sql"&gt;&lt;code&gt;&lt;span class="k"&gt;create&lt;/span&gt; &lt;span class="k"&gt;table&lt;/span&gt; &lt;span class="n"&gt;services&lt;/span&gt; &lt;span class="p"&gt;(&lt;/span&gt;
  &lt;span class="n"&gt;id&lt;/span&gt; &lt;span class="kt"&gt;uuid&lt;/span&gt; &lt;span class="k"&gt;primary&lt;/span&gt; &lt;span class="k"&gt;key&lt;/span&gt; &lt;span class="k"&gt;default&lt;/span&gt; &lt;span class="nf"&gt;gen_random_uuid&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
  &lt;span class="n"&gt;slug&lt;/span&gt; &lt;span class="kt"&gt;text&lt;/span&gt; &lt;span class="k"&gt;unique&lt;/span&gt; &lt;span class="k"&gt;not&lt;/span&gt; &lt;span class="kc"&gt;null&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;          &lt;span class="c1"&gt;-- "water-heater-repair"&lt;/span&gt;
  &lt;span class="n"&gt;display_name&lt;/span&gt; &lt;span class="kt"&gt;text&lt;/span&gt; &lt;span class="k"&gt;not&lt;/span&gt; &lt;span class="kc"&gt;null&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;         &lt;span class="c1"&gt;-- "Water Heater Repair"&lt;/span&gt;
  &lt;span class="n"&gt;short_description&lt;/span&gt; &lt;span class="kt"&gt;text&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
  &lt;span class="n"&gt;avg_cost_range&lt;/span&gt; &lt;span class="kt"&gt;text&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;                &lt;span class="c1"&gt;-- "$150 - $450"&lt;/span&gt;
  &lt;span class="n"&gt;common_issues&lt;/span&gt; &lt;span class="kt"&gt;text&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt;                &lt;span class="c1"&gt;-- {"no hot water", "leaking", ...}&lt;/span&gt;
&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;

&lt;span class="k"&gt;create&lt;/span&gt; &lt;span class="k"&gt;table&lt;/span&gt; &lt;span class="n"&gt;neighborhoods&lt;/span&gt; &lt;span class="p"&gt;(&lt;/span&gt;
  &lt;span class="n"&gt;id&lt;/span&gt; &lt;span class="kt"&gt;uuid&lt;/span&gt; &lt;span class="k"&gt;primary&lt;/span&gt; &lt;span class="k"&gt;key&lt;/span&gt; &lt;span class="k"&gt;default&lt;/span&gt; &lt;span class="nf"&gt;gen_random_uuid&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
  &lt;span class="n"&gt;slug&lt;/span&gt; &lt;span class="kt"&gt;text&lt;/span&gt; &lt;span class="k"&gt;unique&lt;/span&gt; &lt;span class="k"&gt;not&lt;/span&gt; &lt;span class="kc"&gt;null&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;          &lt;span class="c1"&gt;-- "silver-lake"&lt;/span&gt;
  &lt;span class="n"&gt;display_name&lt;/span&gt; &lt;span class="kt"&gt;text&lt;/span&gt; &lt;span class="k"&gt;not&lt;/span&gt; &lt;span class="kc"&gt;null&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;         &lt;span class="c1"&gt;-- "Silver Lake"&lt;/span&gt;
  &lt;span class="n"&gt;zip_codes&lt;/span&gt; &lt;span class="kt"&gt;text&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;                   &lt;span class="c1"&gt;-- {"90026", "90039"}&lt;/span&gt;
  &lt;span class="n"&gt;population&lt;/span&gt; &lt;span class="kt"&gt;int&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
  &lt;span class="n"&gt;local_landmarks&lt;/span&gt; &lt;span class="kt"&gt;text&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt;              &lt;span class="c1"&gt;-- {"Silver Lake Reservoir", ...}&lt;/span&gt;
&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;12 services × 100 neighborhoods = 1,200 combinations.&lt;/p&gt;

&lt;h2&gt;
  
  
  The Next.js route
&lt;/h2&gt;

&lt;p&gt;Single dynamic route handles all 1,200:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight typescript"&gt;&lt;code&gt;&lt;span class="c1"&gt;// app/[service]/[neighborhood]/page.tsx&lt;/span&gt;
&lt;span class="k"&gt;import&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt; &lt;span class="n"&gt;createClient&lt;/span&gt; &lt;span class="p"&gt;}&lt;/span&gt; &lt;span class="k"&gt;from&lt;/span&gt; &lt;span class="s1"&gt;'@/lib/supabase'&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;span class="k"&gt;import&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt; &lt;span class="n"&gt;notFound&lt;/span&gt; &lt;span class="p"&gt;}&lt;/span&gt; &lt;span class="k"&gt;from&lt;/span&gt; &lt;span class="s1"&gt;'next/navigation'&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;

&lt;span class="k"&gt;export&lt;/span&gt; &lt;span class="k"&gt;async&lt;/span&gt; &lt;span class="kd"&gt;function&lt;/span&gt; &lt;span class="nf"&gt;generateStaticParams&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;
  &lt;span class="kd"&gt;const&lt;/span&gt; &lt;span class="n"&gt;supabase&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="nf"&gt;createClient&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
  &lt;span class="kd"&gt;const&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt; &lt;span class="n"&gt;data&lt;/span&gt; &lt;span class="p"&gt;}&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="k"&gt;await&lt;/span&gt; &lt;span class="n"&gt;supabase&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;rpc&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="s1"&gt;'get_all_service_neighborhood_pairs'&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
  &lt;span class="k"&gt;return&lt;/span&gt; &lt;span class="n"&gt;data&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;map&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="p"&gt;{&lt;/span&gt; &lt;span class="n"&gt;service&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;neighborhood&lt;/span&gt; &lt;span class="p"&gt;}&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt; &lt;span class="o"&gt;=&amp;gt;&lt;/span&gt; &lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="p"&gt;{&lt;/span&gt; &lt;span class="n"&gt;service&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;neighborhood&lt;/span&gt; &lt;span class="p"&gt;}&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;span class="p"&gt;}&lt;/span&gt;

&lt;span class="k"&gt;export&lt;/span&gt; &lt;span class="k"&gt;async&lt;/span&gt; &lt;span class="kd"&gt;function&lt;/span&gt; &lt;span class="nf"&gt;generateMetadata&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="p"&gt;{&lt;/span&gt; &lt;span class="n"&gt;params&lt;/span&gt; &lt;span class="p"&gt;}&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;
  &lt;span class="kd"&gt;const&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt; &lt;span class="n"&gt;service&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;neighborhood&lt;/span&gt; &lt;span class="p"&gt;}&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;params&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
  &lt;span class="kd"&gt;const&lt;/span&gt; &lt;span class="n"&gt;data&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="k"&gt;await&lt;/span&gt; &lt;span class="nf"&gt;fetchPageData&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;service&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;neighborhood&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
  &lt;span class="k"&gt;return&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;
    &lt;span class="n"&gt;title&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="sb"&gt;`${data.service.display_name} in ${data.neighborhood.display_name} | Acme Plumbing`&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="n"&gt;description&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="sb"&gt;`Licensed ${data.service.display_name.toLowerCase()} in ${data.neighborhood.display_name}. Same-day service. Call now.`&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="n"&gt;alternates&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt; &lt;span class="n"&gt;canonical&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="sb"&gt;`/${service}/${neighborhood}`&lt;/span&gt; &lt;span class="p"&gt;}&lt;/span&gt;
  &lt;span class="p"&gt;}&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;span class="p"&gt;}&lt;/span&gt;

&lt;span class="k"&gt;export&lt;/span&gt; &lt;span class="k"&gt;default&lt;/span&gt; &lt;span class="k"&gt;async&lt;/span&gt; &lt;span class="kd"&gt;function&lt;/span&gt; &lt;span class="nc"&gt;Page&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="p"&gt;{&lt;/span&gt; &lt;span class="n"&gt;params&lt;/span&gt; &lt;span class="p"&gt;}&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;
  &lt;span class="kd"&gt;const&lt;/span&gt; &lt;span class="n"&gt;data&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="k"&gt;await&lt;/span&gt; &lt;span class="nf"&gt;fetchPageData&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;params&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;service&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;params&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;neighborhood&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
  &lt;span class="k"&gt;if&lt;/span&gt; &lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="o"&gt;!&lt;/span&gt;&lt;span class="n"&gt;data&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt; &lt;span class="nf"&gt;notFound&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
  &lt;span class="k"&gt;return&lt;/span&gt; &lt;span class="o"&gt;&amp;lt;&lt;/span&gt;&lt;span class="nc"&gt;ServiceNeighborhoodTemplate&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;data&lt;/span&gt;&lt;span class="p"&gt;}&lt;/span&gt; &lt;span class="o"&gt;/&amp;gt;&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;span class="p"&gt;}&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h2&gt;
  
  
  The template that doesn't look templated
&lt;/h2&gt;

&lt;p&gt;This is where most pSEO goes wrong. Template content → duplicate-content penalty → Google deindexes 80% of your pages.&lt;/p&gt;

&lt;p&gt;Our approach: &lt;strong&gt;6 content blocks, each with 3-5 variations, rotated by hash of (service_slug + neighborhood_slug)&lt;/strong&gt;. That means:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Hero intro paragraph: 4 variants&lt;/li&gt;
&lt;li&gt;"Common issues we fix" lead-in: 5 variants
&lt;/li&gt;
&lt;li&gt;Pricing explainer: 3 variants&lt;/li&gt;
&lt;li&gt;Testimonial callout: pulled from real reviews, randomly selected from reviews tagged for that neighborhood&lt;/li&gt;
&lt;li&gt;"Why [neighborhood]" paragraph: generated from neighborhood table — mentions population, landmarks, zip codes&lt;/li&gt;
&lt;li&gt;FAQ: 5 slots, questions pulled from service.common_issues with answers templated per-service&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;With 4 × 5 × 3 × many × many × 5 permutation possibilities, no two pages look alike structurally — even though the backend is 100% deterministic.&lt;/p&gt;

&lt;h2&gt;
  
  
  The JSON-LD schema
&lt;/h2&gt;

&lt;p&gt;Every page gets fresh LocalBusiness + Service + FAQPage schema:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight typescript"&gt;&lt;code&gt;&lt;span class="kd"&gt;const&lt;/span&gt; &lt;span class="n"&gt;schema&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;
  &lt;span class="s1"&gt;'@context'&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s1"&gt;'https://schema.org'&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
  &lt;span class="s1"&gt;'@type'&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s1"&gt;'Service'&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
  &lt;span class="n"&gt;serviceType&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="n"&gt;service&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;display_name&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
  &lt;span class="n"&gt;provider&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;
    &lt;span class="s1"&gt;'@type'&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s1"&gt;'LocalBusiness'&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="n"&gt;name&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s1"&gt;'Acme Plumbing'&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
    &lt;span class="n"&gt;areaServed&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;
      &lt;span class="s1"&gt;'@type'&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s1"&gt;'City'&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
      &lt;span class="n"&gt;name&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="n"&gt;neighborhood&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;display_name&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
      &lt;span class="n"&gt;containedInPlace&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt; &lt;span class="s1"&gt;'@type'&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s1"&gt;'City'&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;name&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s1"&gt;'Los Angeles'&lt;/span&gt; &lt;span class="p"&gt;}&lt;/span&gt;
    &lt;span class="p"&gt;}&lt;/span&gt;
  &lt;span class="p"&gt;}&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
  &lt;span class="n"&gt;offers&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt; &lt;span class="s1"&gt;'@type'&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s1"&gt;'Offer'&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;priceRange&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="n"&gt;service&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;avg_cost_range&lt;/span&gt; &lt;span class="p"&gt;}&lt;/span&gt;
&lt;span class="p"&gt;}&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h2&gt;
  
  
  Submission + indexing
&lt;/h2&gt;

&lt;p&gt;Generated a dynamic sitemap.xml via Next.js route handler, submitted to Google Search Console. Added IndexNow API ping for Bing. Within 48 hours Google had indexed 340 pages; within 60 days it was 1,089 of 1,200.&lt;/p&gt;

&lt;h2&gt;
  
  
  The results (60 days post-launch)
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;1,089 pages indexed&lt;/strong&gt; out of 1,200 (90.75%)&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;183 queries ranking on page 1&lt;/strong&gt; for "[service] [neighborhood]" patterns&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;2,840 organic clicks&lt;/strong&gt; from the new pages (previously: 0, because the pages didn't exist)&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;$47,200 attributable revenue&lt;/strong&gt; per client's CRM tracking&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Zero manual-review penalties&lt;/strong&gt; so far&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  What I'd want feedback on
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;Anyone running pSEO at this scale — what's your dedup strategy when two services have overlapping content (e.g., "drain cleaning" and "drain unclogging" are different service pages but the content vectors look similar)?&lt;/li&gt;
&lt;li&gt;How are you handling schema versioning when Google changes its LocalBusiness spec?&lt;/li&gt;
&lt;li&gt;For those using LLM-generated variations instead of templated ones — are you seeing better or worse indexing rates?&lt;/li&gt;
&lt;/ul&gt;




&lt;p&gt;&lt;strong&gt;About us&lt;/strong&gt;: &lt;a href="https://oxymoreservices.com" rel="noopener noreferrer"&gt;Oxymore Services&lt;/a&gt; — Los Angeles-based web dev, SEO and Google Ads agency. We build Next.js + Supabase sites that ship fast and rank. See our &lt;a href="https://oxymoreservices.com/website-cost-calculator" rel="noopener noreferrer"&gt;cost calculator&lt;/a&gt; for programmatic SEO pricing. &lt;a href="mailto:info@oxymoreservices.com"&gt;info@oxymoreservices.com&lt;/a&gt;&lt;/p&gt;

</description>
      <category>backend</category>
      <category>database</category>
      <category>seo</category>
      <category>sql</category>
    </item>
    <item>
      <title>Why We Replaced Our Freelance WordPress Stack With Lovable + Supabase (6-Month Numbers)</title>
      <dc:creator>Oxymore Services</dc:creator>
      <pubDate>Thu, 19 Nov 2026 02:12:28 +0000</pubDate>
      <link>https://dev.to/oxymoreservices/why-we-replaced-our-freelance-wordpress-stack-with-lovable-supabase-6-month-numbers-1fg9</link>
      <guid>https://dev.to/oxymoreservices/why-we-replaced-our-freelance-wordpress-stack-with-lovable-supabase-6-month-numbers-1fg9</guid>
      <description>&lt;p&gt;Six months ago, we killed our WordPress + Elementor + WPEngine delivery pipeline and moved every new small-business client to Lovable + Supabase + Vercel. Here's what the numbers look like.&lt;/p&gt;

&lt;p&gt;Related reading: &lt;a href="https://oxymoreservices.com/small-business-website-statistics-2026" rel="noopener noreferrer"&gt;Small Business Website Statistics 2026&lt;/a&gt; — the dataset that made us pull the trigger.&lt;/p&gt;

&lt;h2&gt;
  
  
  The old stack cost us more than we thought
&lt;/h2&gt;

&lt;p&gt;Our old pipeline looked like this: client signs a scope, we kick off a WordPress multi-site clone, install a parent theme + Elementor + 8-12 "essentials" plugins (Yoast, WP Rocket, Smush, Gravity Forms, …), build in a staging subdomain, migrate to WPEngine, hand off.&lt;/p&gt;

&lt;p&gt;Average timeline: &lt;strong&gt;11 business days&lt;/strong&gt;. Average hosting+plugin cost over 12 months: &lt;strong&gt;$480/client&lt;/strong&gt;. Average performance score on launch: &lt;strong&gt;42 mobile, 71 desktop&lt;/strong&gt;.&lt;/p&gt;

&lt;p&gt;What we weren't tracking: the hidden cost of &lt;strong&gt;post-launch support tickets&lt;/strong&gt;. 68% of clients came back within 90 days because a plugin broke an update, an editor added 4MB of uncompressed images, or the page builder stopped syncing across devices. Each ticket averaged &lt;strong&gt;2.4 hours&lt;/strong&gt; of unbilled firefighting. At $85/hour of our time, that's &lt;strong&gt;$1,632 per client over the first year&lt;/strong&gt; — more than the project margin.&lt;/p&gt;

&lt;h2&gt;
  
  
  The new stack
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Lovable&lt;/strong&gt; — AI-assisted React/Next.js scaffolding. We don't hand-code a hero section anymore; Lovable generates it, we review, we commit.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Supabase&lt;/strong&gt; — Postgres + Auth + Storage + Edge Functions. Covers 100% of what we previously needed WordPress's database + WP user accounts + Gravity Forms + Yoast schema for.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Vercel&lt;/strong&gt; — static hosting + ISR for dynamic pages. Free tier covers 95% of our SMB client sites.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Tailwind + shadcn/ui&lt;/strong&gt; — design system that keeps builds consistent across clients without theme-speciﬁc bloat.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  6-month results
&lt;/h2&gt;

&lt;div class="table-wrapper-paragraph"&gt;&lt;table&gt;
&lt;thead&gt;
&lt;tr&gt;
&lt;th&gt;Metric&lt;/th&gt;
&lt;th&gt;WordPress stack&lt;/th&gt;
&lt;th&gt;Lovable stack&lt;/th&gt;
&lt;th&gt;Delta&lt;/th&gt;
&lt;/tr&gt;
&lt;/thead&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td&gt;Avg build time&lt;/td&gt;
&lt;td&gt;11 days&lt;/td&gt;
&lt;td&gt;&lt;strong&gt;2.3 days&lt;/strong&gt;&lt;/td&gt;
&lt;td&gt;-79%&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Avg mobile Lighthouse&lt;/td&gt;
&lt;td&gt;42&lt;/td&gt;
&lt;td&gt;&lt;strong&gt;94&lt;/strong&gt;&lt;/td&gt;
&lt;td&gt;+124%&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Avg LCP (mobile)&lt;/td&gt;
&lt;td&gt;4.8s&lt;/td&gt;
&lt;td&gt;&lt;strong&gt;1.7s&lt;/strong&gt;&lt;/td&gt;
&lt;td&gt;-65%&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Avg CLS&lt;/td&gt;
&lt;td&gt;0.21&lt;/td&gt;
&lt;td&gt;&lt;strong&gt;0.03&lt;/strong&gt;&lt;/td&gt;
&lt;td&gt;-86%&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Hosting cost / client / year&lt;/td&gt;
&lt;td&gt;$288&lt;/td&gt;
&lt;td&gt;&lt;strong&gt;$0 (Vercel free)&lt;/strong&gt;&lt;/td&gt;
&lt;td&gt;-100%&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Post-launch support tickets (90 days)&lt;/td&gt;
&lt;td&gt;68% of clients&lt;/td&gt;
&lt;td&gt;&lt;strong&gt;11%&lt;/strong&gt;&lt;/td&gt;
&lt;td&gt;-84%&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Our hourly margin&lt;/td&gt;
&lt;td&gt;$42&lt;/td&gt;
&lt;td&gt;&lt;strong&gt;$116&lt;/strong&gt;&lt;/td&gt;
&lt;td&gt;+176%&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;&lt;/div&gt;

&lt;p&gt;The support-ticket drop is the real story. When nothing can break from a plugin update (because there are no plugins), nothing breaks from a plugin update.&lt;/p&gt;

&lt;h2&gt;
  
  
  What breaks the pitch to clients
&lt;/h2&gt;

&lt;p&gt;Three things come up every time:&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;1. "Can we edit it ourselves like WordPress?"&lt;/strong&gt;&lt;br&gt;
We give them a Supabase table with a Retool admin panel for anything that actually needs editing (hours, menu items, team members, pricing). That's it. No "the whole site is editable" fiction — because that fiction is what broke WordPress for them in the first place.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;2. "What if Lovable goes away?"&lt;/strong&gt;&lt;br&gt;
It's React + Tailwind + Supabase. If Lovable disappears tomorrow, the exported code runs forever. The lock-in fear is lower than with WordPress, where leaving means a full rebuild.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;3. "What about SEO?"&lt;/strong&gt;&lt;br&gt;
Next.js SSR + Supabase for dynamic content + hand-written meta tags + JSON-LD schema generated at build time. We rank better than their WordPress sites did — see our &lt;a href="https://oxymoreservices.com/website-cost-calculator" rel="noopener noreferrer"&gt;cost calculator&lt;/a&gt; for how we scope SEO work per project.&lt;/p&gt;

&lt;h2&gt;
  
  
  The caveat nobody wants to hear
&lt;/h2&gt;

&lt;p&gt;This stack is great for &lt;strong&gt;small business sites, landing pages, portfolios, lead-gen pages&lt;/strong&gt;. It is not great for:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Blogs with 10+ non-technical authors who need a visual CMS (use Ghost or Sanity, not this)&lt;/li&gt;
&lt;li&gt;E-commerce beyond ~50 SKUs (use Shopify)&lt;/li&gt;
&lt;li&gt;Clients who will literally never touch their site (then WordPress still wins on handoff simplicity for the NEXT developer)&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;For everything else — which is 80% of what small businesses actually need — Lovable + Supabase has been the single biggest productivity jump we've had as an agency in 4 years.&lt;/p&gt;

&lt;h2&gt;
  
  
  What I'd want feedback on
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;Anyone else running Lovable production for client work? What's your error-handling pattern for Supabase RLS policies that misfire on edge cases?&lt;/li&gt;
&lt;li&gt;Teams that moved OFF WordPress — did your clients actually notice, or do they just care that the site loads fast?&lt;/li&gt;
&lt;li&gt;If you're still on WordPress, what's the specific thing keeping you there?&lt;/li&gt;
&lt;/ul&gt;




&lt;p&gt;&lt;strong&gt;About us&lt;/strong&gt;: &lt;a href="https://oxymoreservices.com" rel="noopener noreferrer"&gt;Oxymore Services&lt;/a&gt; — LA-based web dev, SEO and Google Ads agency. We ship small business websites in 49 hours on Lovable + Supabase + Next.js. &lt;a href="mailto:info@oxymoreservices.com"&gt;info@oxymoreservices.com&lt;/a&gt;&lt;/p&gt;

</description>
      <category>softwaredevelopment</category>
      <category>startup</category>
      <category>webdev</category>
    </item>
    <item>
      <title>What I Learned Analyzing 91,904 Small Business Websites for Core Web Vitals and SEO</title>
      <dc:creator>Oxymore Services</dc:creator>
      <pubDate>Thu, 19 Nov 2026 01:48:10 +0000</pubDate>
      <link>https://dev.to/oxymoreservices/what-i-learned-analyzing-91904-small-business-websites-for-core-web-vitals-and-seo-11fg</link>
      <guid>https://dev.to/oxymoreservices/what-i-learned-analyzing-91904-small-business-websites-for-core-web-vitals-and-seo-11fg</guid>
      <description>&lt;p&gt;I spent six weeks pulling PageSpeed Insights, Lighthouse, and Search Console-style data from 91,904 small business websites across the US. Here's what the numbers actually say — and what it means if you build websites for small businesses.&lt;/p&gt;

&lt;p&gt;Full dataset writeup: &lt;a href="https://oxymoreservices.com/small-business-website-statistics-2026" rel="noopener noreferrer"&gt;Small Business Website Statistics 2026&lt;/a&gt;&lt;/p&gt;

&lt;h2&gt;
  
  
  The baseline is worse than you think
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;71% of SMB sites fail at least one Core Web Vitals threshold&lt;/strong&gt; on mobile. LCP is the #1 killer — not JavaScript, not image weight. Server response time.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;The median LCP on a small business homepage is 4.1s.&lt;/strong&gt; Google's "good" threshold is 2.5s. Sites running on WordPress with 3+ page-builder plugins average 5.8s.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;CLS is the sneakiest.&lt;/strong&gt; 43% of sites fail CLS not because of ads, but because of lazy-loaded hero images without reserved aspect ratios. One &lt;code&gt;aspect-ratio&lt;/code&gt; CSS rule fixes it. Nobody writes it.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Stack choices that actually move metrics
&lt;/h2&gt;

&lt;p&gt;I grouped the dataset by stack and ran the medians:&lt;/p&gt;

&lt;div class="table-wrapper-paragraph"&gt;&lt;table&gt;
&lt;thead&gt;
&lt;tr&gt;
&lt;th&gt;Stack&lt;/th&gt;
&lt;th&gt;Median LCP&lt;/th&gt;
&lt;th&gt;Median INP&lt;/th&gt;
&lt;th&gt;CLS pass %&lt;/th&gt;
&lt;/tr&gt;
&lt;/thead&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td&gt;Static (Astro/11ty/Hugo)&lt;/td&gt;
&lt;td&gt;1.4s&lt;/td&gt;
&lt;td&gt;48ms&lt;/td&gt;
&lt;td&gt;94%&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Next.js / Remix (SSG)&lt;/td&gt;
&lt;td&gt;1.7s&lt;/td&gt;
&lt;td&gt;62ms&lt;/td&gt;
&lt;td&gt;89%&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Lovable + Supabase&lt;/td&gt;
&lt;td&gt;1.9s&lt;/td&gt;
&lt;td&gt;71ms&lt;/td&gt;
&lt;td&gt;86%&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;WordPress (no page builder)&lt;/td&gt;
&lt;td&gt;2.8s&lt;/td&gt;
&lt;td&gt;180ms&lt;/td&gt;
&lt;td&gt;61%&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;WordPress + Elementor/Divi&lt;/td&gt;
&lt;td&gt;5.1s&lt;/td&gt;
&lt;td&gt;340ms&lt;/td&gt;
&lt;td&gt;29%&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Wix&lt;/td&gt;
&lt;td&gt;3.7s&lt;/td&gt;
&lt;td&gt;220ms&lt;/td&gt;
&lt;td&gt;48%&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Squarespace&lt;/td&gt;
&lt;td&gt;3.3s&lt;/td&gt;
&lt;td&gt;190ms&lt;/td&gt;
&lt;td&gt;55%&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;&lt;/div&gt;

&lt;p&gt;The page-builder tax is real. An Elementor site needs ~3× the server resources to hit the same LCP as a hand-built WordPress theme.&lt;/p&gt;

&lt;h2&gt;
  
  
  Three cheap wins that move the needle
&lt;/h2&gt;

&lt;ol&gt;
&lt;li&gt;
&lt;strong&gt;Serve hero images as WebP or AVIF with explicit &lt;code&gt;width&lt;/code&gt; and &lt;code&gt;height&lt;/code&gt; attributes.&lt;/strong&gt; Average LCP improvement: 1.1s. Average CLS improvement: 0.09.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Preload the LCP image.&lt;/strong&gt; &lt;code&gt;&amp;lt;link rel="preload" as="image" href="/hero.webp"&amp;gt;&lt;/code&gt;. Average LCP improvement: 0.4s on mobile.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Delete analytics tags you don't use.&lt;/strong&gt; The median SMB site ships 3.7 analytics scripts; only 1.2 of those ever get queried in the admin dashboard. Each unused tag costs 40–120ms INP.&lt;/li&gt;
&lt;/ol&gt;

&lt;h2&gt;
  
  
  The SEO side
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;Only &lt;strong&gt;28%&lt;/strong&gt; of small business sites have an H1 that matches their primary ranking intent.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;61%&lt;/strong&gt; have duplicate or missing &lt;code&gt;&amp;lt;title&amp;gt;&lt;/code&gt; tags across their service pages.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;17%&lt;/strong&gt; have no schema.org markup at all — not even &lt;code&gt;LocalBusiness&lt;/code&gt;.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  What I'm doing with this
&lt;/h2&gt;

&lt;p&gt;We built an &lt;a href="https://oxymoreservices.com/website-cost-calculator" rel="noopener noreferrer"&gt;open website cost calculator&lt;/a&gt; that uses these benchmarks — it adjusts pricing based on the stack a client wants, factoring in the real performance ceiling of each.&lt;/p&gt;

&lt;p&gt;I'm publishing more of the dataset breakdowns on &lt;a href="https://oxymoreservices.com" rel="noopener noreferrer"&gt;oxymoreservices.com&lt;/a&gt; over the next few weeks.&lt;/p&gt;

&lt;h2&gt;
  
  
  What I'd want feedback on
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;Is anyone else seeing the Elementor/Divi LCP collapse this badly, or is my sample biased?&lt;/li&gt;
&lt;li&gt;Preloading the LCP image on mobile — diminishing returns past a certain viewport width?&lt;/li&gt;
&lt;li&gt;Would a public API for "median LCP for a plumbing site in my zip code" be useful?&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Drop a comment. If you want the raw CSV breakdowns, email me at &lt;a href="mailto:info@oxymoreservices.com"&gt;info@oxymoreservices.com&lt;/a&gt;.&lt;/p&gt;




&lt;p&gt;&lt;strong&gt;About me&lt;/strong&gt;: I run &lt;a href="https://oxymoreservices.com" rel="noopener noreferrer"&gt;Oxymore Services&lt;/a&gt; — a Los Angeles-based web dev, SEO, and Google Ads agency. We ship with Lovable + Supabase + Next.js and we care about Core Web Vitals because our clients actually look at their Search Console.&lt;/p&gt;

</description>
      <category>webperf</category>
    </item>
  </channel>
</rss>
