PHPackages                             xeoncross/dbyte - 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. xeoncross/dbyte

ActiveLibrary

xeoncross/dbyte
===============

A 1kb, MySQL/SQLite/PostgreSQL database library

12020914[1 issues](https://github.com/Xeoncross/DByte/issues)PHP

Since Sep 3Pushed 11y ago9 watchersCompare

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

READMEChangelogDependenciesVersions (1)Used By (0)

DByte
=====

[](#dbyte)

### A 1kB PHP database layer for SQLite, PostgreSQL, and MySQL

[](#a-1kb-php-database-layer-for-sqlite-postgresql-and-mysql)

> DByte is built ontop of PDO to provide a level of query abstraction missing from the default PDO object. DByte uses 100% prepared statements.

Many database layers seem to exclude some of the most basic retrieval methods. Often databases just default to using `fetchAll` for everything and then extract the single row, column, array, or object they need.

However, when you query a database you generally want a certain type of result back.

### I want a single column

[](#i-want-a-single-column)

```
$count = DB::column('SELECT COUNT(*) FROM `user`);

```

### I want an array(key => value) results (i.e. for making a selectbox)

[](#i-want-an-arraykey--value-results-ie-for-making-a-selectbox)

```
$pairs = DB::pairs('SELECT `id`, `username` FROM `user`);

```

### I want a single row result

[](#i-want-a-single-row-result)

```
$user = DB::row('SELECT * FROM `user` WHERE `id` = ?', array($user_id));

```

### I want an array of results (even an empty array!)

[](#i-want-an-array-of-results-even-an-empty-array)

```
$banned_users = DB::fetch('SELECT * FROM `user` WHERE `banned` = ?, array(TRUE));

```

### I want to insert a new record

[](#i-want-to-insert-a-new-record)

```
DB::insert('user', $array);

```

### I want to update a record

[](#i-want-to-update-a-record)

```
DB::update('user', $array, $user_id);

```

### I want to delete a record

[](#i-want-to-delete-a-record)

```
DB::query('DELETE FROM `user` WHERE `id` = ?', array($user_id));

```

Notes / Advanced Usage
======================

[](#notes--advanced-usage)

In order to work across all databases it's recommended that you use the tilde (`) character in all your queries to quote column/table names. This character will be replaced in your query with the correct quoted identifier at run time.

> DO NOT USE THE `DB.min.php` FILE! It is only included to show that the file actually is 1024 characters. Unlike Javascript, you gain no performance by using it!

Composer Install
----------------

[](#composer-install)

The easiest way to install DByte is [to use composer](https://getcomposer.org/).

```
curl -s http://getcomposer.org/installer | php

```

Then create a `composer.json` file in your root directory and include this inside it.

```
{
	"require": {
		"xeoncross/dbyte" : "dev-master"
	}
}

```

With composer installed (and your `composer.json` file created) you can then run composer to install DByte into a "vendors" folder..

```
php composer.phar install

```

which you can include in your PHP scripts...

```
require 'vendor/autoload.php';

```

### Simple Install

[](#simple-install)

Or you can just [download the file](https://github.com/Xeoncross/DByte/archive/master.zip)and then include it in your scripts.

```
require('DByte\DB.php');

```

Setup
-----

[](#setup)

To begin using the DB object you need to assign a PDO connection object.

```
// Create a new PDO connection to MySQL
$pdo = new PDO(
	'mysql:dbname=yourdatabase;host=localhost',
	'root',
	'',
	array(
		PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8",
		PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_OBJ,
		PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION
	)
);

use \DByte\DB; // or class_alias('\DByte\DB', 'DB');
DB::$c = $pdo;

```

If you are using *SQLite* or *PostgreSQL* instead of MySQL you will need to change the quoted identifier to the correct character (instead of the MySQL tilde `).

```
DB::$i = '"';

```

If you are using *PostgreSQL* you will also need to set the *PostgreSQL* marker.

```
DB::$p = TRUE;

```

Multiple Database Connections
-----------------------------

[](#multiple-database-connections)

Using late-static-binding (PHP 5.3+) it's easy - just extend the DB class!

```
Class DB2 extends \DByte\DB {}

DB::$c = new PDO(...);
DB2::$c = new PDO(...);

$db_one_user_count = DB::column('SELECT COUNT(*) FROM `user`);
$db_two_user_count = DB2::column('SELECT COUNT(*) FROM `user`);

```

How can I see what queries have run?
------------------------------------

[](#how-can-i-see-what-queries-have-run)

```
print_r(DB::$q);

```

###  Health Score

28

—

LowBetter than 54% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity27

Limited adoption so far

Community16

Small or concentrated contributor base

Maturity41

Maturing project, gaining track record

 Bus Factor1

Top contributor holds 91.7% 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/2f150d1afc3c8de23a49d2b117837884cb8c1d88bc98c9ea347dc32fea375aa7?d=identicon)[Xeoncross](/maintainers/Xeoncross)

---

Top Contributors

[![xeoncross](https://avatars.githubusercontent.com/u/56460?v=4)](https://github.com/xeoncross "xeoncross (11 commits)")[![patrick-a-cavanaugh](https://avatars.githubusercontent.com/u/920281?v=4)](https://github.com/patrick-a-cavanaugh "patrick-a-cavanaugh (1 commits)")

### Embed Badge

![Health badge](/badges/xeoncross-dbyte/health.svg)

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

PHPackages © 2026

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