Case Studies

The Challenge

DOCA, a nonprofit focused on defense and national security education, was running on a legacy MySQL database with an outdated PHP application. Member management, event coordination, and communications were fragmented across spreadsheets and email chains.

Our Solution

We built a modern member portal from the ground up using Next.js 15, PostgreSQL, and a clean Navy & Gold design language that reflects DOCA's prestige. The system includes member directory with search, event management, secure authentication, and an admin dashboard for staff.

Results

• Migrated from legacy PHP to modern Next.js stack
• Centralized member data previously scattered across spreadsheets
• Admin dashboard for staff to manage members and events
• Responsive design accessible on any device

The Challenge

Small plumbing companies typically manage jobs through phone calls, paper tickets, and memory. This leads to missed appointments, billing delays, and zero visibility into technician schedules or job profitability.

Our Solution

We created FlowRight — a full-featured field service management system. Dispatchers can assign jobs, track technician locations, and manage the full lifecycle from estimate to invoice. Built as a production-ready demo showcasing what's possible for any trades business.

Results

• Complete job lifecycle: estimate → schedule → dispatch → complete → invoice
• Real-time technician scheduling and availability tracking
• Customer database with full job history
• Built and deployed in under 2 weeks

The Challenge

Soap makers need precise lye calculations based on oil saponification values — get it wrong, and the batch is ruined (or dangerous). Existing tools were outdated desktop apps or clunky spreadsheets with no mobile support.

Our Solution

We built Soaply, a full-featured SaaS with real-time lye calculations for 98 oils, bar property analysis (hardness, cleansing, conditioning), recipe saving, PDF export, and a Stripe-powered subscription model. The app handles both cold-process and hot-process methods.

Results

• 98 oils with accurate SAP values and property profiles
• Real-time bar property analysis as ingredients change
• PDF recipe export for workshop use
• Stripe subscription model generating recurring revenue

The Challenge

Craft vendors spend hours every week searching for upcoming fairs across dozens of different websites, Facebook groups, and word of mouth. There was no single source of truth for finding and comparing craft fairs nationwide.

Our Solution

We built TheCraftMap — an automated data platform that scrapes, aggregates, and enriches craft fair listings from across the web. Smart scrapers run multiple times daily, collecting event details, locations, dates, and vendor information. A subscription model gives vendors premium access to filters and alerts.

Results

• 4,000+ craft fairs indexed across all 50 states
• Automated scrapers running 4x daily for fresh data
• Interactive search with location, date, and category filters
• State-by-state guides for vendor planning

The Challenge

A dataset of 227 million rows of public spending records needed to be made searchable and analyzable — with statistical outlier detection, geographic filtering, and sub-second query performance. Traditional databases couldn't handle the scale affordably.

Our Solution

We used DuckDB with columnar Parquet files to achieve blazing-fast analytical queries without a traditional database server. The web interface lets users search providers, view spending patterns, detect statistical outliers, and filter by geography — all with sub-second response times.

Results

• 227 million rows queryable in under 1 second
• Statistical outlier detection flags unusual spending
• Zero database hosting costs (serverless Parquet files)
• Interactive tables with search, sort, and geographic filters

The Challenge

Managing SEO content across multiple websites meant manually researching keywords, writing articles, sourcing images, adding structured data, and publishing — for each site, every week. It didn't scale.

Our Solution

We built an automated content pipeline that handles the entire workflow: keyword research, competitive analysis, article generation with proper SEO structure, image sourcing, JSON-LD structured data, and automated deployment. It manages multiple domains with site-specific voice and strategy.

Results

• 100+ articles managed across multiple domains
• Automated keyword research and competitive gap analysis
• Structured data and Open Graph tags on every article
• Consistent publishing schedule without manual effort