RAH Consultancy: a static export rebuilt as a publishable content platform
    RAH Consultancy logo
    Water industry consultancy & expert witness

    The same brand, rebuilt on foundations the client controls

    85 case studies and 20 news articles migrated out of spreadsheets and onto indexable pages the firm publishes itself.

    0
    Case studies migrated
    0
    URLs in the generated sitemap
    0
    Pages rebuilt
    Industry
    Water industry consultancy & expert witness
    Services
    Web App, Content Marketing & Strategy, SEO, UX & UI Design
    Duration
    Rebuild, migration and content platform
    Location
    United Kingdom

    RAH Consultancy is a specialist water industry consultancy providing systems and device design, laboratory auditing, product certification, regulatory advice for construction, and expert witness work in both water industry and IP or patent disputes.

    Challenge

    Credibility locked inside a static export

    All 27 pages were fixed markup. Adding a single case study meant editing HTML by hand or going back to a developer, so the site stopped being updated: category pages designed to list published work rendered 'No items found', while the actual portfolio lived in spreadsheet exports.

    Objectives

    Project Objectives

    A rebuilt website on a modern framework

    React 19 and TypeScript on TanStack Start with file-based routing and SSR, preserving the mega menu, hero slider and animated interactions.

    A content platform for published work

    Case studies, news and testimonials moved into Postgres, with live listing pages, uniform cards and an indexable detail route for every item.

    An administrator area for non-technical publishing

    Plain text inputs and file upload with a live 16:9 preview instead of raw HTML fields, so an author sees how a banner crops before saving.

    Authentication, roles and access control

    Roles in a dedicated table evaluated server-side, row-level security on every table, and public read access limited to published content.

    Enquiry capture and notification

    A validated contact form written to an admin-only submissions table and emailed to the enquiries inbox from a verified sending domain.

    SEO foundation and weekly monitoring

    Per-route metadata, canonicals, JSON-LD, a generated sitemap of 108 URLs, and a scheduled crawler that snapshots markup and emails alerts on regressions.

    Solution

    Content treated as data from the start

    The 27-page site was rebuilt as a React 19 and TypeScript application on TanStack Start with server-side rendering, carrying across every page, link, image and interaction so returning visitors saw a familiar site. The change was structural, not cosmetic.

    Behind it sits a content platform: Postgres with row-level security, an administrator area for news, case studies and testimonials, private image uploads served through an application proxy, and role-based access so only approved accounts can publish. 51 water consultancy case studies, 14 expert witness case studies, 20 news articles and the full testimonial set were migrated in and now render from the database with their own detail pages.

    Results

    The Impact

    0
    Case studies live
    51 water consultancy and 14 expert witness case studies, plus 20 news articles and the full testimonial set.
    0
    Indexed URLs
    A generated sitemap with canonical URLs and JSON-LD across the site.
    Weekly
    Automated SEO crawl
    Metadata changes and page errors detected and emailed, instead of ad hoc manual checks.
    0
    Developer tickets to publish
    The team publishes news, case studies and testimonials without a developer.

    Tech

    Technology Stack

    React 19
    TypeScript
    TanStack Start
    TanStack Router
    TanStack Query
    Vite 7
    Tailwind CSS v4
    Postgres
    Row-level security
    Edge server functions
    Zod
    Private object storage
    Resend
    pg_cron
    JSON-LD
    Generated XML sitemap

    FAQ

    Frequently asked questions

    Good to knowWas the brand redesigned?+

    No. The established visual identity, navigation and imagery were preserved, with refinement of typography, spacing and focus states applied on top.

    How is the content managed now?+

    Through a protected admin area with plain text inputs, file uploads and a live preview. Adding the fifty-second case study takes minutes rather than a development ticket.

    How is SEO kept healthy?+

    A scheduled weekly crawler fetches every sitemap URL, snapshots the SEO-relevant markup, compares it against the previous run and emails an alert when something material changes.

    Ready to Achieve Similar Results?

    Let's talk about how we can drive comparable growth for your business.