mittnett/dbal

A very simple database abstraction layer. Uses PDO under-the-hood and supports mysql/mariadb and postgres.

v1.4.2 2022-10-15 21:10 UTC

Requires

• php: >=8.0.0 <9
• ext-pdo: *

Requires (Dev)

• phpstan/phpstan: ^0.12.64
• phpunit/phpunit: ^9.5
• roave/security-advisories: dev-latest

Suggests

• ext-pdo_mysql: For MySQL driver
• ext-pdo_pgsql: For Postgres driver

MIT

README

A very simple database abstraction layer. Uses PDO under-the-hood and supports mysql/mariadb and postgres.

Usage

Setup a connection:

<?php

// MySQL:
$db = new \HbLib\DBAL\DatabaseConnection(new PDO('mysql:host=localhost;dbname=app', 'app', 'secret'), new \HbLib\DBAL\Driver\MySQLDriver());

// Postgres:
$db = new \HbLib\DBAL\DatabaseConnection(new PDO('pgsql:host=localhost;dbname=app', 'app', 'secret'), new \HbLib\DBAL\Driver\PostgresDriver());

One can use \HbLib\DBAL\LazyDatabaseConnection which only creates the PDO connection when needed.