We're excited to announce Yii Database 2.0, a major release modernizing the database abstraction layer with PHP 8.1+ features, enhanced type safety, and powerful new capabilities. The drivers have been released as well: PostgreSQL, MySQL/MariaDB, MSSQL, Oracle and SQLite.

New Features

• Implement ColumnInterface classes according to the data type of database table columns
  for type casting performance
• ConnectionProvider for connection management
• ColumnBuilder for column creation
• CaseX expression for CASE-WHEN-THEN-ELSE statements

One more package has been released. This time it's a wrapper around Cycle ORM for Yii ecosystem. Cycle is known for support both classic and daemonized PHP applications based for example on RoadRunner.

The package offers a set of console commands and tools for convinient work with DB migrations and schema.

Right before the release the decision was taken to move the part related with Yii Data adaptation to a separate package - Yii Data Cycle, similar to Yii Data DB. All of them will be released too soon enough. First Yii Data 2.0, then first releases of adapter packages will follow.

Just a reminder, using Yii Cycle in demo doesn't mean it's a recommended tool / default package for working with DB. You can also choose Yii DB for example.

Code coverage with tests, mutational index and static analysis level were increased to their maximum.

Yii Database package was tagged along with its drivers.

Yii Database 1.3

• Deprecate unnecessary argument $rawSql of AbstractCommand::internalExecute()
• Specify result type of QueryInterface::all(), CommandInterface::queryAll() and DbArrayHelper::populate() methods to array[]
• Specify populate closure type in BatchQueryResultInterface
• Skip calling CommandInterface::getRawSql() if no logger or profiler is set

First release of Yii Database 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();