Menu

The Week My App Almost Ran Out of Database
📰

The Week My App Almost Ran Out of Database

DEV Community: webdev·leppercaun22·about 5 hours ago
#n5COUbWq
#devtowebdev#devto#dev#every#database
Long article (627 words) — no AI summary yet.
Reading 0:00
15s threshold

Hey dev.to — Lepp again. Entry two in building Neuro-Kindred (a free, calm social app for neurodivergent adults, 18+) in the open. Last time: pebbles instead of likes. This time: a mystery, three wrong suspects, and the week I nearly lost the whole app to a free-tier limit.

The setup

Neuro-Kindred runs on a $3/month server and a free Postgres database (Neon, 100 free compute-hours a month). On Nov 15 I got the email nobody wants: 80 of the 100 hours already used , halfway through the month. At 100, the database sleeps until December 1st — app down, no charge, data safe, but down.

Something was waking the database constantly. It wasn't my members: in the worst 48-hour stretch, 38 members sent 63 messages total. So I went hunting.

Suspect #1: the scanners

The server logs showed a burst of 188 requests in one minute from a cloud IP, probing for .env files and admin paths. All 404s, nothing exposed — but bots were my first theory. Verdict: real, but too small.…

Continue reading — create a free account

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