Supabase

As your database, you can use Supabase service.

In order to create a new Supabase database, just visit supabase.com and create a new account.

After your account is created, you will need to create a new project.

API Credentials

When your project is created, just visit Settings > API credentials section and copy your API key, secret and connection URL.

Then you will need to paste these 3 information into /api/.env file, in corresponding fields.

Connecting to database

Database connection and details are explained in official documentation, "connecting with PgAdmin" section.

Connecting to your database<!-- --> | Supabase Docs

You can find database connection details under Project Settings > Database page.

Importing Database

As the second step, SQL file must be imported into Supabase project. In order to do this, you will need a desktop SQL client. To name few desktop SQL clients

• https://tableplus.com/
• https://www.pgadmin.org/
• https://www.heidisql.com/

If you are familiar with command line you can also use pg_dump and pg_restore commands, as explained in article below.

https://snapshooter.com/learn/postgresql/pg_dump_pg_restore

After you connect to your Supabase database using your SQL GUI, choose your database and then choose 'import'.

Locate /install/database/supabase.sql file and click import.

To verify if import was successful, just visit Supabase project page, database > tables section.

Creating Users

Final step of database creation is creating users. To add new users in Supabase visit database > authentication tab. There you will find a list of current users.

You can create a new user with password for Windus.

Alternatively you can use Supabase credentials to login to WIndus.