PHPackages                             offsite-solutions/eisodos-db-connector-pdo-pgsql - 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. offsite-solutions/eisodos-db-connector-pdo-pgsql

ActiveLibrary[Database & ORM](/categories/database)

offsite-solutions/eisodos-db-connector-pdo-pgsql
================================================

Eisodos DB Connector - PDO PostgreSQL

1.0.9(6mo ago)097PHPPHP >=8.4.0

Since Jun 10Pushed 5mo agoCompare

[ Source](https://github.com/offsite-solutions/EisodosDBPDOPgSQL)[ Packagist](https://packagist.org/packages/offsite-solutions/eisodos-db-connector-pdo-pgsql)[ RSS](/packages/offsite-solutions-eisodos-db-connector-pdo-pgsql/feed)WikiDiscussions main Synced 1mo ago

READMEChangelog (10)Dependencies (1)Versions (11)Used By (0)

EisodosDBPDOPgSQL
=================

[](#eisodosdbpdopgsql)

Eisodos FW PDO:PostgreSQL Database Connector

Prerequisites
-------------

[](#prerequisites)

- PHP 8.4
    - Tested with PHP 8.4
- Installed ext-pdo, ext-pdo\_pgsql
- Eisodos framework
    - Minimum version 1.1.0

Installation
------------

[](#installation)

Installation via composer:

```
composer install "offsite-solutions/eisodos-db-connector-pdo-pgsql"

```

Configuration
-------------

[](#configuration)

```
[Database]
driver=pgsql
user=eisodos
password=eisodos
host=host.docker.internal
port=15432
# database name
dbname=eisodos
# named notation := | =>
namednotation=:=
# Connect timeout in seconds
connectTimeout=10
# disable, allow, prefer, require
sslmode=disable
options=--application_name=PDO_PgSQL_test
autoCommit=false
connectSQL=set client_encoding to 'UTF-8';set timezone to 'Europe/Budapest';
```

### driver

[](#driver)

Available values are **pgsql, uri:///file/to/dsn**

### DBName

[](#dbname)

Database name

### host

[](#host)

Host name or IP

### port

[](#port)

Port number (usually 5432)

### username

[](#username)

Username

### password

[](#password)

Password

### SSLMode

[](#sslmode)

Available values are **require, disable, allow, prefer, require, verify-ca, verify-full**

### SSLCert

[](#sslcert)

Client certificate filename, example: **\[path\]/client.crt**

### SSLKey

[](#sslkey)

Client private key, example: **\[path\]/client.key**

### SSLRootCert

[](#sslrootcert)

Root certificate, example: **\[path\]/ca.crt**

### connectTimeout

[](#connecttimeout)

Connection timeout in millisec, example: **20000**

### prefetchSize

[](#prefetchsize)

Prefetch size for queries, example: **20**

### persistent

[](#persistent)

Peristent connection enabled, available values are **true, false(default)**

### namedNotation

[](#namednotation)

Named notation operator used for prepared SQLs, available values are **:= , =>**

### case

[](#case)

Force case of database objects' name. Available values are **natural(default), lower, upper**

### stringifyFetches

[](#stringifyfetches)

Stringify fetches, values are **true, false(default)**

### autoCommit

[](#autocommit)

Set auto commit, values are **true, false(default)**

### Options

[](#options)

List of available options:

Example: **--application\_name=PDO\_PgSQL\_test**

### ConnectSQL

[](#connectsql)

Series of SQLs which will be executed right after successful connection.

Initialization
--------------

[](#initialization)

```
  use Eisodos\Connectors\ConnectorPDOPgSQL;
  use Eisodos\Eisodos;

  Eisodos::$dbConnectors->registerDBConnector(new ConnectorPDOPgSQL(), 0);
  Eisodos::$dbConnectors->db()->connect();

  Eisodos::$dbConnectors->db()->disconnect();
```

Methods
-------

[](#methods)

See Eisodos DBConnector Interface documentation:

Examples
--------

[](#examples)

### Get all rows of a query

[](#get-all-rows-of-a-query)

```
Eisodos::$dbConnectors->db()->query(RT_ALL_ROWS, "select * from eisodos_test1 order by id desc", $back);
print_r($back);
print("   Number of rows returned: " . Eisodos::$dbConnectors->db()->getLastQueryTotalRows() . "\n");
```

### Execute DML

[](#execute-dml)

```
Eisodos::$dbConnectors->db()->executeDML("delete from eisodos_test1 where id>=1000");
Eisodos::$dbConnectors->db()->commit();
```

### Execute prepared DML

[](#execute-prepared-dml)

```
function generateCLOB($count_): string {
  $characters = '0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ';
  $randomString = '';

  for ($i = 0; $i < $count_; $i++) {
    $index = random_int(0, strlen($characters) - 1);
    $randomString .= $characters[$index];
  }

  return $randomString;
}

$boundVariables = [];
Eisodos::$dbConnectors->db()->bind($boundVariables, 'ID', 'integer', 100);
Eisodos::$dbConnectors->db()->bind($boundVariables, 'C_INT', 'integer', 123);
Eisodos::$dbConnectors->db()->bind($boundVariables, 'C_FLOAT', 'float', 123.45);
Eisodos::$dbConnectors->db()->bind($boundVariables, 'C_DATE', 'date', date("Y-m-d"));
Eisodos::$dbConnectors->db()->bind($boundVariables, 'C_DATETIME', 'datetime', date("Y-m-d H:i:s"));
Eisodos::$dbConnectors->db()->bind($boundVariables, 'C_CLOB', 'clob', generateCLOB('80000'));
Eisodos::$dbConnectors->db()->bind($boundVariables, 'C_VARCHAR', 'string', 'test1');
Eisodos::$dbConnectors->db()->bind($boundVariables, 'C_CHAR', 'char', 'Y');
print("Executing prepared DML\n");
Eisodos::$dbConnectors->db()->executePreparedDML2("INSERT INTO EISODOS_TEST1 (ID,C_INT,C_FLOAT,C_DATE,C_DATETIME,C_VARCHAR,C_CHAR,C_CLOB) \n" .
   "VALUES (:ID,:C_INT,:C_FLOAT,:C_DATE,:C_DATETIME,:C_VARCHAR,:C_CHAR,:C_CLOB)", $boundVariables);
Eisodos::$dbConnectors->db()->commit();
```

### Execute Stored Procedure with IN, IN\_OUT, OUT parameters

[](#execute-stored-procedure-with-in-in_out-out-parameters)

```
$boundVariables = [];
Eisodos::$dbConnectors->db()->bind($boundVariables, 'P_ID', 'integer', '', 'IN_OUT');
Eisodos::$dbConnectors->db()->bind($boundVariables, 'P_C_INT', 'integer', 456);
Eisodos::$dbConnectors->db()->bind($boundVariables, 'P_C_FLOAT', 'float', 789.45);
Eisodos::$dbConnectors->db()->bind($boundVariables, 'P_C_DATE', 'date', date("Y-m-d"));
Eisodos::$dbConnectors->db()->bind($boundVariables, 'P_C_DATETIME', 'datetime', date("Y-m-d H:i:s"));
Eisodos::$dbConnectors->db()->bind($boundVariables, 'P_C_CLOB', 'clob', generateCLOB(2000));
Eisodos::$dbConnectors->db()->bind($boundVariables, 'P_C_VARCHAR', 'string', 'test1_sp');
Eisodos::$dbConnectors->db()->bind($boundVariables, 'P_C_CHAR', 'char', 'Y');
Eisodos::$dbConnectors->db()->bind($boundVariables, 'P_CALLBACK', 'string', 'callback','IN_OUT');
Eisodos::$dbConnectors->db()->bind($boundVariables, 'P_OUT_INT', 'int', '','OUT');
Eisodos::$dbConnectors->db()->bind($boundVariables, 'P_OUT_VARCHAR2', 'string', '','OUT');
Eisodos::$dbConnectors->db()->bind($boundVariables, 'P_OUT_DATE', 'date', '','OUT');
Eisodos::$dbConnectors->db()->bind($boundVariables, 'P_OUT_DATETIME', 'datetime', '','OUT');
Eisodos::$dbConnectors->db()->bind($boundVariables, 'P_OUT_CLOB', 'clob', '','OUT');
Eisodos::$dbConnectors->db()->bind($boundVariables, 'P_ERROR_MSG', 'string', '','OUT');
Eisodos::$dbConnectors->db()->bind($boundVariables, 'P_ERROR_CODE', 'integer', '','OUT');
Eisodos::$dbConnectors->db()->bind($boundVariables, 'P_LOGS', 'string', '[]','IN_OUT');
print("Executing stored procedure DML\n");
$resultArray = [];
Eisodos::$dbConnectors->db()->executeStoredProcedure('test_sp', $boundVariables, $resultArray, false);
Eisodos::$dbConnectors->db()->commit();
print("Result array\n");
print_r($resultArray);
```

#### Result (CLOB has been cut)

[](#result-clob-has-been-cut)

```
**** Binding parameters for Stored Procedure
Executing stored procedure DML
Result array
Array
(
    [P_ID] => 22
    [P_C_INT] => 456
    [P_C_FLOAT] => 789.45
    [P_C_DATE] => 2025-06-09
    [P_C_DATETIME] => 2025-06-09 10:05:12
    [P_C_CLOB] => vcQMDyBVXACttOnYKrLOeJGQ...
    [P_C_VARCHAR] => test1_sp
    [P_C_CHAR] => Y
    [P_CALLBACK] => out callback
    [P_OUT_INT] => 457
    [P_OUT_VARCHAR2] => out test1_sp
    [P_OUT_DATE] => 2025-06-10
    [P_OUT_DATETIME] => 2025-06-10 10:05:12
    [P_OUT_CLOB] => out vcQMDyBVXACttOnYKrLOeJGQ...
    [P_ERROR_MSG] =>
    [P_ERROR_CODE] => 0
    [P_LOGS] =>
)

```

#### Stored procedure for testing

[](#stored-procedure-for-testing)

```
CREATE TABLE EISODOS_TEST1 (
    ID         BIGINT NOT NULL,
    C_INT      INT4,
    C_FLOAT    FLOAT,
    C_DATE     DATE,
    C_DATETIME TIMESTAMP,
    C_CLOB     VARCHAR,
    C_VARCHAR  VARCHAR(255),
    C_CHAR     CHAR(1)
);

CREATE SEQUENCE eisodos_s;

CREATE OR REPLACE FUNCTION test_sp(
    INOUT p_id BIGINT,
    IN p_c_int INT4,
    IN p_c_float FLOAT,
    IN p_c_date DATE,
    IN p_c_datetime TIMESTAMP,
    IN p_c_clob VARCHAR,
    IN p_c_varchar VARCHAR,
    IN p_c_char CHAR,
    INOUT p_callback VARCHAR,
    OUT p_out_int INT4,
    OUT p_out_varchar2 VARCHAR,
    OUT p_out_date DATE,
    OUT p_out_datetime TIMESTAMP,
    OUT p_out_clob VARCHAR,
    OUT p_error_msg VARCHAR,
    OUT p_error_code INT4,
    INOUT p_logs JSONB DEFAULT NULL
)
    CALLED ON NULL INPUT
    VOLATILE
    LANGUAGE plpgsql
AS
$$
BEGIN

    p_error_code := 0;
    p_error_msg := NULL;
    p_logs := NULL;

    IF (p_id IS NULL)
    THEN
        SELECT NEXTVAL('eisodos_s') INTO p_id;
    END IF;

    INSERT INTO EISODOS_TEST1 (ID, C_INT, C_FLOAT, C_DATE, C_DATETIME, C_CLOB, C_VARCHAR, C_CHAR)
    VALUES (p_id,
            p_c_int,
            p_c_float,
            p_c_date,
            p_c_datetime,
            p_c_clob,
            p_c_varchar,
            p_c_char);

    p_callback := 'out '||p_callback;
    p_out_int := p_c_int+1;
    p_out_varchar2 := 'out '||p_c_varchar;
    p_out_date := p_c_date+1;
    p_out_datetime := p_c_datetime+interval '1 day';
    p_out_clob := 'out '||p_c_clob;

    IF p_error_code0
    THEN
        RAISE EXCEPTION '[%] %', p_error_code, p_error_msg;
    END IF;

END
$$;
```

###  Health Score

39

—

LowBetter than 86% of packages

Maintenance71

Regular maintenance activity

Popularity9

Limited adoption so far

Community6

Small or concentrated contributor base

Maturity60

Established project with proven stability

 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 ~17 days

Recently: every ~10 days

Total

10

Last Release

182d ago

PHP version history (2 changes)1.0.0PHP &gt;=8.3.0

1.0.1PHP &gt;=8.4.0

### Community

Maintainers

![](https://www.gravatar.com/avatar/8bc6a2c7c4c548677094667632562471dc59dcb319bdda8a05369d2561b16106?d=identicon)[LaszloB](/maintainers/LaszloB)

---

Top Contributors

[![LBanfalvi](https://avatars.githubusercontent.com/u/12492420?v=4)](https://github.com/LBanfalvi "LBanfalvi (16 commits)")

### Embed Badge

![Health badge](/badges/offsite-solutions-eisodos-db-connector-pdo-pgsql/health.svg)

```
[![Health](https://phpackages.com/badges/offsite-solutions-eisodos-db-connector-pdo-pgsql/health.svg)](https://phpackages.com/packages/offsite-solutions-eisodos-db-connector-pdo-pgsql)
```

###  Alternatives

[doctrine/orm

Object-Relational-Mapper for PHP

10.2k285.3M6.2k](/packages/doctrine-orm)[jdorn/sql-formatter

a PHP SQL highlighting library

3.9k115.1M102](/packages/jdorn-sql-formatter)[illuminate/database

The Illuminate Database package.

2.8k52.4M9.4k](/packages/illuminate-database)[mongodb/mongodb

MongoDB driver library

1.6k64.0M546](/packages/mongodb-mongodb)[ramsey/uuid-doctrine

Use ramsey/uuid as a Doctrine field type.

90340.3M211](/packages/ramsey-uuid-doctrine)[reliese/laravel

Reliese Components for Laravel Framework code generation.

1.7k3.4M16](/packages/reliese-laravel)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)