PostgreSQL

From HTML5 Builder
Jump to: navigation, search

PostgreSQL is an open source relational database management system.

There are different technologies you can use to access PostgreSQL from web applications developed with HTML5 Builder:

Installation

Client

Download the PostgreSQL Installer from here, and run it.

You must also tweak your PATH environment variable:

  1. Open Environment Variables dialog:
    • On Windows Vista, Windows 7 and Windows 8: Go to Start, right-click Computer, click on Properties, open Advanced system settings link on the left sidebar, and click Environment Variables… at the bottom of the page.
    • On Windows XP: Right-click My Computer, then click Properties, go to the Advanced tab and click Environment variables.
  2. On the System variables section, select the entry for PATH and click Edit….
  3. Add the path to the bin folder inside PostgreSQL’s installation directory at the end of your PATH environment variable, separated from the previous content with a semicolon (previous\paths;new\path).

PHP PDO Extension

Enable the extension by uncommenting (removing the ; at the beginning) the following line in PHP’s configuration file (php.ini):

;extension=php_pdo_pgsql.dllextension=php_pdo_pgsql.dll

PHP Extension

Enable the extension by uncommenting (removing the ; at the beginning) the following line in PHP’s configuration file (php.ini):

;extension=php_pgsql.dllextension=php_pgsql.dll

Configuration

Tip: You can use the Data Explorer to configure your PostgreSQL connections the RAD way.

To use a Database component with PostgreSQL, configure it with the following property values:

  • DriverName: postgres.

Then fill the rest of the mandatory properties as required.

Help Resources

Documentation

Frequently Encountered Problems

Unable to load dynamic library

PHP Warning: PHP Startup: Unable to load dynamic library '<HTML5 Builder installation path>\ext\php_pgsql.dll' - Cannot find the specified module

If you run into this, you most probably forgot to configure the PATH environment variable.

See Also

Personal tools