postgrest-ex
postgrest-ex copied to clipboard
[PostgREST] Integrate with Ecto
Users can already use the direct connection with their Postgresql instance on Supabase, however, an additional PoC feature could be to implement an Ecto.Adapter for PostgREST.
Also, we possibly could generate schemas/relations/migrations and also some basic CRUD functions based on the schema of the database instance of supabase.
Finally, maybe would be interestig to implement DSL that is independent from ecto to interact directly with PostgREST
Piorities:
- generate ecto schemas based on supabase database schema
- create an
Ecto.Adapter(?) - implement DSL (?)
(?) - only a PoC for now
It's going to be slower for an Elixir app to go through PostgREST all the time vs a native Postgres connection.
It would be v nice to have the RLS context set for you on all Ecto queries tho.
This way if you use a Supabase HTTP API or direct connections via Ecto you can ensure users always only see the data they should see based on your RLS policies.
now we move this package to under the supabase-community org, i can focus more on planning new features