Open topic with navigation

Connecting with PostgreSQL

The automatic of Scriptcase already comes with the PostgreSQL PDO enabled.

To do the connection with PostgreSQL, please follow the steps below.

Open topic with navigation

Drivers PostgreSQL

Currently Scriptcase offers four drivers to connect with the PostgreSQL databases: PostgreSQL PDO, PostgreSQL 7 or Higher, PostgreSQL 6.4 or Higher e PostgreSQL 6.3 or Lower.

You can see the features below:

PostgreSQL PDO ( Recommended ) : Allows the connection to be made with the PostgreSQL using the native PHP driver, which is superior in processing speed and constantly updated.

PostgreSQL 7 or Higher : Allows the connection to be made and use the new functionalities of the PostgreSQL 7 or Higher databases.

PostgreSQL 6.4 or Higher : Allows the connection to be made and use the new functionalities of the PostgreSQL 6.4 or Higher databases.

PostgreSQL 6.3 or Lower : Allows the connection to be made and use the functionalities of the PostgreSQL 6.3 or Lower databases.

Creating a connection on Scriptcase

Connecting to PostgreSQL from Scriptcase

Open topic with navigation

Now we’ll access Scriptcase from Scriptcase from the browser and create a connection with the PostgreSQL database.

Step 1: Access your Scriptcase, for example, http://localhost:8081/scriptcase/ on the toolbar go to the marked icon in the image below, referring to “New Connection”.

Step 2: After clicking “New Connection”, the page for creating connections will appear, click on the PostgreSQL database image.

Step 3: On the following image, place the required information:

For more details on configuring the connection of the database click on Advanced

Filter - By clicking on this tab, you will see this page:

Step 4: Always test your connection before saving, if the message “Connection Success” appears, then save the connection. If it fails to connect, revise the fields that were informed, especially Username, Password, Database and Server/Host.

Verify if the module is enabled in the diagnosis.