Nóta
Teastaíonn údarú chun rochtain a fháil ar an leathanach seo. Is féidir leat triail a bhaint as shíniú isteach nó eolairí a athrú.
Teastaíonn údarú chun rochtain a fháil ar an leathanach seo. Is féidir leat triail a bhaint as eolairí a athrú.
Learn how to connect to your database using various clients and authentication methods. For managing Lakebase infrastructure (creating projects, branches, computes), see Project permissions.
Connection basics
| Topic | Description |
|---|---|
| Connection quickstart | Connect with OAuth or Postgres passwords. |
| Connection strings | Connection string formats, components, and network configuration. |
| Connection pooling | Reduce connection overhead with the built-in PgBouncer pooler. |
| Framework examples | Code examples for Python, JavaScript, .NET, Go, and other languages. |
| Authentication | OAuth tokens, Postgres passwords, token rotation, and connection timeouts. |
Roles and permissions
Set up database access by creating Postgres roles and granting permissions:
| Topic | Description |
|---|---|
| Manage Postgres roles | Create OAuth and password-based Postgres roles for database access. |
| Manage permissions | Grant database permissions to Postgres roles using SQL GRANT commands. |
Note
Postgres roles control database access (who can query data). For project permissions (who can manage infrastructure), see Manage project permissions.
Connect an application
| Topic | Description |
|---|---|
| Build applications | Azure Databricks Apps or external applications using Postgres drivers. |
| Data API | Access your database over HTTP using a PostgREST-compatible REST interface. No Postgres driver required. |
Postgres clients
Connect to your database using standard PostgreSQL client tools:
| Client | Description |
|---|---|
| psql | PostgreSQL's built-in command-line client for interactive database access. |
| pgAdmin | Graphical administration tool for managing databases and running queries. |
| DBeaver | Universal database tool supporting multiple database types. |
For more information about using Postgres clients, see Postgres clients.
Built-in tools
Use Lakebase's built-in tools to query and manage your database:
| Tool | Description |
|---|---|
| SQL Editor | Run queries and manage database objects using the web-based SQL editor. |
| Tables editor | View, edit, and manage data and schemas through a visual interface. |
Private connectivity
| Topic | Description |
|---|---|
| Private Link for Lakebase Autoscaling | If your workspace uses Private Link, you need two endpoints: inbound Private Link for API access and inbound Private Link for performance-intensive services for Postgres database connections. |