Yii DB Migration version 2.1.0 was released. In this version:

• Add MigrationBuilder::insertBatch() method, deprecate batchInsert()
• Explicitly import classes, functions, and constants in "use" section
• Remove unnecessary files from Composer package
• Remove confirmation prompt from migrate:create command as creating a migration is non-destructive

Yii Translator DB Message Storage version 1.1.0 was released. In this version:

• Raise the minimum PHP version to 8.1
• Bump required yiisoft/db version to ^2.0
• Change PHP constraint in composer.json to 8.1 - 8.5
• Remove yiisoft/arrays dependency

Yii RBAC Database storage 2.1.0

Yii RBAC DB version 2.1.0 was released. In this version:

• Adapt to Yii DB 2
• Change PHP constraint in composer.json to 8.1 - 8.5
• Refactor AssignmentStorage::filterUserItemNames() method
• Bump yiisoft/rbac version to ^2.1

Yii Cache DB Handler version 1.1.0 was released. In this version:

• Bump supported version of yiisoft/db to ^2.0
• Change supported PHP versions to 8.1 - 8.5
• Mark DbSchemaManager::$db property as readonly

Yii Data DB, a database query adapter for Yii Data, is now available.

This package provides a data reader implementation that bridges Yii DB with the Yii Data reading interface, making it easy to work with database queries in a flexible and consistent way.

• QueryDataReader. Wraps database queries to provide pagination, sorting, and filtering capabilities.

Yii DB Migration version 2.0.0 was released. In this version:

• Add --force-yes (-y) option to migrate:create, migrate:up, migrate:down and migrate:redo
• Use ColumnBuilder class to create table column definitions
• Change supported PHP versions to 8.1 - 8.5 (@Tigrov,
• Remove ext-filter from require section of composer.json

We are pleased to present the first stable release of Yii Active Record — an implementation of the Active Record pattern for PHP.

The package is built on top of Yii DB, which means it comes with out-of-the-box support for major relational databases: PostgreSQL, MySQL, MSSQL, Oracle, SQLite.

Flexible Model Property Handling

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

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 stable version of DB Migration package was realeased.

It allows you to manage database schema using migrations.

Supports the following databases out of the box:

Yii Database package was tagged along with its drivers.

Yii Database 1.2

• Deprecate TableSchemaInterface::compositeForeignKey() and SchemaInterface::TYPE_JSONB
• Enhanced documentation of batchInsert() and update() methods of DMLQueryBuilderInterface interface
• Refactor Quoter
• Move methods from concrete Command class to AbstractPdoCommand class

Database package was tagged along with its drivers.

• Legacy array type-casting syntax was removed from db. Param should now be used instead.
• Drivers got more tests, refactoring and more edge-cases handled.

Here's the list CHANGELOGs:

• DB 1.1.0
• MSSQL 1.0.1

First stable version of Yii Translator DB Message Storage was tagged.

This package provides the database storage for the yiisoft/translator.

It allows you to store messages in databases supported by yiisoft/db: MariaDB, MSSQL, MySQL, Oracle, PostgreSQL, and SQLite.

First stable version of Yii Cache Library - DB Handler was tagged.

This package provides the database driver for the yiisoft/cache.

It allows you to store cache in databases supported by yiisoft/db: MariaDB, MSSQL, MySQL, Oracle, PostgreSQL, and SQLite.

First stable version of Yii Logging Library - DB Target was tagged.

This package provides the database target for the yiisoft/log.

It allows you to write logs into databases suppoerted by yiisoft/db: MariaDB, MSSQL, MySQL, Oracle, PostgreSQL, and SQLite.