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

<?php

use Phalcon\Db\Adapter\Pdo\Factory;

$options = [
    'host'     => 'localhost',
    'dbname'   => 'javatpoint',
    'port'     => 3306,
    'username' => 'siddharth',
    'password' => 'flash',
    'adapter'  => 'mysql',
];

$db = Factory::load($options);
?>

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