Project to create PostgreSQL database, model and normalize goodreads dataset, then load data to db and once set up to run some analytic queries.
Requirements: active Postgres server
and Postgres client
installed.
Dataset was downloaded from here.
After cloning this repo follow these steps:
Option 1 Step by step from CLI. In repo folder run:
./0_data-preparation-cleaning.ipynb
./1_create_db.sh
./2_create_load_tables.sh
./3_create_table_relations.sh
./4_queries_in_booksDB.ipynb
Option 2 Restore database from file. In CLI run.
- login to Postgres
$ psql --host=localhost --port 5432 --username=zivile --password --dbname=books
password to usezivile123
You can explore DB books from your favorite GUI Client like pgAdmin
, DBeaver
or other or directly from psql
client.