db

db copied to clipboard

vjik

Support FETCH n FIRST/NEXT ROWS expression for limit

1

Postgres since 13, and oracle since 12 ver support expression `OFFSET start { ROW | ROWS } FETCH { FIRST | NEXT } [ count ] { ROW | ROWS...

Insolita

devanych

See https://github.com/yiisoft/yii2/pull/18407#discussion_r530507105

samdark

Split connection into master and slave

24

Currently both master and slave connections use the same class. This violates the SRP. We should have a class that only implements the slave connection part and one class that...

SamMousa

Use utf8mb4 by default in mysql, not utf8

3

*@teo1978 commented on Jul 29, 2018, 3:42 PM UTC:* MySQL's "`utf8`" charset, which shouldn't even be called that since it is not actual utf8, was a disgrace that happened years...

ghost

Separated scheme loading from main thread.

4

### What steps will reproduce the problem? Schema loading on the main thread is problematic in several ways (like yii2): - block main thread, increase response delay - this is...

kamarton

Events

1

What events do you think are usable to be emitted by database abstraction layer?

samdark

Provide info for yii-debug

1

The following info should be useful: - SQL queries - Timings - Connections - Schema reading What else?

samdark

How to set a PDO statement attribute?

12

I have to use the each method to select in batches. The problem is, that I have to delete some columns in this foreach, which generates a table lock. Now...

aliechti