README

👁 Latest Stable Version
👁 Downloads
👁 Integrate
👁 Code Coverage

PHP light version of psql that comes with PostgreSQL.

Why

1. You are inside a PHP only environment, like a PHP Docker image
2. You need to import a large pg_dump --inserts dump
3. You don't have access to the native psql client

Performance

Speed is exactly the same of the original psql binary thanks to streams usage.

Supported formats

When using pg_dump --inserts it is highly recommended to also set --rows-per-insert=1000 to speed performances up.

Usage

The library provides two usages, the binary and the \SlamPsql\Psql class.

From CLI

$ ./psql -h
Usage: psql [OPTIONS]
 -h, --host Connect to host
 -p, --port Port number
 -U, --username User for login
 -d, --dbname Database to use
	 --connect_timeout Connect timeout to use, in seconds

 Use `PGPASSWORD` env variable to set the connection password.

$ printf "CREATE DATABASE foobar;\nSELECT datname FROM pg_database;" | ./psql
foobar

$ ./psql --database foobar < foobar_huge_dump.sql

From PHP

$psql = new \SlamPsql\Psql('localhost', 5432, 'my_username', 'my_password', 'my_database');
$return = $psql->run(\STDIN, \STDOUT, \STDERR);
exit((int) (true !== $return));

// With the connect_timeout argument
$psql = new \SlamPsql\Psql('localhost', 5432, 'my_username', 'my_password', 'my_database', 5);
$return = $psql->run(\STDIN, \STDOUT, \STDERR);
exit((int) (true !== $return));

\SlamPsql\Psql::run accepts any type of resource consumable by fgets/fwrite functions.