The Phalcon ORM is quite powerful and it allows the same PHQL search language to be used across multiple databases, including MySQL, PostgreSQL, and SQLite. Underlying all of the built-in database adapters is support for common SQL functions that are in common between all of the supported systems, or at least can be easily mapped to each one.
However, sometimes it may be necessary to use a feature of a particular database system that is not supported by the built-in database adapters. In this recipe, we will be extending the MySQL adapter with a dialect that allows it to use the fulltext indexing capability of that system.
This recipe uses the chapter_04
database that we set up in the chapter introduction and Phalcon Developer Tools, which we will use to set up a project skeleton.
This chapter uses Composer to install the Phalcon Incubator classes.