Setup-Diesel-with-PostgreSQL

DB EXPERIENCE WITH RUST DIESEL POSTGRESQL AND WITHOUT FEAR OF SUCCESS

Installation of PostgreSQL

sudo pacman -Syu postgresql

Installation of diesel

[https://diesel.rs/guides/getting-started] here

Installation of rust

[https://www.rust-lang.org/tools/install] here

ProgreSQL Setup

Open as postgres user

sudo -iu postgres

Initializing the database of regional and specify dirs to save db datas in this case /var/lib/..

initdb --locale $LANG -E UTF8 -D '/var/lib/postgres/data'
exit

Startup the service

Starting postgres service

sudo systemctl start postgresql

Setup to running when the os is initializing

sudo systemctl enable postgresql

Get access on PostgreSQL and make the DB

sudo -iu postgres
psql

Make a database and user

CREATE DATABASE my_own_db;
CREATE USER diesel_user WITH PASSWORD 'default';
GRANT ALL PRIVILEGES ON DATABASE my_own_db;

(!) Important step, you need specify that you are also the owner of the db in addition to having the permissions.

ALTER DATABASE my_own_db OWNER TO diesel_user;
\q
exit

Inicializar Diesel and make a table

Set enviroment vars on files

echo "DATABASE_URL=postgres://diesel_user:default@localhost/my_own_db" >> .env
diesel setup