PHPackages                             wpjscc/database - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Database & ORM](/categories/database)
4. /
5. wpjscc/database

ActiveLibrary[Database & ORM](/categories/database)

wpjscc/database
===============

DBAL, schema introspection, migration and pagination

2.x-dev(1mo ago)0316MITPHPPHP >=8.1CI failing

Since Nov 8Pushed 1mo agoCompare

[ Source](https://github.com/wpjscc/database)[ Packagist](https://packagist.org/packages/wpjscc/database)[ Docs](https://cycle-orm.dev)[ GitHub Sponsors](https://github.com/sponsors/cycle)[ RSS](/packages/wpjscc-database/feed)WikiDiscussions 2.x Synced 1mo ago

READMEChangelogDependencies (12)Versions (4)Used By (6)

Cycle DBAL
==========

[](#cycle-dbal)

[![Latest Stable Version](https://camo.githubusercontent.com/6393e64e0ce9f9a809abd809de3013eb8b011b7ed25950e6006dbc12d243ce63/68747470733a2f2f706f7365722e707567782e6f72672f6379636c652f64617461626173652f762f737461626c65)](https://packagist.org/packages/cycle/database)[![Build Status](https://github.com/cycle/database/workflows/build/badge.svg)](https://github.com/cycle/database/actions)[![Scrutinizer Code Quality](https://camo.githubusercontent.com/4e5f5d081d5cd4ca6553d1c511bcae51302954d1a84163a39dc27cd4d753df7b/68747470733a2f2f7363727574696e697a65722d63692e636f6d2f672f6379636c652f64617461626173652f6261646765732f7175616c6974792d73636f72652e706e673f623d322e78)](https://scrutinizer-ci.com/g/cycle/database/?branch=2.x)[![Codecov](https://camo.githubusercontent.com/40b40c97bec5c96685de25c00efc8b34b4b33ac82cc9ea59d727c7b07a0a4841/68747470733a2f2f636f6465636f762e696f2f67682f6379636c652f64617461626173652f6272616e63682f322e782f67726170682f62616467652e737667)](https://codecov.io/gh/cycle/database/)

Secure, multiple SQL dialects (MySQL, PostgreSQL, SQLite, SQLServer), schema introspection, schema declaration, smart identifier wrappers, database partitions, query builders, nested queries.

Documentation
-------------

[](#documentation)

- [Installation and Configuration](https://cycle-orm.dev/docs/database-configuration)
- [Access Database](https://cycle-orm.dev/docs/database-access)
- [Database Isolation](https://cycle-orm.dev/docs/database-isolation)
- [Query Builders](https://cycle-orm.dev/docs/database-query-builders)
- [Transactions](https://cycle-orm.dev/docs/database-transactions)
- [Schema Introspection](https://cycle-orm.dev/docs/database-introspection)
- [Schema Declaration](https://cycle-orm.dev/docs/database-declaration)
- [Migrations](https://cycle-orm.dev/docs/database-migrations)
- [Errata](https://cycle-orm.dev/docs/database-errata)

Requirements
------------

[](#requirements)

Make sure that your server is configured with following PHP version and extensions:

- PHP 8.0+
- PDO Extension with desired database drivers

Installation
------------

[](#installation)

To install the component:

```
composer require cycle/database
```

Example
-------

[](#example)

Given example demonstrates the connection to SQLite database, creation of table schema, data insertion and selection:

```