Compatibility Index

    Databases

    Some features are not available through all PDO supported databases. You can see here a list of primary limitations.

    At the moment we list only MySQL, SQLite and Postgres since only those are unit tested and fully supported.

    Foreign Keys

    Functionality MySQL SQLite Postgres
    General Yes Partial(1) Yes
    name attribute Yes No(2) Yes

    1) As of version 3.6.19, SQLite supports foreign key constraints.

    2) SQLite does not support named foreignKeys.

    Other

    Functionality MySQL SQLite Postgres
    Multiple autoincrement Yes No(1) Yes
    Composite PK with one autoIncrement Yes Partial(2) Yes
    index-column size attribute Yes Np(3) No(3)

    1) SQLite does not support multiple columns with autoIncrement set to true.

    2) SQLite does not support a composite PK where one of these is a autoIncrement. We support it anyways because we’re setting primaryKey=false and create a unique constraint instead, which is at the end basically the same.

    3) Only MySQL supports a concrete size at a index-column.

    PHP Versions

    Update PHP to version 5.5 or upper.