byjg/anydataset-db

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

4.9.1 2024-01-04 21:05 UTC

Requires

• php: >=7.4
• ext-json: *
• ext-pdo: *
• byjg/anydataset-array: 4.9.*
• byjg/uri: 4.9.*
• psr/cache: ^1.0
• psr/log: ^1.0

Requires (Dev)

• byjg/cache-engine: 4.9.*
• phpunit/phpunit: 5.7.*|7.4.*|^9.5

Suggests

• ext-curl: *
• ext-oci8: *
• ext-pdo_mysql: *
• ext-pdo_pgsql: *
• byjg/cache-engine: 4.9.*

MIT

README

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

See more about Anydataset here.

Features

• 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)

Connection Based on URI

The connection string for databases is based on URL.

See below the current implemented drivers:

Database	Connection String	Factory
Sqlite	sqlite:///path/to/file	getDbRelationalInstance()
MySql/MariaDb	mysql://username:password@hostname:port/database	getDbRelationalInstance()
Postgres	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 (OCI)	oci://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()

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

Examples

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

Advanced Topics

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

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

Open source ByJG