phpolar/mysql-storage

Adds support for MySQL storage in your application.

0.1.2 2025-12-05 00:26 UTC

Requires

• php: >=8.4
• ext-pdo_mysql: *
• phpolar/storage: ^7.0

Requires (Dev)

• ext-ast: *
• ext-openssl: *
• phan/phan: ^5.4
• php-coveralls/php-coveralls: ^2.5
• phpmd/phpmd: ^2.13
• phpstan/phpstan: ^2.0.3
• phpunit/phpunit: ^12
• squizlabs/php_codesniffer: ^4

MIT

README

Adds support for MySQL storage in your application.

Website

Quick start

composer require phpolar/mysql-storage

Objectives

1. Keep project small. See thresholds
2. Automatically load and persist data

Note For more details see the acceptance tests results

Example 1

$mysqlStorage = new MySqlStorage(
    connection: $connection,
    tableName: "table_name",
    typeClassName: Person::class,
);

$mysqlStorage->save($item1->id, $item);
$mysqlStorage->replace($updatedItem->id, $updatedItem);
$mysqlStorage->remove($item2->id);

$item3 = $mysqlStorage->find("id3")
    ->orElse(static fn() => new NotFound())
    ->tryUnwrap();

$allItems = $mysqlStorage->findAll();

Example Class for Items in Storage

use Phpolar\Phpolar\AbstractModel;

class Person extends AbstractModel
{
    #[PrimaryKey]
    #[Hidden]
    public string $id;

    public string $firstName;

    public string $lastName;

    public string $address1;

    public string $address2;

    public function getPrimaryKey(): string
    {
        return $id;
    }
}

Thresholds

Module	Source Code Size *	Memory Usage	Required
phpolar/mysql-storage	900 B	110 kB	x

• Note: Does not include comments.