Assignment Desk

Dawson Built Assignment Desk Delta From Scratch. Here's the Engineering Story.

Dawson Bailey

TL;DR

Dawson Bailey rebuilt Assignment Desk from a 20-year-old WordPress site into a modern Next.js platform. This is the engineering story — the decisions, the mistakes, and the wins.

In early 2026, I sat down with a WordPress site that had been running for twenty years and a mandate: rebuild everything. Not a migration. Not a facelift. A ground-up rebuild of the entire platform — every page, every feature, every database table — on a modern stack that could scale for the next decade.

Here is what that actually looked like from the engineering seat.

The Stack Decision

Next.js 16 with React 19 and TypeScript. This was not a difficult choice — Next.js gives us server-side rendering for SEO (critical for a site that depends on search traffic), API routes for our REST API, incremental static regeneration for pages that need to be fast but also fresh, and edge functions for things like geolocation-based cookie consent.

Neon PostgreSQL for the database. Serverless Postgres with zero cold-start and HTTP-based connections. We never have to manage a database server, never worry about connection pooling at scale, and the developer experience with Drizzle ORM is outstanding.

Vercel for hosting. Global CDN, auto-scaling, deploy previews for every PR, and a deployment pipeline that just works.

The Migration Challenge

The WordPress site had 1,657 blog posts, 9,791 media assets, 158 pages, and 20 years of URL structure that Google had indexed. Every single URL had to be preserved — breaking URLs means losing SEO equity, and for a site that gets the majority of its traffic from search, that is unacceptable.

I wrote migration scripts that pulled every post, every image URL, every category and tag from the WordPress REST API, filtered out thousands of spam posts, and inserted everything into our new Neon database with the same slug structure. Then I verified every URL against the original site to make sure nothing was lost.

The Features

The old WordPress site was a marketing brochure. Delta is a full-stack SaaS platform: crew directory with 4,200+ profiles, interactive ratings, gig marketplace, crew and client portals, tiered memberships, advertising system, content calendar, email-to-blog pipeline, and a gamification system built around a beach-loving cameraman mascot named Ralphie.

Building all of that in a few months required making hard decisions about what to build versus what to buy, what to build now versus what to defer, and — most importantly — what not to build at all.

What I Learned

The biggest lesson: SEO is not a feature you add later. It is an architectural decision that affects every page, every route, every component. Structured data, meta tags, heading hierarchy, canonical URLs, sitemap generation — all of this has to be baked in from day one, not bolted on after launch.

The second lesson: type safety saves you at scale. TypeScript plus Drizzle ORM means that when I change a database column, the compiler tells me every page and API route that needs to be updated. On a platform with hundreds of routes and thousands of database queries, that is the difference between confidence and chaos.

Delta is live. It is fast. And it is just the beginning.

Need a Production Crew?

Assignment Desk provides professional camera crews in 24+ cities nationwide.

Book A Crew