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.
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
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.
Last updated