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 2mo ago

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 27% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity14

Limited adoption so far

Community7

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

---

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

[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)