byjg/anydataset-db

AnyDataset-DB provides a relational database abstraction layer. It is part of the Anydataset project, an agnostic data source abstraction layer for PHP.

6.0.0 2025-11-25 14:52 UTC

Requires

• php: >=8.3 <8.6
• ext-json: *
• ext-pdo: *
• byjg/anydataset: ^6.0
• byjg/uri: ^6.0
• psr/cache: ^1.0|^2.0|^3.0
• psr/log: ^1.1|^2.0|^3.0

Requires (Dev)

• byjg/cache-engine: ^6.0
• phpunit/phpunit: ^10.5|^11.5|^12.3
• vimeo/psalm: ^5.9|^6.13

Suggests

• ext-curl: *
• ext-oci8: *
• ext-pdo_mysql: *
• ext-pdo_pgsql: *
• byjg/cache-engine: ^6.0

Provides

• byjg/anydataset-implementation: 1.0

MIT

README

sidebar_key	tags
anydataset-db	php anydataset databases

Database Abstraction Layer

AnyDataset-DB provides a relational database abstraction layer. It is part of the Anydataset project, an agnostic data source abstraction layer for PHP.

Learn more about Anydataset here.

Features

• Connection based on URI
• Handles compatibility and code optimization across multiple databases (e.g., MySQL, PostgreSQL, MS SQL Server)
• Built-in Query Cache support using a PSR-16 compliant interface
• Enables connection routing based on regular expressions for queries (e.g., directing queries to different databases for specific tables)

Connection Based on URI

Database connections are defined using URL-based connection strings.

Supported drivers are listed below:

Database	Connection String	Factory Method
SQLite	sqlite:///path/to/file	getDbInstance()
MySQL/MariaDB	mysql://username:password@hostname:port/database	getDbInstance()
PostgreSQL	psql://username:password@hostname:port/database	getDbInstance()
SQL Server (DbLib)	dblib://username:password@hostname:port/database	getDbInstance()
SQL Server (Sqlsrv)	sqlsrv://username:password@hostname:port/database	getDbInstance()
Oracle (OCI8)	oci8://username:password@hostname:port/database	getDbInstance()
Generic PDO	pdo://username:password@pdo_driver?PDO_PARAMETERS	getDbInstance()

Example usage:

<?php
$conn = \ByJG\AnyDataset\Db\Factory::getDbInstance("mysql://root:password@10.0.1.10/myschema");

Examples

• Getting Started
• Basic Query and Update
• Sql Statement Object
• Cache results
• Database Transaction
• Load Balance and Connection Pooling
• Database Helper
• Filtering the Query
• Entity Mapping

Advanced Topics

• Database Driver Interface
• DatabaseExecutor - Recommended API
• Passing Parameters to PDODriver
• Generic PDO Driver
• Running Tests
• Getting an Iterator from an existing PDO Statement
• Pre Fetch records
• Logging
• Deprecated Features

Database Specifics

• MySQL
• PostgreSQL
• Oracle
• SQLServer
• Literal PDO Connection String

Install

Just type:

composer require "byjg/anydataset-db"

Dependencies

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

Loading

Open source ByJG