BlueDB

A PHP MySQL ORM library with Database First model that lets you create Entities with base properties and complex relationships (One-To-Many, Many-To-One, Many-To-Many, Table Inheritance, Associative tables), supports queries with expressions, JSON encoding/decoding and is simple to use.

Check the BlueDBClient.NET for a .NET client library to use on the .NET client side.

Documentation & Tutorials

You can read the documentation and tutorials under the Wiki.

Short examples

Let's assume that we have an entity User.

Loading all entries:

$all = User::loadList();

This would load all entries with all fields.

Let's say that we want only the Username fields:

$all = User::loadList([User::UsernameField]);

How about loading only those users, whose Username starts with "Ja"?

Simple, we use the Criteria class:

$criteria = new Criteria(User::class);
$criteria->add(Expression::startsWith(User::class, User::UsernameField, "Ja"));
$results = User::loadListByCriteria($criteria);

Encoding/decoding entities to/from JSON? No problem!

$json = JSON::encode($entity);
$entity = JSON::decode($json);

Creating a new entry:

$gordon = new User();
$gordon->Username = "Gordon";
User::save($gordon);

Updating entries:

// let's change Gordons username to 'Freeman'
$gordon->Username = "Freeman";
User::update($gordon);

Deleting entries:

// let's delete Gordon
User::delete($gordon);

These short examples are just the top of the iceberg, BlueDB has many many more cool features. To find them out and for more complex examples & tutorials, please go to Wiki.

Requirements

PHP version >= 5.5

Author and License

Gregor Mohorko (www.mohorko.info)

Copyright (c) 2022 Gregor Mohorko

Apache License 2.0