12/30/2023 0 Comments Tableplus serialYou can use these simple questions to determine which connection method to use: Why would you use a connection pool? Primarily because the way that Postgres handles connections isn't very scalable for a large number of temporary connections. You should use this for serverless functions and tools which disconnect from the database frequently, like Prisma, Drizzle, Kysely, etc. A "connection pooler" is a tool which keeps connections "alive".You should use this for tools which are always alive - usually installed on a long-running server, like Node.js, Ruby, Python, etc. 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 Data 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: A connection pooler is useful for managing a large number of temporary connections - for example, if you are using Prisma, Drizzle, Kysely, or anything deployed to a Serverless environment (AWS Lambdas or Edge Functions). Find your Connection Info and Connection String.Įvery Supabase project comes with a connection pooler for managing connections to your Postgres database.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. 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 provide several types of API to suit your preferences: These are the easiest way to get started if you are managing data (fetching, inserting, updating). Supabase provides auto-updating Data APIs. Connection pooling for scalable connections.Direct connections using the built-in Postgres connection system.Programmatic access using the Data APIs. Supabase provides several options for programmatically connecting to your Postgres database:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |