PHPackages                             rtshome/pgbabylon - 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. rtshome/pgbabylon

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

rtshome/pgbabylon
=================

PDO class extension with helpers for special PostgreSQL types

0.6(10y ago)72.5kBSDPHPPHP >=5.5.0

Since Oct 4Pushed 10y ago2 watchersCompare

[ Source](https://github.com/rtshome/pgbabylon)[ Packagist](https://packagist.org/packages/rtshome/pgbabylon)[ RSS](/packages/rtshome-pgbabylon/feed)WikiDiscussions master Synced 1mo ago

READMEChangelog (2)Dependencies (1)Versions (3)Used By (0)

Description
===========

[](#description)

PgBabylon is a user-land extension to PHP PDO and PDOStatement native classes that helps to deal with PostgreSQL types like JSON, Arrays, etc.

It provides conversion between PHP types and PostgreSQL types and simplifies usage of SQL clauses like IN.

```
// Example: insert a PHP array in a PostgreSQL JSON field

$arr = [
    "name" => "Mark",
    "age" => 39,
    "address" => "White street, 23",
    "town" => "London"
];

$s = $pdo->prepare("INSERT INTO my_table(json) VALUES (:json)");
$s->execute([
    ":json" => \PgBabylon\DataTypes\JSON($arr)
]);
```

Getting Started
===============

[](#getting-started)

PgBabylon can be installed using composer:

```
composer require rtshome/pgbabylon

```

PgBabylon currently supports the following PostgreSQL datatypes:

- Date (PHP DateTime)
- Timestamp (PHP DateTime)
- JSON (PHP Array)
- text, int and float single dimension arrays (PHP Array)

These types can also be used with the IN operator (see example below).

```
-- Sample table
CREATE TABLE person(
    id SERIAL NOT NULL PRIMARY KEY,
    data JSON NOT NULL,
    insertion_date DATE NOT NULL
);
```

```

```

```

```

###  Health Score

27

—

LowBetter than 49% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity21

Limited adoption so far

Community8

Small or concentrated contributor base

Maturity49

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

Total

2

Last Release

3860d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/ae6ce31ea6932cfb7eddc0b4bf1b353f956381f44c079ecc3815669352f57a83?d=identicon)[rtshome](/maintainers/rtshome)

---

Top Contributors

[![rtshome](https://avatars.githubusercontent.com/u/3947937?v=4)](https://github.com/rtshome "rtshome (9 commits)")

---

Tags

jsondatabasepostgresqlpostgrespdopgsqlcopyhstore

###  Code Quality

TestsPHPUnit

### Embed Badge

![Health badge](/badges/rtshome-pgbabylon/health.svg)

```
[![Health](https://phpackages.com/badges/rtshome-pgbabylon/health.svg)](https://phpackages.com/packages/rtshome-pgbabylon)
```

###  Alternatives

[doctrine/dbal

Powerful PHP database abstraction layer (DBAL) with many features for database schema introspection and management.

9.7k578.4M5.6k](/packages/doctrine-dbal)[aura/sqlquery

Object-oriented query builders for MySQL, Postgres, SQLite, and SQLServer; can be used with any database connection library.

4572.9M34](/packages/aura-sqlquery)[scienta/doctrine-json-functions

A set of extensions to Doctrine that add support for json query functions.

58523.9M36](/packages/scienta-doctrine-json-functions)[martin-georgiev/postgresql-for-doctrine

Extends Doctrine with native PostgreSQL support for arrays, JSONB, ranges, PostGIS geometries, text search, ltree, uuid, and 100+ PostgreSQL-specific functions.

4485.3M4](/packages/martin-georgiev-postgresql-for-doctrine)[aura/sql

A PDO extension that provides lazy connections, array quoting, query profiling, value binding, and convenience methods for common fetch styles. Because it extends PDO, existing code that uses PDO can use this without any changes to the existing code.

5632.5M43](/packages/aura-sql)[atlas/query

Object-oriented query builders and performers for MySQL, Postgres, SQLite, and SQLServer.

41249.0k7](/packages/atlas-query)

PHPackages © 2026

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