db

db copied to clipboard

arogachev

Reduce number of binding parameters

6

We can reduce the number of binding parameters by binding only values that need to be quoted (`string` and `binary` values). It is not necessary to bind `null`, `bool`, `int`...

Tigrov

Lazy parsing for `array`, `structured` and `json` types

3

Suggested to store in `ArrayExpression`, `StructuredExpression` and `JsonExpression` the string value retrieved from the database and convert it to an `array` or other PHP representation as the data is accessed....

Tigrov

Add `$ifExists` and `$cascade` to `dropTable()` methods

1

| Q | A | ------------- | --- | Is bugfix? | ❌ | New feature? | ✔️ | Breaks BC? | ✔️ Fix #773 - https://github.com/yiisoft/db-sqlite/pull/319

vjik

insertBatch to generate multiple INSERT statements

8

Right now, if the batch is too big, we're getting into limits of DBMS like the following:  _The screenshot is from PostgreSQL._ I suggest doing two things: 1. Introduce...

samdark

Enum cases support for build query

2

### What steps will reproduce the problem? ```php $query->andWhere(['category_name' => CategoryEnum::blablacat]) ``` ### What is the expected result? Am want suggest add logic to query for transformate enum case object...

lynicidn

See https://github.com/yiisoft/docs/blob/master/010-code-style.md#names

vjik

Calling yii\db\Query addSelect($fields) overwrites default select set

7

### What steps will reproduce the problem? ``` $query = ArClass::find(); $query->addSelect('extraField'); $item = $query->one(); ``` ### What is the expected result? `$item` has all default fields + 1 `extraField`,...

undestroyer

Support JSON data type in latest MySQL, Oracle, PostgreSQL

15

The latest updates from several DB such as MySQL, Oracle, PostgreSQL are all supporting JSON data type with basic operations: create, update, index, validate. Should we implement a support at...

fproject

Add SerializationFailureException. SQLSTATE code 40001 PDO exception substring: SQLSTATE[40001] Code is the same for all databases (mysql, pgsql, mssql, oracle).

olegbaturin