chore: Setup PostgreSQL DB

[khwilo]

Description

Setup PostgreSQL as the database of choice

TODO

• [x] Remove the default SQLite database
• [x] Create the database, username & password
• [x] Migrate the tables to the database

Implementation

Create a database:

CREATE DATABASE baraza;

Create a user with a password:

CREATE USER dembe WITH PASSWORD 'ov6$*tPsH&be';

Grant privileges to the database for the created user:

GRANT ALL PRIVILEGES ON DATABASE baraza TO dembe;

Give permissions for user dembe to create new databases

ALTER USER dembe CREATEDB;