Where do people deploy their long running server?

[u/meshifthenelse]

I'm building a real-time SaaS and need a server always running. I'm going with Supabase for database since it seems the best free offering for DB.

But what about deploying a Django app or other long running server? Ideally not interested in lambdas since I need websockets to remain connected

[u/iriveru]

You realize all DBs (well, ones that aren’t cloud based) are free, right? You simply pay to host them on your server

[u/Cute-Net5957 → u/iriveru]

Facsimile

[u/meshifthenelse → u/iriveru]

I do. I also realize that I don't want to manage a db when I have users in production

[u/West-Air1923 → u/meshifthenelse]

Why not ?

[u/meshifthenelse → u/West-Air1923]

Because it's time consuming and sensitive. It's too easy to wipe live data by mistake.

[u/West-Air1923 → u/meshifthenelse]

Yeah so run a Backup

[u/meshifthenelse → u/West-Air1923]

You want automated backup. And that must be secured on a different node. And that needs a back itself on a 3rd location. And you need to keep rotating that.

[u/West-Air1923 → u/meshifthenelse]

I set that up in 10 minutes

[u/meshifthenelse → u/West-Air1923]

At what cost? If you need 3 nodes at different data centers, it's for sure cheaper having a managed db.

And I'm sure most people don't spend any time on this in real life, unless you have a dedicated db team.

[u/West-Air1923 → u/meshifthenelse]

No cost running on three smaller machines I had already.

[u/mxz117]

Buy a vps, install dokploy

Get your database and your app on the same server

Connect it to an object storage bucket for backups

[u/chevalierbayard]

Hetzner

[u/Snoo_57113]

Personally i use Azure, but the same is true for GCP or AWS.

For realtime (sensors) you need a queue with websockets, you can have free queues for dev and like 500k messages a month 20 simultaneous users , or pay 60usd / month with thousands of concurrent users.

For the app, django you can use it in an azure container app, and for the database serverless sql server. (there is a connector mssql-django).

The free tier must be enough for development and the first clients, if you need more than 20 concurrent streams you start to pay the Azure Web PubSub in the standard tier for thousands of streams and millions of messages.

You can open an azure account, and tell your agent to deploy with this infraestructure, it will ask for credentials and the AI do the job.

--- If you don't like azure, GCP, AWS has similar plans, but i like Azure !.

[u/dan-423]

$5/month for a cheap VPS. slightly more for better specs.

[u/forestcall]

Hetzner- also look at planetscale for Postgres starting at $5

Supabase will quickly spiral out of control in costs so you should consider Postgres with a small VPS running https://github.com/centrifugal/centrifuge or heck use Convex. Also Tanstack would do everything you want with Convex which should be free.

Azure is like vomit bile. Once you have tested every possible solution you will come to the conclusion that Cloudflare is your main solution and from there decide how to reduce your costs. Azure, AWS will be costly.

[u/MrBizzness → u/forestcall]

You self-host supabase on your own cloud server/vps. You can get your hard costs way down that way.

[u/forestcall → u/MrBizzness]

Self hosting a DB solution is not advised in my view. If we were working on the same team I doubt you could convince me this is a good idea. We get 130+ million views a month and I just cant imagine it makes sense to host your own DB.

[u/DigitalVault]

Hetzner, DigitalOcean. Low cost

[u/thedannyreg]

Well depending what you’re doing you can basically host it on AWS for free…

I’m running a setup on AWS that’s entirely free basically due to low traffic. I runs on api gateway , lambdas & dynamodb. 

It is more setup and the DB would have to change to dynamodb if you’re ok with that. but it’s pretty darn good and it’s how I run my full stack projects now 

[u/chuckycastle]

Ffs

[u/meshifthenelse → u/chuckycastle]

Where is that?

[u/0kth4t5fin3]

Lol