1.3.9. /db/_shards 1.3.10. /db/_shards/doc 1.3.11. /db/_sync_shards 1.3.9. /db/_shards New in version 2.0. GET /{db}/_shards The response will contain a list of databa...

1.4.1. /db/doc 1.4.1.1. Attachments 1.4.1.1.1. Basic Attachments Info 1.4.1.1.2. Retrieving Attachments Content 1.4.1.1.2.1. Efficient Multiple Attachments Retrieving 1.4.1.1.3...

1.3.17. /db/_security 1.3.17. /db/_security GET /{db}/_security Returns the current security object from the specified database. The security object consists of two compul...

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...