PHPackages                             pullay/database - 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. pullay/database

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

pullay/database
===============

Lite Query Builder for PHP

041PHP

Since Nov 16Pushed 2y ago1 watchersCompare

[ Source](https://github.com/Pullay/database)[ Packagist](https://packagist.org/packages/pullay/database)[ RSS](/packages/pullay-database/feed)WikiDiscussions master Synced today

READMEChangelogDependenciesVersions (1)Used By (0)

Pullay Database
===============

[](#pullay-database)

Lite Query Builder for PHP

[![Software License](https://camo.githubusercontent.com/074b89bca64d3edc93a1db6c7e3b1636b874540ba91d66367c0e5e354c56d0ea/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f6c6963656e73652d4d49542d627269676874677265656e2e737667)](LICENSE)[![Packagist](https://camo.githubusercontent.com/1c12bb5021eb19283f77ac91cd972c74c717c6e3bb3af1adca1ad4039cb04b6e/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f64742f70756c6c61792f6461746162617365)](https://packagist.org/packages/pullay/database)

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

[](#installation)

```
composer require pullay/database dev-master

```

Get starting
------------

[](#get-starting)

```
use Pullay\Database\Driver\Mysql;
use Pullay\Database\Connection;

$driver = Mysql::connect('localhost', 'test', 'user', 'password');
$connection = new Connection($driver);
$query = $connection->getQueryBuilder()
    ->select('user')
    ->where(['id' => 1])
    ->limit(1);

$row = $query->fethOne();

```

CRUD Query
----------

[](#crud-query)

Insert
------

[](#insert)

```
$values = ['username' => 'alex', 'password' => 'qwerty'];
$query = $connection->getQueryBuilder()
    ->into('user')
    ->values($values);
$lastInsertId = $query->execute();

```

Select
------

[](#select)

```
$query = $connection->getQueryBuilder()
    ->select('user')
    ->where(['id' => 1])
    ->limit(1);

// fetch
$row = $query->fetch();

// fetch all
$rows = $query->fetchAll();

// or
foreach ($query as $row) {
    echo $row['username'];
}

// count
$count = $query->count();

```

Where conditions
----------------

[](#where-conditions)

Join table
----------

[](#join-table)

Update
------

[](#update)

```
$query = $connection->getQueryBuilder()
    ->update('user')
    ->set('username', 'bob')
    ->where(['id' => 1]);
$rowCount = $query->execute();

```

Delete
------

[](#delete)

```
$query = $connection->getQueryBuilder()
    ->delete('user')
    ->where(['id' => 1]);
$rowCount = $query->execute();

```

###  Health Score

15

—

LowBetter than 3% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity8

Limited adoption so far

Community7

Small or concentrated contributor base

Maturity21

Early-stage or recently created project

 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.

### Community

Maintainers

![](https://www.gravatar.com/avatar/14a0cf210bab5f1e1a31f496d1735650a4034ef2a673d943aa87f51be9d60350?d=identicon)[Nexs](/maintainers/Nexs)

---

Top Contributors

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

---

Tags

databasephpquery-builder

### Embed Badge

![Health badge](/badges/pullay-database/health.svg)

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

###  Alternatives

[jdorn/sql-formatter

a PHP SQL highlighting library

3.9k117.2M118](/packages/jdorn-sql-formatter)[propel/propel1

Propel is an open-source Object-Relational Mapping (ORM) for PHP5.

8351.6M87](/packages/propel-propel1)[jfelder/oracledb

Oracle DB driver for Laravel

11518.4k](/packages/jfelder-oracledb)

PHPackages © 2026

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