Working Code

235: When Romance Becomes a Database Problem with Sean Corfield


Listen Later

How do you keep millions of people safe on 40 different dating sites while simultaneously figuring out what drives them to buy memberships? Sean Corfield joins Adam and Ben to discuss the surprisingly complex engineering and business challenges of observing user behavior at massive scale.

Sean runs us through fraud detection and prevention (including devastating "pig butchering" romance scams), database architecture at enormous scale (700GB databases with 250M+ row tables), custom domain-specific languages for writing business rules without touching SQL, real-time scoring systems with hundreds of rules, zero-downtime deployments and schema migrations, and the constant cat-and-mouse game between scammers and detection systems.

Follow the show and be sure to join the discussion on Discord! Our website is workingcode.dev and we're @workingcode.dev on Bluesky. New episodes drop weekly on Wednesday.

And, if you're feeling the lovesupport us on Patreon.

With audio editing and engineering by ZCross Media.

Full show notes and transcript here.

...more
View all episodesView all episodes
Download on the App Store

Working CodeBy Adam Tuttle, Ben Nadel, Carol Hamilton, Tim Cunningham

  • 5
  • 5
  • 5
  • 5
  • 5

5

26 ratings


More shows like Working Code

View all
The Joe Rogan Experience by Joe Rogan

The Joe Rogan Experience

227,718 Listeners

The Bill Simmons Podcast by The Ringer

The Bill Simmons Podcast

30,206 Listeners

StarTalk Radio by Neil deGrasse Tyson

StarTalk Radio

14,268 Listeners

Science Vs by Spotify Studios

Science Vs

12,193 Listeners

Syntax - Tasty Web Development Treats by Wes Bos & Scott Tolinski - Full Stack JavaScript Web Developers

Syntax - Tasty Web Development Treats

986 Listeners

Darknet Diaries by Jack Rhysider

Darknet Diaries

8,010 Listeners

Conan O’Brien Needs A Friend by Team Coco & Earwolf

Conan O’Brien Needs A Friend

59,401 Listeners

.NET Rocks! by Carl Franklin and Richard Campbell

.NET Rocks!

244 Listeners

The Bulwark Podcast by The Bulwark

The Bulwark Podcast

12,253 Listeners

Modernize or Die ® Podcast by Ortus Solutions

Modernize or Die ® Podcast

7 Listeners

Bad Friends by Bobby Lee & Andrew Santino

Bad Friends

14,385 Listeners

Hard Fork by The New York Times

Hard Fork

5,469 Listeners

Fly on the Wall with Dana Carvey and David Spade by Audacy

Fly on the Wall with Dana Carvey and David Spade

12,894 Listeners