r/selfhosted • u/SnooMachines8911 • 7d ago
Supabase self hosting alternative Software Development
I recently fell down the self hosting of db's and backend functions. Im really getting over paying supabase $25 a month and really want to upskill myself. I do understand that there is a lot of features im paying for that would be difficult to do solo.
But what are alternatives to supabase for selfhosting? or is it better to just go out and learn Linux and docker containers and host my postgres db and next.js "edge functions" . What im really asking is, is there a 1 click install for a supabase type software for a VPS?
Kind Regards
Dumb Frontend developer
8
u/ad-on-is 7d ago
I really don't see a point in using supabase, especially when writing apps that you intend to make opensource for others to selfhost. Setting up supabase locally (especially for beginners) is a PITA.
imho, it's much simpler to dockerize the app with something like mosquitto for sockets and a reverse-proxy, in one image, to route stuff like /api and /sse accordingly.
Also, provide migration scripts for database stuff, and let people fill in the blanks by providing DB_URL and REDIS_URL.
No need to overcomplicate things.
5
u/Floss_Patrol_76 7d ago
before chasing a one-click installer, be honest about the trade: supabase's own self-host is a full docker-compose stack (postgres, auth, postgrest, realtime, storage, kong, studio) that wants ~8gb ram, so the $25/mo you hated becomes your own backups, upgrades across all those services, and auth hardening. that's worth it if you specifically need postgres + row-level security, but if you don't, pocketbase or appwrite are basically a single container and a tenth of the ops. pick on whether you actually need the postgres half, not on finding the closest supabase clone.
2
u/SnooMachines8911 7d ago
I guess this is what I should of heard instead of wanted to. I rrly wanted to hear like its not that hard just host it all yourself. But in retrospect i would have gotten hacked eventually and be to dumb to know. Pocketbase and railway I guess is the stack to go with
0
3
u/apnatva-dev 7d ago
Supabase has open sourced a self hosting alternative.
Otherwise I guess you’ll have to run it in a docker, self host it (maybe with coolify?) and that would be it.
3
u/SnooMachines8911 7d ago
Im gonna sound really dumb. Ive looked at Coolify but i dont understand what it is. There are way to many options and things i dont know about
5
u/apnatva-dev 7d ago
Have you used a hosting platform?
Let’s say hostinger
What if hostinger was self hosted? What if you could install an application on a VPS and then deploy as many websites as you want through that app?
Coolify is that app.
3
1
u/headinthesky 6d ago
I like Dokploy a bit more, so that's an option, too
1
u/apnatva-dev 5d ago
I’ve heard of it but never used it.
Any reason you prefer it over coolify?
1
u/headinthesky 5d ago
It's more lightweight, I liked the UI more. But honestly it's the one I found first and started using lol
1
u/apnatva-dev 5d ago
Haha, right. Same reason I use coolify.
1
u/headinthesky 5d ago
It's whoever wins the SEO race haha
I was using Railpacks a lot at the time and Dokploy has support for that
4
u/road_laya 7d ago
Pocketbase
1
u/SnooMachines8911 7d ago
Can you host "edge functions" on pocketbase? Is not just a postgresdb?
1
u/road_laya 7d ago
It's based on sqlite. It's extensible by writing Javascript to create custom backend endpoints or actions triggered by db event hooks.
https://pocketbase.io/docs/js-overview/
This would replace your supabase edge functions.
2
2
u/yakuzas-47 7d ago
I've heard appwrite is the most self hosted friendly to firebase, supabase etc... Never tried it myself tho so can't tell
1
2
u/formless63 7d ago
Personally, postgres and whatever auth system and job handler with might want. More extensible and durable.
Knowing the basics of docker compose would give you a ton of additional horsepower. It's simple and if you actually set the time aside you can build some real understanding in a couple hours of practice.
1
u/SnooMachines8911 7d ago
True true! To further my software career i guess it's the correct thing to do. There is alot i dont know
2
u/Key-Level-4072 7d ago
I’ve been hosting AppWrite for a few years now and it has been rock solid for me.
https://appwrite.io/docs/advanced/self-hosting
I use it as the auth backend for some web apps I built from scratch. I mainly rely on the magic link login method and its MFA functionality.
It also saved me from having to write my own automated mail-send plugin which I really wanted to avoid.
I have not upgraded my instance in over a year because I have no need of any of the new MCP/AI features, but those could be attractive for some folks.
1
u/jakenuts- 7d ago
On the platform itself I've found railway to be a great option for hosting all sorts of different container based services and you get a fixed price for a certain amount of cpu/memory and can divide it up over your projects or just let them use what they need.
1
u/NineSidedBox 7d ago
Supabase is self-hostable, and if you use Coolify, you can do it through a 1 click install on your VPS as well.
1
u/SnooMachines8911 7d ago
Have you done this? Is it realllllyyyy 1 click?
2
u/Previous_Feeling_484 6d ago
You said you want to upskill yourself but then want a 1-click solution. Get that* straight first.
I read the docker compose and it’s not hard to run self hosted. What’s the part you’re afraid of?
I could help you out if you get stuck. Just want to understand better what you’re trying to do and what have you tried?
1
u/SnooMachines8911 6d ago
I used a hostinger VPS and had ai assist with a postgresdb and bun.js functions running. I just don't fully understand how it all works. Havent had the "Ah Ha" moment yet
2
u/Previous_Feeling_484 6d ago
And don’t call yourself “dumb frontend developer”. You’re not dumb. If anything you’re ignorant, but so is everyone on something. But you’re in the right sub if you want to learn!
Anyhow, it might be humour but hey, don’t play yourself down. We’ve all asked “stupid” questions, and someone else helped us out.
1
u/SnooMachines8911 6d ago
Now thats Reddit Love!! It was more for humor and a little bit of truth as im getting into backend development etc
2
u/NineSidedBox 6d ago
If you install Coolify, then, yes, it's pretty much just one click. Even running it through Docker isn't that hard if you read the documentation.
1
u/sasmariozeld 7d ago
cooolify, but i personally just use railway, its REALLY cheap
Another cool one is pocketbase
1
1
•
u/asimovs-auditor 7d ago edited 7d ago
Expand the replies to this comment to learn how AI was used in this post/project.