justim/access

A simple MySQL wrapper optimized for bigger data sets

v1.21.0 2023-12-13 14:55 UTC

Requires

• php: ^8.1
• ext-pdo: *
• psr/clock: ^1.0

Requires (Dev)

• php-coveralls/php-coveralls: ^2.5.2
• phpbench/phpbench: ^1.2.3
• phpstan/phpstan: ^1.2.0
• phpstan/phpstan-phpunit: ^1.0.0
• phpunit/phpunit: ^9.5.11
• psalm/plugin-phpunit: ^0.18.4
• squizlabs/php_codesniffer: ^3.6.2
• symfony/var-dumper: ^6.0.1
• vimeo/psalm: ^5.17

MIT

README

A simple MySQL wrapper optimized for bigger data sets

Quick usage

class User extends Entity {
    // ..
}

$db = Database::create('some PDO connection string');
$user = $db->findOne(User::class, 1);

$user->setName('Dave');
$db->update($user);

$users = $db->findBy(User::class, ['name' => 'Dave']);

// uses a generator
foreach ($users as $user) {
    // $user is an instance of User
}

Features

• Uses a PDO prepared statement pool for faster queries
• Optimized for bulk queries (ie. easy to fetch collections of collections)
• Easily present your entities as JSON without worrying about n+1 queries

Requirements

• PHP 8.1, or higher
• PDO extension

Installation

• Available at Packagist
• composer require justim/access=dev-master

Docs

For now, see the tests for usage.

Nice to have

• For now only MySQL and SQLite is supported, it would be nice to have support for more RDMSs, like Postgres
• Tests are currently run with an in-memory SQLite database, a MySQL database would be better

Final notes

Currently used in a single production product, features are tied to this product.