PostgREST client for Python. This library provides an ORM interface to PostgREST.
Status: Unstable
- Python >= 3.7
- PostgreSQL >= 12
- PostgREST >= 7
$ poetry add postgrest-py$ pip install postgrest-pyimport asyncio
from postgrest_py import PostgrestClient
async def main():
async with PostgrestClient("http://localhost:3000") as client:
r = await client.from_("countries").select("*").execute()
countries = r.json()
asyncio.run(main())await client.from_("countries").insert({ "name": "Việt Nam", "capital": "Hà Nội" }).execute()r = await client.from_("countries").select("id", "name").execute()
countries = r.json()await client.from_("countries").eq("name", "Việt Nam").update({"capital": "Hà Nội"}).execute()await client.from_("countries").eq("name", "Việt Nam").delete().execute()$ git clone https://github.com/supabase/postgrest-py.git
$ cd postgrest-py
$ poetry install$ poetry run pytestRead more here.
Read more here.
We are building the features of Firebase using enterprise-grade, open source products. We support existing communities wherever possible, and if the products don’t exist we build them and open source them ourselves. Thanks to these sponsors who are making the OSS ecosystem better for everyone.