

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.
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.
- Static exported site with no editing layer, so routine updates were deferred indefinitely.
- Case studies, news and testimonials held in spreadsheets, invisible to prospects and search engines.
- Listing pages rendering 'No items found', undermining trust in an expert-led business.
- No indexable detail page per project, so specialist enquiries had nothing to land on.
- Enquiries dependent on a plain email address, with no validation and no record.
- No consent mechanism, no SEO baseline and layout failures on phones and tablets.
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
Tech
Technology Stack
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.
More case studies

Radcliffe Knights: a volunteer-run club moved off spreadsheets and WhatsApp
A 16-page public site, an 11-step member pipeline, fixture syncing, payments tracking and safeguarding tooling, all run by volunteers.

Where the Wye Wanders: a commission-free booking marketplace for the Wye Valley
86 live listings, 31 property owners and two-way calendar syncing, built from a standing start in six months.

A browser studio that speaks hologram hardware
Hologram Studio turns PNGs, GIFs, video, 3D models and typed text into device-ready hologram content, rendered client-side and exported in the exact formats a Pepper's Ghost pyramid or a 576-LED fan expects.
Ready to Achieve Similar Results?
Let's talk about how we can drive comparable growth for your business.