Revision: Thu, 18 Apr 2024 09:24:10 GMT
v1.0 – outdated
This version of the documentation is outdated. Consider upgrading your project to Spiral Framework 3.12
Edit this page

DBAL Errata

Documentation section lists non obvious behaviours of DBAL component and ways to avoid them.

Timestamps

Consider using 'datetime' type for your columns instead of 'timestamp' as it gives you more unified support and ability to define proper default values.

Timestamp fields behaviour is different in MySQL 5.5 and MySQL 5.6+!

Driver Specific notes

Not all drivers are implemented equally:

MySQL Driver

MySQL driver if fully supported by DBAL layer with all functionality being available.

Default table engine is set to InnoDB.

Postgres Driver

Postgres driver includes custom implementation of InsertQuery in order to address return value of auto-incremental PK, it will automatically add RETURNING {primary key} to generated SQL query.

SQLServer Driver

SQLServer includes fallback mechanism to limit your selection without orderBy specified. In some cases it might add additional _row_number_ column at the end of selected columns.

SQLServer is optimized to work with 12+ versions of Microsoft SQL Server.

SQLite Driver

SQLIte DBMS does not support set of table altering operations, in order to address some of schema migrations will be performed using temporary tables and data copy.