BotsnBytes BotsnBytes
All work INFRASTRUCTURE

Multi-Database Infrastructure on a Single VPS

Clean, secure database setup letting multiple Django apps share one server without stepping on each other.

1 VPS, multiple apps
scoped least-privilege access
2 isolated databases
The challenge

Running several applications on one server sounds simple until you get to the database layer. Give every app too much access and one breach compromises everything. Lock it down too hard and nothing works. The goal was to host multiple production Django apps on a single VPS with proper user permissions, real isolation between databases, and no shared credentials that turn one mistake into a full outage.

What I built

I set up PostgreSQL on a VPS with a dedicated role scoped to exactly the databases it needs and nothing more, giving separate applications clean access to their own data without over-permissioning. The result is two production apps running side by side on one machine, each with its own database, sharing infrastructure without sharing risk. It's the unglamorous foundation work that keeps small deployments cheap, secure, and boring in the best way.

Want something like this for your team?

Start with a fixed-scope audit — I'll tell you what's worth building first.

Book an Audit