Project Overview

DFW Daily is a full-stack local business intelligence and news platform for the Dallas–Fort Worth Metroplex, built from scratch as a community-focused digital hub. It combines a 45,000+ business directory with an interactive map, daily news aggregation, deal listings, event feeds, weather widgets, and a hiring board — all driven by automated content pipelines and a PostgreSQL database. Businesses are graded on digital presence (A–F), enabling targeted lead generation. Built for SEO performance with programmatic pages, schema markup, and Core Web Vitals optimization.

Next.js 15TypeScriptPostgreSQL Prisma ORMLeaflet MapsAnthropic AI StripeTwilioPuppeteer RSS AggregationCheerio ScrapingLinux VPS / PM2

By the Numbers

45K+

Business
Records

121

Service
Categories

20+

DFW
Suburbs

A–F

Presence
Grading

Daily

Automated
Ingestion

Platform Features

Business Directory & Search

45,000+ DFW businesses across 121 service categories
Full-text search with suburb, category, and rating filters
Interactive Leaflet map with clustered business pins
Business detail pages: hours, phone, website, photos, reviews
Presence grading (A–F) based on website, social, and review signals
Trending businesses surfaced by engagement and recency

News & Content Pipeline

Automated RSS aggregation from 30+ local news sources
AI-assisted content categorization and summary generation
Programmatic news pages by suburb, topic, and category
Trending topics engine pulling from Google/Reddit signals
Video hero section with lazy-loaded YouTube integration
Newspaper-style homepage layout with above-fold optimization

Deals, Events & Community

Local deals directory with merchant-submitted offers
Upcoming events feed with The Star (Frisco) integration
DFW Sports scores and schedules widget
Weather widget with DFW quick stats
Hottest nightspots and best diners sections
Now Hiring job board pulling local listings

Lead Gen & Admin System

Presence Grader for any business URL — scores digital footprint
Outreach tracking: status, priority, email, phone per business
Admin dashboard with analytics, outreach queue, and exports
jsPDF report generation for business presence audits
Newsletter signup with Nodemailer drip sequences
Stripe integration for premium business listings

Technology Stack

Frontend

Next.js 15 · React 18 · TypeScript · Tailwind CSS · Leaflet / React-Leaflet · Leaflet Cluster · Lucide Icons · jsPDF

Backend & Data

PostgreSQL · Prisma ORM · next-auth (JWT) · Bcrypt · Cheerio · rss-parser · Puppeteer · Axios · date-fns

Integrations

Anthropic Claude API · Google Analytics Data API · Stripe · Twilio SMS · Nodemailer SMTP · Sentry error tracking

Infrastructure

Linux VPS · PM2 · Nginx · SSL / Let’s Encrypt · Docker (PostgreSQL) · Cron content pipelines · Sharp image optimization

Key Deliverables

45,000+ business database with presence grading (A–F) and outreach tracking fields
Interactive Leaflet map with suburb/category filter and clustered pins
Automated daily content pipeline: RSS ingestion, AI categorization, programmatic pages
Presence Grader tool — audits any business URL and scores digital footprint
Admin dashboard with analytics, outreach queue, priority badges, and jsPDF exports
Newsletter system with Nodemailer drip sequence and subscriber management
Deals, events, jobs, sports, and weather modules — all pulling live data
SEO-optimized architecture: schema markup, canonical URLs, Core Web Vitals tuning