Supabase

Introduction to Supabase

Supabase is a backend-as-a-service (BaaS) platform that provides a PostgreSQL database, authentication, storage and real-time APIs. It is an open-source alternative to Firebase, but with support for the powerful PostgreSQL database.

Why use Supabase?

Supabase is ideal for developers who want to build modern applications quickly, without giving up flexibility and control over the backend.

Step by step: integrating Supabase with NicoChat

NicoChat lets you integrate a PostgreSQL database in a simple way, so that you can manage data directly in the system. To connect Supabase to NicoChat, follow the steps below:

1. Set up the Database in Supabase

1.1. Access the Supabase dashboard:

• Create an account on Supabase or log in.
• Create a new project.

• Enter the organization, the project name and the project password. Save this password, as it will be needed later.

1.2. Get the connection details:

• After creating the project, click “Connect” on the top tab.
• Click “View parameters” and find the connection information:
  host: Hostport: Port (usually 5432 for PostgreSQL)database: Database Nameuser: User (default: postgres)

1.3. Get the SSL certificate:

• After copying the details, close the window and go to Settings > Database.
• Look for the SSL Certificate and click “Download certificate”.
• Open the downloaded file with a text editor, such as “Notepad”, and copy all of the content.

2. Set up the Integration in NicoChat

• Save the configuration: After filling in the fields, click Salvar to complete the integration.

3. Accessing the tables

To learn more about the integration and about accessing tables in NicoChat, go to nicochat.atlassian.net/wiki/spaces/NicoChat/embed/212959485.