Versus doctrine dbal - noresources/ns-php-sql GitHub Wiki

ns-php-sql versus Doctrine DBAL

In short

use Doctrine :)

Doctrine is stable, well documented and feature rich.

Comparisons

General

This project attempts to generate the most accurate SQL dialect for the targeted DBMS while Doctrine DBAL delegate this task to higher level modules such as Doctrine ORM.

Doctrine Platform interface contains a very huge number of functions, one for each thing thant may differ from one DBMS/Driver to another. This project attempts to keep a cleaner and smaller set of functions.

Column options

As in Doctrine, a column is an abstracted table column description

Doctrine ns-phpsql
NOT NULL column constraint "notnull" option COLUMN_DATA_TYPE property does not include DATA_TYPE_NULL flag
Maximum number of characters "length" option COLUMN_LENGTH property
Fixed size / padded content "fixed" COLUMN_PADDING* properties
Total number of digits "precision" column option COLUMN_LENGTH property
Fraction scale "scale" column option COLUMN_FRACTION_SCALE property
Unsigned number "unsigned" option COLUMN_FLAG_UNSIGNED flag of the COLUMN_FLAGS property
"comment" option
⚠️ **GitHub.com Fallback** ⚠️