Anyone used Phoenix + Supabase?

Supabase:

I think it runs only on AWS now but they will have more providers as well.

I used fly’s postgres both version (nomad and machine or something like that). Very bad experience. Supabase was really good but also very expensive for just managed db. They have more good features so you have to pay for them even when you don’t use it.


For example scaleway has same amount of amount as Supabase (Large Add-on $100/m + 25 for paid service) this package and tbh it’s much much faster than on other service. They have good machines, faster than others providers with same numbers on papers.

Cheapest versions are pretty similar but 1 GB memory can be very low.

1 Like

For what’s it worth, Digital Ocean published a guide to host Supabase on your own Hosting Supabase on DigitalOcean :: DigitalOcean Documentation

Thanks for all the insights in this discussion on how each and everyone of you decides on what to use and not for your apps and stuff. It is a good reminder to me!

Because somewhere buried deep in my memories, every now and then one of the first BaaS solutions flashes up, which then suddenly changed strategy, and caused a lot of mobile app developers sleepless nights :wink:

I would suggest to use managed version of these kind of tools until cost of this service is bigger than cost of self-hosted solution (actual cost of 2 servers, time of installing it, secure it, maintain it).

Also great is when people select technology which can be used as managed service or self-hosted version. It gives them huge power. On the beginning you don’t have to care about huge infrastructure, maintenance and use managed solution. In case cost of managed solution increased you can still go to self-hosted, or even when provider will change pricing or close support for it or close stack itself (for example Google did it couple of times).

Not for me. I like my own db server, thank you very much.

Anyone who took this path, how did you manage DB migrations as in versioning database schema changes? thank you :pray:t3:

1 Like

Supabase has built in tools to handle migrations

Or, if you were using supabase as the pg db for say a phoenix app, you could lean on the migrations in your app if all the tables created are managed by ecto migrations.

I had been exploring adding supabase to a django app as an api, and background task processing, etc, and I am also going to explore the same with phoenix