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