Pip install psycopg2 full#

A 'direct connection' is Postgres' native connection system.We recommend using these wherever possible. You can use these for all browser and application interactions. The Serverless APIs provide programmatic access and have built-in connection pooling.Find your Connection Info and Connection String.You can find the connection pool config in the Database settings inside the dashboard:

For example, if you are using Prisma, Drizzle, Kysely, or anything deployed to a Serverless environment (AWS Lambdas or Edge Functions). A connection pooler is useful for managing a large number of temporary connections. Direct connections are on port 5432.Įvery Supabase project comes with PgBouncer for connection pooling. You can find the connection string in the Database settings inside the dashboard: You can connect to the database using any tool which supports Postgres.

Pip install psycopg2 full#

Realtime: listen to database changes over websockets.Įvery Supabase project provides a full Postgres database.GraphQL: interact with your database through a GraphQL interface.REST: interact with your database through a REST interface.

We provides several types of API to suit your preferences: This is the easiest way to get started if you are managing data (fetching, inserting, updating).

Programmatic access using the Serverless APIs.

Direct connections using Postgres' standard connection system.

Supabase provides several options for programmatically connecting to your Postgres database: