zoedsoupe

zoedsoupe

Hello alchemists! I’m here to present about a new way to interact with Supabase services: supabase-potion made with love and magic by @zoedsoupe :purple_heart:

What it is?

supabase-potion is a client library that provides a developer-friendly interface to interact with various of Supabase services. It highly integrates with OTP, meaning that it can handle thousands of different clients/connections.

It also provides friendly error messages and error return from all functions, meaning that you can simply pattern match on all pre-discovered error messages/error codes from Supabase APIs.

Finally, the idea behind this client library is to provide a similidar API as those other Supabase clients for Go,Javascript, Rust and other, in the meaning of quality, folowwing good practices of the language itself and provide a composable interface.

Why another Supabase client library?

There is also some offical attempts to provide Supabase integration in the elixir world, like:

Which are awesome libraries! However they have some negative points, like:

  • doesn’t provide a friendly way to integrate each library with each other
  • doesn’t use OTP benefits, supervision trees or concurrency, they seem to be done on a scripint language
  • packages seem to be unmaintained/have no more updates
  • Supabase Realtime and UI (for Live View) are missing implementation
  • GoTrue is missing some important functions and doesn’t have integration with Plug and Live View hooks
  • Storage implementation is incomplete and doesn’t support uploads/downloads with async/streams
  • PostgREST is missing a bunch of functions and doesn’t integrate with ecto

So seeing these points I decided to create my own client library and share with others who would like to test/use Supabase services from our Phoenix applications or other future libraries.

What is currently done?

Supabase Potion

Where all starts! Define client management with DynamicSupervisor and the basic strucutre to interact with other services!

  • init_client/1
  • init_client!/1

To start a client, if the library itself is managing clients, you can safely use:

