Transactions & db_session Transaction isolation levels and database peculiarities READ COMMITTED vs. SERIALIZABLE mode SQLite PostgreSQL MySQL Oracle CockroachDB Transact...

Working with db_session db_session and the transaction scope Several transactions within the same db_session Nested db_session db_session cache Using db_session with generator ...

Transactions and db_session Transactions and db_session A database transaction is a logical unit of work, which can consist of one or several queries. Transactions are atomic, w...

POST /rest/db/ignores POST /rest/db/ignores Expects a format similar to the output of GET /rest/db/ignores call, but only containing the ignore field (expanded field should b...

GET /rest/db/file GET /rest/db/file Returns most data available about a given file, including version and availability. Takes folder and file parameters. { "availability...

Class Phalcon\Db\RawValue Methods Class Phalcon\Db\RawValue This class allows to insert/update raw data without quoting or formating. The next example shows how to use the M...

Class Phalcon\Db\Profiler Methods Class Phalcon\Db\Profiler Instances of Phalcon\Db can generate execution profiles on SQL statements sent to the relational database. Profil...

Class Phalcon\Db\Index Methods Class Phalcon\Db\Index implements Phalcon\Db\IndexInterface Allows to define indexes to be used on tables. Indexes are a common way to enhan...

Class Phalcon\Db\Exception Methods Class Phalcon\Db\Exception extends class Phalcon\Exception Methods final private Exception __clone () inherited from Exception Clone...

Interface Phalcon\Db\ResultInterface Methods Interface Phalcon\Db\ResultInterface Source on GitHub Methods abstract public execute () … abstract public fetch () … ...