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
  

The documentation continues in the Lepiter pages of the GToolkit4P3 project. You can load it with the following expression, after loading the code with expression above.

#BaselineOfGToolkit4P3 asClass loadLepiter
  

Continue reading in Using P3 to interact with the PostgreSQL Relational Database.