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.