forrest79/phpgsql

PostgreSQL library for PHP with fluent interface for SQL query writing.

v1.5.5 2024-04-18 21:51 UTC

Requires

• php: ^8.1
• ext-pgsql: ^8.1

Requires (Dev)

• forrest79/phpcs: ^1.6
• forrest79/phpcs-ignores: ^0.5
• forrest79/phpgsql-phpstan: ^1.7
• nette/tester: ^2.5
• phpstan/phpstan: ^1.10
• phpstan/phpstan-strict-rules: ^1.5

Suggests

• ext-json: Needed to support parse JSON types from PostgreSQL

BSD-3-Clause

• Jakub Trmota

• database
• php
• fluent
• postgresql

README

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, $2 and 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.

Installation

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.

Documentation

Complete documentation is in the docs directory.

All examples are self-tested - you can be sure, it's working.