2023-04-12 1329次浏览

First release of Yii Databasehttps://github.com/yiisoft/db and its drivers is done.

It 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.

As usual, it is fully covered with tests and static analysis. The same applies to each specific database driver.

// special thanks goes to Wilmer Arambula and Valerii Gorbachev who did the impossible work of porting Yii2 DBAL, re-working it and improving it