cvkmohan

cvkmohan

Hello, https://supabase.com is a big success in the Javascript world as a Firebase alternative. For whatever reasons, Supabase is completely focused with integrations with JS frameworks.
What caught my attention is the global CDN nature of Supabase hosting. Though, we can do a single click deploy of phoenix applications on https://fly.io, database hosting is still an issue. Though, Fly supports for easy deployment of Postgres, it is not managed hosting. Database backups, recovery etc. are our headache.
Considering all this scenarios, is Supabase a good alternative for database operations in our LiveView application? Ofcourse, Supabase provides even File Storage as well - which Fly does not give.
So, Fly Hosting for Phoenix Application - Supabase for Database and File Storage - can it be a good stack for production apps?
I had this doubt for sometime - but - zoedsoupe/supabase: A complete Toolkit to interact with Supabase APIs from Elixir (github.com) - triggered those thoughts again.
I request you to offer your views- pros and cons.

Showing Posts 1 to 3

olivermt

olivermt

Doesnt supabase expose a postgres interface you can talk to from the server directly?

adw632

adw632

Yes, the standard Ecto Postgres support should work as Superbase provides a Postgres interface, meaning anything that talks to Postgres can talk to Superbase.

zoedsoupe

zoedsoupe

that’s a good question tough! i mean, i started supabase-potion because i would like to use the storage and go true services exactly on phoenix/live view.

that said, the library aims to provide a good interface for supabase APIs, so in my opinion, as others already said, you can connect directly to the database on supabase and use ecto!

i’m thinking if it would make sense to provide a postgrest interface, you can also check the discussion in this thread: Would it be possible to implement an Ecto adapter for PostgREST?

but supabase in general fits greatly with phoenix, specially if you want file storage and if you don’t need/don’t want to handle server authentication in your side!

— All posts loaded —

Where Next? Top

Trending in Discussions Top

AstonJ
As the title says, please share what you’ve been up to with Elixir. Whether that’s been learning it, looking into it, making stuff with i...
2977 91898 914
New
AstonJ
The obligatory hello world thread! Who are you and where are you from? :stuck_out_tongue:
4616 55835 594
New
byu
@chrismccord : I just saw the Extract AGENTS.md from Phoenix.new into phx.new generator commit to the phoenix project. My initial shotgu...
New
arcanemachine
I was working on an Ecto migration and I needed a timestamp. So, for the nth time, I looked up the different data types for timestamps, a...
New
alexslade
Fly’s CEO posted this recently - Turn And Face The Strange · The Fly Blog It says that Fly is going all-in on sprites, which is a worry ...
New
Herve37
We’re evaluating API mocking tools for OpenAPI-based projects and would love to hear what other teams are using. We’re particularly inte...
New
matt-savvy
Is there a word for the ~> symbol used in Version strings? Do you also just call it a Squiggle Arrow™ ?!
New

Other Trending Topics Top

JesseHerrick
Hey, I’m Jesse and I’m the main contributor behind Dexter, a full-featured, lightning-fast Elixir LSP optimized for large codebases. It s...
New
jimsynz
Beam Bots (or just BB for short) is a framework for building fault-tolerant robotics applications in Elixir using familiar OTP patterns. ...
New
mcass19
ExRatatui lets you cook up rich terminal UIs in Elixir, powered by Rust’s ratatui via Rustler NIFs. Build interactive terminal applicatio...
New
Damirados
Hello everyone. After busy few months I am happy to announce v0.1.0 of Emerge & Solve. They are GUI (Emerge) and State management (S...
New
netoum
Corex is an accessible, unstyled UI component library for Phoenix that integrates Zag.js state machines using Vanilla JavaScript and Live...
New
ausimian
Emily is an Elixir library that runs Nx computations on Apple’s MLX. Install it as the default Nx backend and Nx, defn, Axon, Nx.Serving,...
New

We're in Beta

About us Mission Statement

Options

Thread Display Mode




Thread Preview

Skip Thread Previews