AnalyticDB:Supabase

Core features

Pricing

• Free Edition: A free tier with 1 vCPU and 2 GB of memory is available.

  Important

  The free project is for development and testing only. Do not use it in a production environment.

• Paid Edition: Creating a project incurs fees for compute and storage resources. For the pricing of different compute resource specifications, see Supabase. For a detailed breakdown of project charges, see the purchase page on the console.

Create a Supabase project

1. Log on to the AnalyticDB for PostgreSQL console.

2. In the upper-left corner of the console, select the region where the instance is located.

3. In the navigation pane on the left, click Supabase.

4. In the upper-right corner of the page, click Create Project, and select Create Project (Free Trial) or Create Project (Paid Plan).

5. Set the parameters.

   Create a free trial

   Parameter	Description
   Project Name	The name of the project.
   Zone	A zone is an independent physical area within a region. There is no significant difference between zones.
   Specifications	Select the project specifications.
   Database Account	Fixed at postgres.
   Database Password, Confirm Password	The password for the initial account. The password must meet the following requirements: Be 8 to 32 characters in length. Contain at least three of the following character types: uppercase letters, lowercase letters, digits, and special characters. The supported special characters are: !@#$%^&*()_+-=. Note After you create an instance, you can change the database password in the console or by calling the ResetSupabaseProjectPassword operation.
   VPC	Select the ID of the virtual private cloud (VPC). A VPC is an isolated network environment that offers higher security and better performance than a classic network. You must first create a VPC and a vSwitch in the same region as the instance.
   VSwitch	Select a vSwitch in the VPC. If no vSwitches are available, no vSwitch resources are available in the zone. You can switch to another zone or create a vSwitch in the current zone.
   Enable Whitelist Restriction	Select whether to enable the whitelist restriction.
   IP Address Whitelist	Set the IP addresses to add to the whitelist.

   Create with payment

   Parameter	Description
   Product Type	Select subscription or pay-as-you-go.
   Region and Zone	Select the region and zone. A zone is an independent physical area within a region. There is no significant difference between zones.
   Computing Resource Specifications	Select the size of the compute resource specifications. A specification with 4 GB of memory or more is recommended.
   Disk Storage Type	Select the disk storage class.
   Storage Resource Specifications	Select the size of the storage resource specifications.
   Project Name	Enter a project name. Important The project name must be unique.
   Reset Password	Set the password for the database. The password must meet the following requirements: Be 8 to 32 characters in length. Contain at least three of the following character types: uppercase letters, lowercase letters, digits, and special characters. The supported special characters are: !@#$%^&*()_+-=. Note The initialization password is the database password, not the logon password for the dashboard. After you create an instance, you can change the database password in the console or by calling the ResetSupabaseProjectPassword operation.
   Virtual Private Cloud (VPC)	Select the ID of the VPC. A VPC is an isolated network environment that offers higher security and better performance than a classic network. You must first create a VPC and a vSwitch in the same region as the instance.
   VSwitch	Select a vSwitch in the VPC. If no vSwitches are available, no vSwitch resources are available in the zone. You can switch to another zone or create a vSwitch in the current zone.
   Resource Group	Select a resource group.

6. Confirm the parameter configuration and complete the project creation.

   • For a free test project: Click OK.

   • For a paid project: Click Buy Now, confirm the order information, and click Activate Now.

Use a Supabase project

1. Log on to the Supabase Dashboard.

   1. In the Actions column of the target instance, click Manage.

   2. Copy the logon account and logon password, and then click Go to. You are redirected to the Supabase Dashboard logon window.

   3. Enter the username and password to log on to the Supabase Dashboard.

   

2. Obtain API keys.

   • Obtain the anon key for database operations such as create, read, update, and delete (CRUD).

     1. In the upper-left corner of the Supabase Dashboard, click Connect.

     2. In the pop-up window, click App Frameworks to obtain the SUPABASE_URL and SUPABASE_ANON_KEY of the Supabase instance.

     

   • Obtain the service role key for operations such as identity verification and authorization.

     1. In the navigation pane on the left of the Supabase Dashboard, click API Docs.

     2. Click Introduction > Bash, and set Project API Key to service_role(secret).

        

     3. Click Authentication to obtain the SERVICE KEY.

        

3. Use the instance.

   Important

   Store API keys in environment variables to avoid hardcoding them in your code and reduce the risk of leaks.

   • Manage the database using the Supabase RESTful API.

     You can perform CRUD operations on the database at https://<SUPABASE_URL>/rest/v1/. For example, to query the users table in the database, run the following command:

     curl 'http://<SUPABASE_URL>/rest/v1/users'-H "Authorization: Bearer <anon key>" -H "apikey: <anon key>" -H "Content-Type: application/json"

   • Manage features such as user registration and identity verification using the Supabase Auth API.

     For example, to query all users in the database, run the following command:

     curl 'http://<SUPABASE_URL>/admin/users' -H "Authorization: Bearer <service role key>" -H "apikey: <service role key>" -H "Content-Type: application/json"

Manage a Supabase project

Delete a Supabase project

In the Actions column of the target instance, click Release. In the pop-up window, click OK.

Related APIs

FAQ

curl -X PATCH https://<project_domain>/auth/v1/modify/settings \
  -H "Content-Type: application/json" \
  -H "Authorization: Bearer <SERVICE_ROLE_KEY>" \
  -H "apikey: <SERVICE_ROLE_KEY>" \
  -d '{"jwt_exp": 7200}'

curl https://<project_domain>/auth/v1/settings \
  -H "Authorization: Bearer <SERVICE_ROLE_KEY>" \
  -H "apikey: <SERVICE_ROLE_KEY>"