Database

Raxos Database provides a fluent, attribute driven ORM together with a low level SQL query builder. Connections wrap PDO for MySQL, MariaDB and SQLite behind one interface, the query builder composes select, insert, update and delete statements piece by piece, and the ORM layer maps rows to model classes using PHP attributes for columns, primary keys, casters, embeddables and relations (has one, has many, belongs to, belongs to many, and their "through" and polymorphic variants). A query logger, a per request model identity cache and nested transactions with savepoints round out the package.

The three layers (connections, query builder and ORM) are separate but composable: you can drop down to raw SQL through a connection, build a query without ever touching a model, or work entirely through models and let the ORM assemble the queries for you.

Highlights

DbRegister connections by id and reach the current one from anywhere.ConnectionMySql, MariaDb and SQLite drivers behind one PDO backed interface.QueryCompose select, insert, update and delete statements fluently.ModelMap rows to attribute driven models with relations and casters.ExprBuild comparison, aggregate, date and string SQL expressions.ORM attributesDescribe tables, columns, keys, relations and embeddables.

Explore by category

• Connections: create and register MySql, MariaDb and SQLite connections and resolve them through the Db facade.
• Query builder: build select, insert, update and delete queries with joins, where clauses and expressions.
• Transactions, caching and logging: nested transactions with savepoints, the model identity cache and the query logger.
• Models: define models with #[Table], #[Column] and #[PrimaryKey], then read, save and delete records.
• Relations: declare relations with attributes and control eager loading.
• Casters, embeddables and polymorphic models: convert column values, embed value objects and map single table inheritance.

Quick example

<?php
declare(strict_types=1);

use Raxos\Database\Connection\MySql;
use Raxos\Database\Db;
use Raxos\Database\Orm\{Model, ModelArrayList};
use Raxos\Database\Orm\Attribute\{Column, HasMany, PrimaryKey, Table};
use function Raxos\Database\Query\literal;

#[Table('users')]
final class User extends Model
{
    #[PrimaryKey]
    #[Column]
    public string $id;

    #[Column]
    public string $name;

    #[HasMany(Post::class)]
    public ModelArrayList $posts;
}

Db::register(MySql::createFromOptions(
    host: 'localhost',
    database: 'app',
    username: 'root',
));

$user = User::singleOrFail('usr_123');
$user->name = 'Bas';
$user->save();

$recent = User::select()
    ->where('created_on', '>', literal('now() - interval 7 day'))
    ->arrayList();

This registers a MySQL connection, defines a model with a primary key, a plain column and a has many relation, then reads and writes through it.

Installation

Install the package with Composer. See installation for the required PHP version and extensions.

composer require raxos/database