opis/database

A database abstraction layer over PDO, that provides a powerful and intuitive query builder, bundled with an easy to use schema builder

4.3.0 2024-09-29 19:50 UTC

Requires

• php: ^7.0 || ^8.0
• ext-pdo: *

Requires (Dev)

• phpunit/phpunit: ^6.5 || ^7.0 || ^8.0 || ^9.0
• symfony/yaml: ^3.4

Apache-2.0

• Marius Sarca
• Sorin Sarca

• database
• sql
• mysql
• sqlite
• query
• Abstraction Layer
• query builder
• postgre
• schema builder

README

Database abstraction layer

Opis Database is a library that implements an abstraction layer over the PDO extension, by providing a powerful query builder along with an easy to use schema builder. The aim of the library is to provide an unified way of interacting with databases, no matter of the underlying relational database management system.

Currently, we are officially supporting MySQL, PostgreSQL, Microsoft SQL, and SQLite. We also provide experimental support - without any commitment regarding bug fixes and updates - for Firebird, IBM DB2, Oracle, and NuoDB query builder.

Documentation

The full documentation for this library can be found here

License

Opis Database is licensed under the Apache License, Version 2.0

Requirements

• PHP 7 or higher
• PDO

Installation

Opis Database is available on Packagist and it can be installed from a command line interface by using Composer.

composer require opis/database

Or you could directly reference it into your composer.json file as a dependency

{
    "require": {
        "opis/database": "^4.0"
    }
}