Menu

Adding Rate Limits to a Netlify Chat Endpoint with Postgres for Palm Beach Contractors
📰

Adding Rate Limits to a Netlify Chat Endpoint with Postgres for Palm Beach Contractors

DEV Community: postgres·the bomber·15 days ago
#9qyRKfJG
#devtopostgresql#devto#dev#postgres#chat
Reading 0:00
15s threshold

I’m Kaleb, running Dream Futures Tech right here in Pompano Beach, Florida. When local contractors around Palm Beach County—whether they are roofers in Boca Raton or plumbers in Fort Lauderdale—ask me why their website isn't turning traffic into phone calls, it usually comes down to friction. Either the contact form is buried, or their chat widget is completely broken by spam bots submitting fake leads every three seconds.

I built a public chat and lead-capture endpoint on my own business website to test out automated SMS routing to my phone. It worked great until automated scrapers found the raw function URL. Suddenly, bots were hammering the endpoint fifty times a minute, trying to inject SQL strings and garbage URLs into my database. My serverless setup on Netlify was dispatching these requests instantly, which quickly exhausted my Postgres connection pool.

In my view, relying entirely on client-side CAPTCHAs is a losing battle because automated headless browsers just execute the JavaScript anyway.…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.