Anydataset Database Relational abstraction. Anydataset is an agnostic data source abstraction layer in PHP.

See more about Anydataset here.

• Connection based on URI
• Support and fix code tricks with several databases (MySQL, PostgresSql, MS SQL Server, etc)
• Natively supports Query Cache by implementing a PSR-6 interface
• Supports Connection Routes based on regular expression against the queries, that's mean a select in a table should be executed in a database and in another table should be executed in another (even if in different DB)

The connection string for databases is based on URL.

See below the current implemented drivers:

<?php
$conn = \ByJG\AnyDataset\Db\Factory::getDbRelationalInstance("mysql://root:[email protected]/myschema");

• Basic Query and Update
• Cache results
• Database Transaction
• Load Balance and Connection Pooling
• Database Helper

• Passing Parameters to PDODriver
• MySQL SSL Connection
• FreeTDS/Dblib Date Issue
• Generic PDO Driver
• Running Tests

Just type:

composer require "byjg/anydataset"

flowchart TD
    byjg/anydataset-db --> byjg/anydataset-array
    byjg/anydataset-db --> ext-pdo
    byjg/anydataset-db --> byjg/uri
    byjg/anydataset-db --> psr/cache
    byjg/anydataset-db --> psr/log

Open source ByJG