Setup Postgres¶

Installation¶

Mac¶

The quickest way to get Postgres up and running on the Mac is using Postgres.app.

Ubuntu¶

On Ubuntu you can use apt.

sudo apt update
sudo apt install postgresql

Creating a database¶

Mac¶

psql¶

Postgres.app should make psql available for the user who installed it.

psql

Enter the following:

CREATE DATABASE "my_database_name";

pgAdmin¶

If you prefer a GUI, pgAdmin has an installer available.

Ubuntu¶

psql¶

Using psql:

sudo su postgres -c psql

Enter the following:

CREATE DATABASE "my_database_name";

pgAdmin¶

DEB packages are available for Ubuntu.

Postgres version¶

Piccolo is tested on most major Postgres versions (see the GitHub Actions file).

What about other databases?¶

At the moment the focus is on providing the best Postgres experience possible, along with some SQLite support. Other databases may be supported in the future.