Working with the PostgreSQL relational database

One of the most popular open source relational databases is PostgreSQL. This case study shows how to connect to a PostgreSQL database and how to explore and visualise both the data and structure. The demo implements two approaches to work with the data from the database.

The PostgreSQL client in GToolkit is called P3. It is augmented in GToolkit in various ways.

Installation

The necessary code for the demo including all its dependencies can be loaded using the following expression.

Metacello new
   baseline: 'DemoP3F1';
   repository: 'github://feenkcom/gt4p3';
   load.
#BaselineOfGToolkit4P3 asClass loadLepiter
  

The documentation continues in the Lepiter pages of the GToolkit4P3 project. Continue reading in Using P3 to interact with the PostgreSQL relational database.