PHPackages t1nkl/postgres-pgbouncer-extension - PHPackages - PHPackages [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register) 1. [Directory](/) 2. / 3. [Database & ORM](/categories/database) 4. / 5. t1nkl/postgres-pgbouncer-extension ActiveLibrary[Database & ORM](/categories/database) t1nkl/postgres-pgbouncer-extension ================================== Laravel PostgreSQL pgbouncer extension fix for PDO::ATTR\_EMULATE\_PREPARES option 1.1.1(2mo ago)8115.4k↑31.8%3[1 issues](https://github.com/t1nkl/postgres-pgbouncer-extension/issues)MITPHPPHP ^8.0 Since Jun 14Pushed 2mo ago1 watchersCompare [ Source](https://github.com/t1nkl/postgres-pgbouncer-extension)[ Packagist](https://packagist.org/packages/t1nkl/postgres-pgbouncer-extension)[ RSS](/packages/t1nkl-postgres-pgbouncer-extension/feed)WikiDiscussions master Synced 4d ago READMEChangelog (7)Dependencies (6)Versions (8)Used By (0) Laravel PostgreSQL + PgBouncer extension (fix for PDO::ATTR\_EMULATE\_PREPARES) =============================================================================== [](#laravel-postgresql--pgbouncer-extension-fix-for-pdoattr_emulate_prepares) A tiny Laravel package that makes working with PostgreSQL through PgBouncer safe and predictable when `PDO::ATTR_EMULATE_PREPARES` is enabled. Why you might need it: - PgBouncer in transaction/session pooling mode does not support server‑side prepared statements. - The common workaround is to enable PDO emulated prepares (`PDO::ATTR_EMULATE_PREPARES => true`). - With emulation enabled, default binding behavior in Laravel/PDO can cause booleans and some types to be sent in ways PgBouncer/PostgreSQL may not expect. This package provides a custom `PostgresConnection` that: - Formats `DateTimeInterface` values using your connection grammar date format. - Converts PHP booleans to the PostgreSQL-native textual values `'true'` and `'false'` during binding. - Binds values using explicit PDO parameter types: integers as `PDO::PARAM_INT`, resources as `PDO::PARAM_LOB`, and everything else as `PDO::PARAM_STR` for consistency with emulated prepares. The package is automatically discovered by Laravel and is only activated for the `pgsql` connection when `PDO::ATTR_EMULATE_PREPARES` is present and enabled in your connection `options`. --- Requirements ------------ [](#requirements) - PHP: ^8.0 - Laravel Framework: ^10.0 | ^11.0 | ^12.0 | ^13.0 - PostgreSQL + PgBouncer (transaction or session pooling scenarios) Installation ------------ [](#installation) ``` composer require t1nkl/postgres-pgbouncer-extension ``` Laravel package auto-discovery will register the service provider; no manual configuration is needed beyond the database option below. Configuration ------------- [](#configuration) Enable emulated prepares on your PostgreSQL connection. You can declare it either as an associative map or as a numeric flag — this package supports both styles. `config/database.php` ``` 'connections' => [ 'pgsql' => [ 'driver' => 'pgsql', 'host' => env('DB_HOST', '127.0.0.1'), 'port' => env('DB_PORT', '5432'), 'database' => env('DB_DATABASE', 'forge'), 'username' => env('DB_USERNAME', 'forge'), 'password' => env('DB_PASSWORD', ''), 'charset' => 'utf8', 'prefix' => '', 'search_path' => 'public', 'sslmode' => 'prefer', // EITHER associative option style (recommended): 'options' => [ PDO::ATTR_EMULATE_PREPARES => true, ], // OR numeric option style (also supported): // 'options' => [ // PDO::ATTR_EMULATE_PREPARES, // ], ], ], ``` Make sure your default connection is `pgsql` or that you add the `options` to the specific PostgreSQL connection you actually use. If you modify configuration, remember to clear caches: ``` php artisan config:clear php artisan cache:clear ``` How it works ------------ [](#how-it-works) - The service provider hooks into Laravel’s connection resolver for `pgsql` only when `PDO::ATTR_EMULATE_PREPARES` is detected in the connection `options`. - It swaps the default `Illuminate\Database\PostgresConnection` with `PostgresPgbouncerExtension\Database\PostgresConnection`. - The custom connection overrides: - `prepareBindings`: converts `DateTimeInterface` to the grammar date format and casts booleans to `'true'`/`'false'` strings. - `bindValues`: binds integers as `PDO::PARAM_INT`, resources as `PDO::PARAM_LOB`, and all other values as `PDO::PARAM_STR` to keep behavior stable with emulated prepares. Usage ----- [](#usage) There is nothing special to do. Once installed and the option is enabled, all queries through the `pgsql` connection will use the safer binding strategy. Example: boolean filters are sent as `'true'`/`'false'` which PostgreSQL parses natively. ``` User::where('is_active', true)->get(); ``` Troubleshooting --------------- [](#troubleshooting) - The behavior does not change: - Ensure `PDO::ATTR_EMULATE_PREPARES` is present in your `options` and set to `true` (or listed numerically). - Confirm your app uses the `pgsql` connection you configured (`config('database.default')`). - Clear config/cache (`php artisan config:clear && php artisan cache:clear`). - Make sure the package is installed and not excluded from auto-discovery. - Still seeing unexpected parameter types? - Double-check any custom connection/resolver code that might override this package. - Try a minimal repro calling the query builder and logging SQL + bindings. Testing locally --------------- [](#testing-locally) This repository includes a test suite. To run it: ``` composer install composer test ``` Related work ------------ [](#related-work) Original gist/package inspiration: License ------- [](#license) MIT License. See `LICENSE` for details. ### Health Score 52 — FairBetter than 96% of packages Maintenance82 Actively maintained with recent releases Popularity41 Moderate usage in the ecosystem Community9 Small or concentrated contributor base Maturity58 Maturing project, gaining track record Bus Factor1 Top contributor holds 100% of commits — single point of failure How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window. **Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores. **Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement. **Maturity (30%)** — Project age, version count, PHP version support, and release stability. ### Release Activity Cadence Every ~233 days Recently: every ~281 days Total 7 Last Release 81d ago PHP version history (2 changes)1.0.0PHP ^7.4|^8.0|^8.1 1.1.0PHP ^8.0 ### Community Maintainers ![](https://avatars.githubusercontent.com/u/10539665?v=4)[Kyryll Kovalenko](/maintainers/t1nkl)[@t1nkl](https://github.com/t1nkl) --- Top Contributors [![t1nkl](https://avatars.githubusercontent.com/u/10539665?v=4)](https://github.com/t1nkl "t1nkl (10 commits)") --- Tags laravellaravel-packagepdopdo-pgsqlpgbouncerpostgrespostgresqllaraveldatabasepostgresqlpostgrespgbouncerATTR\_EMULATE\_PREPARES ### Code Quality TestsPHPUnit Code StylePHP CS Fixer ### Embed Badge ![Health badge](/badges/t1nkl-postgres-pgbouncer-extension/health.svg) ``` [![Health](https://phpackages.com/badges/t1nkl-postgres-pgbouncer-extension/health.svg)](https://phpackages.com/packages/t1nkl-postgres-pgbouncer-extension) ``` ### Alternatives [tpetry/laravel-postgresql-enhanced Support for many missing PostgreSQL specific features 1.0k2.4M29](/packages/tpetry-laravel-postgresql-enhanced)[anourvalar/eloquent-serialize Laravel Query Builder (Eloquent) serialization 11223.5M33](/packages/anourvalar-eloquent-serialize)[umbrellio/laravel-pg-extensions Extensions for Postgres Laravel 103451.2k1](/packages/umbrellio-laravel-pg-extensions)[statamic-rad-pack/runway Eloquently manage your database models in Statamic. 135224.7k7](/packages/statamic-rad-pack-runway)[umbrellio/laravel-ltree Extension LTree (Postgres) for Laravel 34120.1k](/packages/umbrellio-laravel-ltree)[waad/laravel-model-metadata A robust Laravel package for handling metadata with JSON casting, custom relation names, and advanced querying capabilities. 854.6k](/packages/waad-laravel-model-metadata) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)