hhvm-pgsql: A C++ repository from molchanoviv

Postgres Extension for HipHop

This is an implementation of the pgsql PHP extension for HHVM.

Prerequisites

This extension only requires the HipHop VM itself and the libpq library distributed with Postgres.

Pre-built versions

Pre-build versions of this extension are available in the releases branch.

Building & Installation

Installation requires a copy of HHVM to be built from source on the local machine, instructions on how to do this are available on the HHVM Wiki. Once done, the following commands will build the extension, assuming you've also installed HHVM.

$ cd /path/to/extension
$ hphpize
$ cmake .
$ make

This will produce a pgsql.so file, the dynamically-loadable extension.

To enable the extension, you need to have the following section in your hhvm config file

DynamicExtensionPath = /path/to/hhvm/extensions
DynamicExtensions {
	* = pgsql.so
}

Where /path/to/hhvm/extensions is a folder containing all HipHop extensions, and pgsql.so is in it. This will cause the extension to be loaded when the virtual machine starts up.

Hack Friendly Mode

If you are using Hack, then you can use the provided pgsql.hhi file to type the functions. There is also a compile-time option that can be passed to cmake that makes some minor adjustments to the API to make the Hack type checker more useful with them. This mostly consists of altering functions that would normally return FALSE on error and making them return null instead. This takes advantage of the nullable types in Hack.

To enable Hack-friendly mode use this command instead of the cmake one above:

$ cmake -DHACK_FRIENDLY=ON .

Differences from Zend

There are a few differences from the standard Zend implementation.

The connection resource is not optional.
The following functions are not implemented for various reasons:
- pg_convert
- pg_copy_from
- pg_copy_to
- pg_insert
- pg_lo_close
- pg_lo_create
- pg_lo_export
- pg_lo_import
- pg_lo_open
- pg_lo_read_all
- pg_lo_read
- pg_lo_seek
- pg_lo_tell
- pg_lo_unlink
- pg_lo_write
- pg_meta_data
- pg_put_line
- pg_select
- pg_set_client_encoding
- pg_set_error_verbosity
- pg_trace
- pg_tty
- pg_untrace
- pg_update

There is a connection pool, you can use the pg_pconnect function. The $connection_type parameter is ignored for both pg_connect and pg_pconnect. There are a few new function:

pg_connection_pool_stat: It gives some information, eg. count of connections, free connections, etc.
pg_connection_pool_sweep_free: Closing all unused connection in all pool.

The pg_pconnect create a different connection pool for each connection string.

Otherwise, all functionality is (or should be) the same as the Zend implementation.