Full-Stack Development / Data
HomeWaterPure
A data-first guide to water softeners and filters, where every product links to the source of its specs and the sizing calculator shows its arithmetic.
Visit the site
The problem
What was wrong
Homeowners shopping for a water softener land on affiliate pages that repeat manufacturer claims and never say where a number came from. Hardness varies city by city, so a generic "best softener" list is a guess. We wanted a guide where a reader can check every figure.
What we built
What we built
- A product catalog in Postgres where every product must carry a source URL, and every Amazon price is timestamped and hidden once it is more than a day old.
- City hardness pages built from each utility’s own Consumer Confidence Report, with the quoted line and URL logged for every row.
- A sizing calculator that runs in the browser and shows each step, from household size to grain capacity.
- A methodology page that says how products are chosen and how the site makes money.
- Affiliate links routed through our own redirect, which logs clicks without storing an IP address.
Stack
What it runs on
- Astro
- Neon Postgres
- Drizzle ORM
- Vercel
- MDX
- Amazon Creators API
Results
The numbers
37
Pages in sitemap
18
Cities with sourced hardness
37
Products in the catalog
What we'd tell another builder
One lesson
Put the rules in the schema, not in a doc. A source URL the database refuses to go without, and a price that hides itself after 24 hours, hold up better than any checklist.
From the blog
Further reading
AI Integration
We Ran Our AI-Readiness Scanner on Our Own Sites. Here's What It Found.
We pointed our free AI-readiness scanner at the seven sites we run. One was blocking AI crawlers without us knowing, and none had an llms.txt.
Read the postWeb Development
34 of Our 40 Spec Sources Were Dead Links: How HomeWaterPure Handles Product Data
Building a water softener guide where every spec has a source. What broke, the schema rules that keep numbers honest, and a calculator that shows its math.
Read the postWant something like this?
Tell us what you're working on and we'll figure out the right approach together.
More work
Other case studies
Web Application / SEO
Invoice for Trades
A free invoice generator for tradespeople with no signup and no watermark. The PDF is built in the browser, so nothing is sent to a server.
Read the case studyE-commerce / SEO
RecycleOldTech
A nationwide directory of certified electronics recycling centers, with an automated content and SEO pipeline behind every city and state page.
Read the case studyDirectory / AI Data Pipeline
eBikeLocal
A nationwide e-bike shop directory that tells you which brands a shop actually carries, fed by a pipeline that normalizes brand dealer locators.
Read the case study