db
db copied to clipboard
yiisoft
Yii Database Library
Current implementation loads table foreign keys two times as arrays and as objects. PostgreSQL https://github.com/yiisoft/db-pgsql/tree/535975396d865da6cb15ed7bee5648c27a9b7360/src/Schema.php#L499 as arrays https://github.com/yiisoft/db-pgsql/tree/535975396d865da6cb15ed7bee5648c27a9b7360/src/Schema.php#L894 as objects MySQL https://github.com/yiisoft/db-mysql/blob/4dd4e13502a0f047627c398854fc733a41054370/src/Schema.php#L265 as arrays https://github.com/yiisoft/db-mysql/blob/4dd4e13502a0f047627c398854fc733a41054370/src/Schema.php#L618 as objects SQLite https://github.com/yiisoft/db-sqlite/blob/b172ec9c11f31a5618a80e8cc6e3b298f423eb26/src/Schema.php#L381 as...
Some comments are left for review and will be removed after. `ColumnSchema::dateTimeFormat()` and `ColumnSchema::$dateTimeFormat` can be removed, in this case it will be necessary to determine the format from `ColumnSchema`...
Example for `NO ACTION`: - SQLite, latest MySQL and PostgreSQL - `NO ACTION`. - MySQL 5.7 - `RESTRICT`. - MS SQL - `NOACTION`. - Oracle - `null` / `NO ACTION`.
What is the difference between `InvalidArgumentException` and `InvalidParamException`? Should be one replaced with another and then removed? | Q | A | ---------------- | --- | Version | 1.1.0 |...
The way that was advised by @darkdef ```php $qb->createTable( 'test', [ 'name' => 'varchar(255) NOT NULL', 'email' => 'varchar(255) NOT NULL', 'PRIMARY KEY (name, email)', ], ); ``` `PRIMARY KEY...
Interface `BatchQueryResultInterface` [extends](https://github.com/yiisoft/db/blob/2893abddc82dc1f89dec0e36e9c7beeb1a0a4ad1/src/Query/BatchQueryResultInterface.php#L37) `Iterator`, but [method](https://github.com/yiisoft/db/blob/master/src/Query/BatchQueryResultInterface.php#LL77C1-L77C1) `key()` returns `int|string|null`
Is this package supposed to be the base to build NoSQL implementations? MongoDB has basic primitives that match most SQL use cases (although heavy use of aggregations might be needed...
Need to introduce driver virtual package `yiisoft/db-driver-implementation`. Drivers should provide it, `db` should require it.
| Q | A | ------------- | --- | Is bugfix? | ❌ | New feature? | ✔️ | Breaks BC? | ✔️ | Fixed issues | https://github.com/yiisoft/db-mysql/issues/2
