johnwilson / jsondb
JSON document db abstraction layer over MySQL
dev-master
2017-01-15 00:20 UTC
Requires
- php: >=5.4
- illuminate/database: 5.2
This package is not auto-updated.
Last update: 2024-04-13 17:08:23 UTC
README
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
// 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
- View documentation for additional information and tips.