PHPackages                             johnwilson/jsondb - 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. johnwilson/jsondb

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

johnwilson/jsondb
=================

JSON document db abstraction layer over MySQL

1953PHP

Since Jan 15Pushed 9y ago1 watchersCompare

[ Source](https://github.com/johnwilson/jsondb)[ Packagist](https://packagist.org/packages/johnwilson/jsondb)[ RSS](/packages/johnwilson-jsondb/feed)WikiDiscussions master Synced yesterday

READMEChangelogDependenciesVersions (1)Used By (0)

JsonDB Library
==============

[](#jsondb-library)

[![JsonDB](https://github.com/johnwilson/jsondb/raw/master/jsondb.png)](#JsonDB)

About
-----

[](#about)

JSONDb is a PHP database abstraction library for MySQL which allows you to easily store and query JSON data. Because it doesn't require the Json Data type available in Mysql version 5.7, this means JSONDb can be used in hosted environments that offer older versions of Mysql for example.

**JSONDb is primarily designed to be used for rapid application prototyping and is not advisable for use in production.**

Quick Start
-----------

[](#quick-start)

```
// Autoload
require_once __DIR__ . '/vendor/autoload.php';

// import namespace
use IBT\JsonDB\Client;
use IBT\JsonDB\Collection;

// create client and initialize database
$c = new Client([
    'database' => 'database',
    'username' => 'username',
    'password' => 'password'
]);
$c->setup();

// create collection
$col = $c->newCollection("users");

// insert json
$col->insert('{"name":"jason bourne", "category":"agent"}');
$col->insert('{"name":"james bond", "category":"agent"}');
$col->insert('{"name":"mathew murdock", "category":"superhero"}');

// search data
$f = $col->newFilter();
$r = $f->whereIn('category', ['agent'])->run();
var_dump($r)
```

Learn More
----------

[](#learn-more)

- View [documentation](https://github.com/johnwilson/jsondb/blob/master/docs/index.md) for additional information and tips.

###  Health Score

23

—

LowBetter than 26% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity14

Limited adoption so far

Community9

Small or concentrated contributor base

Maturity41

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.

### Community

Maintainers

![](https://avatars.githubusercontent.com/u/1472296?v=4)[John Wilson](/maintainers/johnwilson)[@johnwilson](https://github.com/johnwilson)

---

Top Contributors

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

### Embed Badge

![Health badge](/badges/johnwilson-jsondb/health.svg)

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

###  Alternatives

[jdorn/sql-formatter

a PHP SQL highlighting library

3.9k116.5M113](/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)