The Perl Toolchain Summit needs more sponsors. If your company depends on Perl, please support this very important event.
 / 
Alzabo-0.60
River stage one • 2 direct dependents • 3 total dependents
++
/ Alzabo

NAME

Alzabo and MySQL

DESCRIPTION

This documentation is about what special support Alzabo has for MySQL, as well as what is lacking.

MySQL support is based on the 3.23.* release series, with some support for features that are starting to appear in the 4.0.* releases. Earlier versions of MySQL will probably work with Alzabo, though Alzabo cannot magically make these releases support new features like fulltext indexes.

Indexes

  • Alzabo supports the ability to specify prefixes when adding an index. Prefixes are required when attempting to index any sort of text or blob column.

  • Alzabo supports the creation of fulltext indexes and their use in SELECT and WHERE clauses. This includes the ability to get back the score given for a match as part of a select, using the function or select methods of either table or schema objects.

Reverse Engineering

  • When reverse engineering a schema, Alzabo knows that MySQL has "default defaults" for certain column types. For example, if a DATE column is specified as NOT NULL but is not assigned a default, MySQL gives this column a default of '0000-00-00'.

    Because Alzabo knows about this, it will ignore these defaults when reverse engineering an RDBMS.

  • Similarly, Alzabo knows that MySQL assigns defaults "lengths" to many column types. For example, if given INTEGER as a column type, MySQL will convert this to INTEGER(11) or INTEGER(10), depending on the version of MySQL being used.

    Again, Alzabo ignores these lengths when reverse engineering a schema.

Transactions

    Alzabo will try to use transactions whenever appropriate. Unfortunately, there is no way to determine whether or not a given table supports transactions so Alzabo simply sets AutoCommit to 0, whether or not this will actually do anything.

Constraints and Foreign Keys

  • Column constraints are treated as column attributes.

  • Foreign key constraints are not generated when generating SQL for a Postgres schema. This will probably change in the future.

Table Types

    As of now, there is no way to specify table specific attributes with Alzabo.