Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[PostgREST] Integrate with Ecto #3

Open
zoedsoupe opened this issue Sep 16, 2023 · 3 comments
Open

[PostgREST] Integrate with Ecto #3

zoedsoupe opened this issue Sep 16, 2023 · 3 comments

Comments

@zoedsoupe
Copy link
Collaborator

zoedsoupe commented Sep 16, 2023

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:

  1. generate ecto schemas based on supabase database schema
  2. create an Ecto.Adapter (?)
  3. implement DSL (?)

(?) - only a PoC for now

@zoedsoupe zoedsoupe changed the title Integrate with PostgREST supabase interface [PostgREST] Integrate with Ecto Nov 20, 2023
@chasers
Copy link

chasers commented May 15, 2024

It's going to be slower for an Elixir app to go through PostgREST all the time vs a native Postgres connection.

@chasers
Copy link

chasers commented May 15, 2024

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.

@zoedsoupe zoedsoupe transferred this issue from supabase-community/supabase-ex Dec 9, 2024
@zoedsoupe
Copy link
Collaborator Author

now we move this package to under the supabase-community org, i can focus more on planning new features

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants