byjg/anydataset-db

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

5.0.4 2025-01-07 01:34 UTC

Requires

• php: >=8.1 <8.4
• ext-json: *
• ext-pdo: *
• byjg/anydataset-array: ^5.0
• byjg/uri: ^5.0
• psr/cache: ^1.0|^2.0|^3.0
• psr/log: ^1.1|^2.0|^3.0

Requires (Dev)

• byjg/cache-engine: ^5.0
• phpunit/phpunit: ^9.6
• vimeo/psalm: ^5.9

Suggests

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

Provides

• byjg/anydataset-implementation: 1.0

MIT

README

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-6 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	getDbRelationalInstance()
MySQL/MariaDB	mysql://username:password@hostname:port/database	getDbRelationalInstance()
PostgreSQL	psql://username:password@hostname:port/database	getDbRelationalInstance()
SQL Server (DbLib)	dblib://username:password@hostname:port/database	getDbRelationalInstance()
SQL Server (Sqlsrv)	sqlsrv://username:password@hostname:port/database	getDbRelationalInstance()
Oracle (OCI8)	oci8://username:password@hostname:port/database	getDbRelationalInstance()
Generic PDO	pdo://username:password@pdo_driver?PDO_PARAMETERS	getDbRelationalInstance()

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

Advanced Topics

• Passing Parameters to PDODriver
• Generic PDO Driver
• Running Tests
• Getting an Iterator from an existing PDO Statament
• Pre Fetch records

Database Specifics

• MySQL
• Oracle
• SQLServer
• Literal PDO Connection String

Install

Just type:

composer require "byjg/anydataset"

Dependencies

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

Loading

Open source ByJG