Download the PHP package byjg/anydataset-db without Composer
On this page you can find all versions of the php package byjg/anydataset-db. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Table of contents
Download byjg/anydataset-db
More information about byjg/anydataset-db
Files in byjg/anydataset-db
Download byjg/anydataset-db
More information about byjg/anydataset-db
Files in byjg/anydataset-db
Vendor byjg
Package anydataset-db
Short Description AnyDataset-DB provides a relational database abstraction layer. It is part of the Anydataset project, an agnostic data source abstraction layer for PHP.
License MIT
Package anydataset-db
Short Description AnyDataset-DB provides a relational database abstraction layer. It is part of the Anydataset project, an agnostic data source abstraction layer for PHP.
License MIT
Please rate this library. Is it a good library?
Informations about the package anydataset-db
sidebar_key: anydataset-db tags: [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:
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:
Dependencies
All versions of anydataset-db with dependencies
PHP Build Version
Package Version
Requires
php Version
>=8.3 <8.6
ext-pdo Version *
psr/cache Version ^1.0|^2.0|^3.0
psr/log Version ^1.1|^2.0|^3.0
byjg/uri Version ^6.0
byjg/anydataset Version ^6.0
ext-json Version *
ext-pdo Version *
psr/cache Version ^1.0|^2.0|^3.0
psr/log Version ^1.1|^2.0|^3.0
byjg/uri Version ^6.0
byjg/anydataset Version ^6.0
ext-json Version *
The package byjg/anydataset-db contains the following files
Loading the files please wait ...