Working with databases

Yii doesn’t dictate using a particular database or storage for your application. There are many ways you can work with relational databases:

• Yii DB
• Yii Active Record
• Cycle via Yii Cycle package
• Doctrine via Yii Doctrine package
• PDO

For non-relational ones, there are usually official libraries available:

• ElasticSearch
• Redis
• …

In this guide, we will focus on working with relational databases using Yii DB.

Configuring connection

Creating and applying migration

Inserting

Selecting

Using data package

Pagination

[!NOTE] ← Working with forms | Generating code with Gii →