IST Data Base and Data Mining Lab Repo

The Relational models using PostgreSQL

Teaching Assistants: Mohamed Ragab and Fabiano Spiga

Practice Session slides

Instructions

Use GitHub Codespaces

Codespaces natively support Visual Studio (both remotely via browser or locally via ssh connection).

Follow this guide to create the codespace for the repository.

The you can operate directly in visual studio.

Local Installation

Installing "Python", "Jupyter Notebook", and "PostgreSQL".

Windows Users:

Install Python(3+) and Jupyter Notebook (on windows):
- Python, Jupyter
- Recommended Option: Install Anaconda
Install PostgreSQL on windows:
- Please, [Download] (https://www.enterprisedb.com/downloads/postgres-postgresql-downloads) and Install PostgreSQL for all platforms
- Follow this tutorial (https://www.postgresqltutorial.com/install-postgresql/) for more details (Windows installation).

For Linux users:

For installing Anaconda on Linux
- Then, you can execute the command $ jupyter notebook to launch Jupyter notebook on your Linux machine.
If you want to install PostgreSQL on Linux:
- Tutorial

Docker users

Simply clone the repository and run

```docker-compose up``

The following docker compose file will build the notebook container which includes all the required dependencies. Services are also exposed to the host network so you can connect to the via localhost

Open Jupyter

version: "3"

services:
  postgres:
    image: postgres
    restart: always
    ports:
        - 5432:5432
    environment:
      - POSTGRES_HOST_AUTH_METHOD=trust
  notebook:
    build: notebook/
    ports:
      - 8888:8888
    volumes:
       - ./:/home/jovyan/work/data
    environment:
      - GRANT_SUDO=yes

riccardotommasini/istdbdm