Hide navigation sidebar
Hide table of contents sidebar
Back to top
Toggle table of contents sidebar

# Create a SQL database

To get started, you need to have a SQL database available. If you already have one, please skip to the next section.

Note

For this example, we’ll use PostgreSQL, but you can follow a similar process for any supported SQL database.

## Install PostgreSQL

If it isn’t already available, install PostgreSQL version 9 or above. Take note of the host on which PostgreSQL is installed.

Tip

On macOS, we recommend using the Postgres App.

## Configure your PostgreSQL database

At a minimum you need a user and a database, as explained in the PostgreSQL guide. As a best practice, we recommend using schemas in order to administer multiple projects within a database.

For example, the sample code below creates the user `matthieu`, with password `Password`, and grants this user all privileges (can create and delete tables) in the `dku_churn` schema in the `dku` database. Similarly, user `dku_tshirt_admin` has been granted all privileges on the `dku_tshirt` schema in the `dku` database.

    psql -h localhost
    CREATE DATABASE dku;
    \c dku
    CREATE SCHEMA dku_churn;
    CREATE USER matthieu WITH PASSWORD 'Password';
    GRANT ALL PRIVILEGES ON SCHEMA dku_churn TO matthieu;
    CREATE SCHEMA dku_tshirt;
    CREATE USER dku_tshirt_admin WITH PASSWORD 'Password';
    GRANT ALL PRIVILEGES ON SCHEMA dku_tshirt TO dku_tshirt_admin;
    \q