Anyone used Phoenix + Supabase?

cloutiy

Hello,

I’m wondering if anyone has made a project using supabase.io for the database layer.

Supabase is a backend as a service which provides storage, user management, authentication and more.

I recall it’s built with Elixir, or at least some pieces of it.

However oddly enough looking at the examples page and available client APIs, Elixir doesn’t seem to be on the list .

45 comments

/phoenix #supabase

2 9776 45

2024-01-16 16:39:18 UTC

First Post!

ruslandoga

I think it’s targeted at frontend devs as a replacement for some of backend functionality, hence the firebase mention.

You can utilise the same tech-stack in your phoenix app as the supabase server, I think there were some recent commits that make it possible to subscribe for logical replication using postgrex.

Add Postgrex.Replication by josevalim · Pull Request #575 · elixir-ecto/postgrex · GitHub
before the PR above, GitHub - cainophile/cainophile · GitHub was used by some people, including supabase/realtime, while googling for it I even found a tutorial: https://www.stackbuilders.com/tutorials/elixir/todo-with-postgresql-cdc-phoenix/

Post #1

Most Liked

adrianbarbic

They actually discussed in this podcast the other day (https://thinkingelixir.com/podcast-episodes/073-elixir-at-supabase-with-paul-copplestone/) about not having example for elixir. But as mentioned here, since you already use elixir/phoenix you get a similar offering, where as, their main market is frontend (ie. react) so competing against Firebase.

Also, thinking elixir does some great podcasts: Thinking Elixir Podcast

Post #4

LostKobrakai

Tbh I really like that this community is mostly going the other direction: Being considerate in not putting any solution on a throne, but rather discussing tradeoffs in possible solutions. I personally would consider CrunchyBridge the much more sensible managed database hosting, as it’s to my knowledge plain postgres with common open source extensions. Limit the amount of vendor specific stuff as much as possible. But that’s what I care about in terms of tradeoffs. Others might decide differently.

Post #28

cpursley

@chasers, it looks like logflare.app is joining forces with Supabase (according to their blog)?

I’ve actually extracted out the WAL listening stuff from Supabase Realtime (which is based on Cainophile) into a package: GitHub - agoodway/walex: Postgres change events (CDC) in Elixir [WAL] · GitHub

I’ve been using this along with Hasura (Supabase wasn’t around when I started) so that I can handle business logic right in Elixir. The main differences are that I’ve added a supervisor to process Events and I’m casting to Elixir types instead of Json.

Post #10

Last Post!

samrose

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

Post #45