iex> Supabase.init_client %{name: MyClient}
{:ok, #PID<1.2.3>}

You can also mannually start/manage clients with:

iex> Supabase.Client.start_link(%{name: MyClient})
{:ok, #PID<1.2.3>}

Supabase Storage

The file storage service from Supabase, now completely available to Elixir/Phoenix users! All these functions receive a Supabase.Client definition (either an atom or a pid).

  • the implementation is complete, handles async uploads and downloads from buckets!
  • complete mapping of entities like %Object{} and %Bucket{}

The complete list of current functions are:

Buckets

  • list_buckets/1
  • retrieve_bucket_info/2
  • create_bucket/2
  • update_bucket/2
  • empty_bucket/2
  • delete_bucket/1

Objects

  • remove_object/3
  • move_object/4
  • copy_object/4
  • retrieve_bucket_info/3
  • list_objects/4
  • upload_object/5
  • download_object/3
  • download_object_lazy/3
  • save_object/3
  • save_object_stream/3
  • create_signed_url/4

Supabase Auth/GoTrue

Provide authentication via:

  • email+password
  • oauth
  • otp codes
  • magic links

Also integrates for authentication with Plug and Live View hooks!

Current functions are:

User API

  • get_user/2
  • sign_in_with_password/2
  • sign_up/2

Admin API

  • sign_out/3
  • invite_user_by_email/3
  • create_user/2
  • generate_link/2
  • delete_user/3
  • get_user_by_id/2
  • list_users/2
  • update_user_by_id/3

Plugs

  • VerifyHeader

Roadmap

GoTrue/Auth

  • Finish integration (User API)
  • Implement VerifyCookie Plug
  • Implement VerifySession Plug
  • Implement :ensure_authenticated Live View hook
  • Implement :redirect_if_authenticated Live View hook
  • Implement :mount_current_user Live View hook

Supabase UI

  • Provide function components for Live View
  • Provide Live components for Live View
  • Provide Auth ready-to-use components for Live View

Supabase PostgREST

  • Generate schemas/migrations based on Supabase database schema
  • Provide an way to integrate with ecto via Ecto.Adapter (it’s being discussed in this thread)

Supabase Realtime

  • Provide PubSub adapter for realtime messages
  • Provide Process Messaging adapter to send to whole system

Conclusion

That’s it! I’m really proud of this client library and I really would like people to use, test and contribute in any way to the project! It stills on high development, so expect breaking changes. There are always something to improve, so I’m open to any kind of contribution such as: testers, documentation, code review, feature request and other types of contribution.

Showing Posts 1 to 6

hauleth

hauleth

404 on repo

zoedsoupe

zoedsoupe OP

i have some good news! I just launched new updated and refactored versions for the aforementioned hex packages, targeting the base SDK (aka supabase-ex) implementation.

to summarize, i simplified the client initialization and move the decision to manage OTP processes for the final user, as it should be! this should also prevent strange errors on starting and using clients but also clarify the documentation on how to start a client, as in the later version it had around 3 ways to start a client…

so basically, the current state for each library and my current roadmap is (very summarized):

supabase-ex

  • easy manipulation, configuration and initialization of clients
    • supports all available configuration options as supabase-js
    • provides a pre defined “high-level” http client for supabase APIs (it should be refactored in some points)

it have a total of 2422 downloads on hex

postgrest-ex

  • follows the standard of postgrest-js and postgrest-go with composable and “lazy” query and filter builders
  • have good error mapping structure
  • can not only execute queries and return JSON response but also can parse to an Ecto schema/struct
  • good test coverage

it have a total of 242 downloads on hex
elixir community will very often prefer to connect to the postgresql instance directly with ecto

storage-ex

  • handle all bucket operations
  • handle all object operations
    • with addition of stream upload
    • with addition of stream download

it have a total of 802 downloads on hex
for some time the package was broken on hex :confused:

gotrue-ex

  • it have Plug applications support (plug middlewares)
  • it have Phoenix.LiveView applications support (hooks)
  • implements password reset email
  • implements resend of confirmation email
  • implements user update (also admin API)
  • implements signup flow
  • implements user creation (admin)
  • implements signing in with
    • id token
    • oauth
    • otp
    • email and password
    • sso
  • implements sign out (admin)
  • implements email invitation and link generation (eg. any verification type) (admin)
  • implements user management (deletion, list, get by id, update by id) (admin)

it have a total of 1738 downloads on hex

Roadmap

Said that, i would like to tackle these next features:

  • Supabase.UI library for Phoenix.LiveView
  • Supabase Realtime library and integration
    • as the realtime project is also in Elixir, i was discussing with @filipecabaco about the possibility to create adapters for PubSub and or process messaging to receive updates, besides the API integration
  • Implements anonymous sign in on gotrue-ex
  • Improvements and refactors on the PKCE flow on gotrue-ex
  • integration with Ecto via custom adapter to be able to use Ecto.Query
    easily on postgrest-ex
Wojciech

Wojciech

Nice project, how easy is it to migrate from postgresql and MinIO(S3) to selfhosted supabase? Currently i use req_s3 for interacting with s3 and traditional setup for postgres, if i use your library do i have to switch to your solution for s3 interactions? I would also appreciate any example projects if you have any :slight_smile:

Thanks for your work!

zoedsoupe

zoedsoupe OP

So cool! Let’s break on smaller parts:

From the beginning: Supabase is an open source alternative for Firebase but it do can be used from backend servers

PostgreSQL

Supabase offers a dedicated postgresql instance that you can interact with many ways. For elixir/phoenix applications i really recommend to just grab the connection config and link directly with Ecto!

but if eventually you would like to test or build only a “client side app” with live view, you could use the postgrest-ex library that interact with your database instance via HTTP (trough PostgREST project)

MinIO/object storages

Supabase also offers the Supabase Storage feature, the good news is that it supports the S3 protocol, so you don’t need to use storage-ex, you can use directly req_s3 or even ex_aws for S3 services

Self hosting

You can easily self host supabase instances based on their docker-compose, like said is this tutorial: Self-Hosting | Supabase Docs

Conclusion

This library aims to provide an easy, plug n play way to interact with supabase! Also, i do want to build example applications to demonstrate each integration, that’s on the roadmap too

Wojciech

Wojciech

Thanks :+1:

— All posts loaded —

Where Next? Top

Trending in Announcing Top

woylie
Flop is an Elixir library that applies filtering, ordering and pagination parameters to your Ecto queries. offset-based pagination with...
New
MRdotB
I needed to reuse React components from my Chrome extension in my Phoenix/LiveView backend. I noticed that for Svelte/Vue, there are live...
New
woylie
I released Doggo, a collection of unstyled Phoenix components. https://github.com/woylie/doggo Features Unstyled Phoenix components....
New
marciok
Hi there! We created Gust: A task orchestrator inspired by Airflow. For those who have never heard about Aiflow, it’s a Python-based wor...
New
anuaralfetahe
Hello Published a new library - ProcessHub! ProcessHub is a library designed to manage process distribution within the Elixir cluster. ...
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
Dmk
Xamal is a deployment tool for Elixir apps that deploys native releases to bare metal servers over SSH. It’s a port of GitHub - basecamp/...
New

Other Trending Topics Top

mudasobwa
I am happy to introduce the very α version of the new programming language compiled to BEAM. Welcome Cure. It has literally three kille...
New
webofbits
With AI doing more of the implementation work, I’ve been wondering how much coding I should deliberately keep doing myself. My main conc...
#ai
New
sergio
It’s not that it’s vocabulary is too advanced. It’s something worse. I get lost trying to follow even a paragraph written by Claude. It’...
New
AstonJ
This showed up on my feed.. anyone heard of it? Just hype? Ox Alpha is a reasoning model designed for coding, sustained ag...
New
bartblast
Hey folks, I just published a post about Hologram’s funding and where the project goes next - the short version: Curiosum as Main Spons...
New
sorenone
Today we’re releasing Oban for Python. Not an Oban client in Python. Not a pythonx wrapper embedded in Elixir. Nope, it’s a fully operati...
New

We're in Beta

About us Mission Statement

Options

Thread Display Mode




Thread Preview

Skip Thread Previews