opis/database

A database abstraction layer over PDO, that provides a powerful and intuitive query builder, bundled with an easy to use schema builder
87,520 97
Install
composer require opis/database
Latest Version:4.3.0
PHP:^7.0 || ^8.0
License:Apache-2.0
Last Updated:Sep 29, 2024
Links: GitHub  ·  Packagist
Maintainer: msarca

Opis Database

Tests Latest Stable Version Latest Unstable Version License

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"
    }
}

Related Packages

usmanhalalit/pixie

A lightweight, expressive, framework agnostic query builder for PHP.

2,293,981 675
aura/sqlquery

Object-oriented query builders for MySQL, Postgres, SQLite, and SQLServer; can b...

3,304,766 456
atlas/statement

Object-oriented statement builders for MySQL, Postgres, SQLite, and SQLServer.

16,211 3
pecee/pixie

Lightweight, fast query-builder for PHP based on Laravel Eloquent but with less...

36,609 42
repat/laravel-medoo

Laravel Facade and ServiceProvider for The Lightest PHP database framework to ac...

248 5