Skip to content

yiisoft/db

Folders and files

NameName
Last commit message
Last commit date

Latest commit

0424b52 · Oct 26, 2023
Aug 15, 2023
Mar 26, 2023
Aug 30, 2023
Oct 26, 2023
Oct 26, 2023
Jan 11, 2022
Nov 30, 2022
Jul 13, 2023
Nov 29, 2020
Mar 31, 2023
Oct 14, 2023
Nov 18, 2020
Apr 14, 2023
Apr 11, 2023
Apr 29, 2023
Oct 13, 2023
Jan 11, 2022
Aug 15, 2023
Feb 14, 2023
Jun 20, 2023

Repository files navigation

YiiFramework

Yii Database

Yii Database is a framework-agnostic package to work with different types of databases, such as MariaDB, MSSQL, MySQL, Oracle, PostgreSQL, and SQLite.

Using the package, you can perform common database tasks such as creating, reading, updating, and deleting records in a database table, as well as executing raw SQL queries.

$rows = (new Query($db))  
    ->select(['id', 'email'])  
    ->from('{{%user}}')  
    ->where(['last_name' => 'Smith'])  
    ->limit(10)  
    ->all();

The package is designed to be flexible and can be extended to support extra database types or to customize the way it interacts with databases.

There is an ActiveRecord implementation built on top of it. It allows interacting with database tables using objects, similar to the way you would use ORM (Object-Relational Mapping) frameworks like Doctrine or Hibernate.

Latest Stable Version Total Downloads Build status codecov static analysis type-coverage

Usage

Check the documentation to learn about usage.

Support

If you need help or have a question, the Yii Forum is a good place for that. You may also check out other Yii Community Resources.

Testing

Check the testing instructions to learn about testing.

Support the project

Open Collective

Follow updates

Official website Twitter Telegram Facebook Slack

License

The Yii DataBase Library is free software. It's released under the terms of the BSD License. Please see LICENSE for more information.

Maintained by Yii Software.