Phalcon Layer
It powers the model layer in the framework. It is found under the directory Phalcon\Db. It consists of abstraction layer which is written in C programming language.
Database Adapter
Phalcon uses PDO_ to connect to databases. It supports following Database engines:
Class |
Description |
Phalcon\Db\Adapter\Pdo\Mysql |
It is the most used relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. |
Phalcon\Db\Adapter\Pdo\Postgresql |
PostgreSQL is a powerful, open source relational database system. It provides reliability, data integrity, and correctness. |
Phalcon\Db\Adapter\Pdo\Sqlite |
SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine |
Implementation
Database Dialects
Phalcon stores specific details of database engine in dialects.
Class |
Description |
Phalcon\Db\Dialect\Mysql |
SQL specific dialect for MySQL database system |
Phalcon\Db\Dialect\Postgresql |
SQL specific dialect for PostgreSQL database system |
Phalcon\Db\Dialect\Sqlite |
SQL specific dialect for SQLite database system |
|