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 Database Relational abstraction. Anydataset is an agnostic data source abstraction layer in PHP.
License MIT
Package anydataset-db
Short Description Anydataset Database Relational abstraction. Anydataset is an agnostic data source abstraction layer in PHP.
License MIT
Please rate this library. Is it a good library?
Informations about the package anydataset-db
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.
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:
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:
Dependencies
All versions of anydataset-db with dependencies
PHP Build Version
Package Version
Requires
php Version
>=8.1 <8.4
ext-pdo Version *
psr/cache Version ^1.0|^2.0|^3.0
psr/log Version ^1.1|^2.0|^3.0
byjg/uri Version ^5.0
byjg/anydataset-array Version ^5.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 ^5.0
byjg/anydataset-array Version ^5.0
ext-json Version *
The package byjg/anydataset-db contains the following files
Loading the files please wait ....