Simple and fast PHP database library for PostgreSQL with auto converting DB types to PHP and a powerful fluent interface that can be used to simply create the most of SQL queries.
- lightweight
- no magic
- no database structure reading
- automatically convert PG data types to PHP data types
- support async connect to DB and async query
- simple creating queries with parameters - char
?for variable is automatically replaced with$1,$2and so...- as a variable you can pass scalar, bool, array, literal or other query
DB and fluent part can be used separately.
Examples of how to use this library in application, how to extend it with some useful methods and a simple repository system can be found here https://github.com/forrest79/phpgsql-extension-repository-example.
The recommended way to install PhPgSql is through Composer:
composer require forrest79/phpgsqlPhPgSql requires PHP 8.1.0 and pgsql binary extension. It doesn't work with the PDO!
If you're using PHPStan you can install settings for this great tool.
composer require --dev forrest79/phpgsql-phpstanAnd if you're using Nette framework, there is existing integration with the Tracy panel.
Complete documentation is in the docs directory.
All examples are self-tested - you can be sure, it's working.