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.
?
for variable is automatically replaced with $1
, $2
and so...
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/phpgsql
PhPgSql 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-phpstan
And 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.