Database Access is made available through the use of the Record component. This section provides an overview of the Record components and common uses.
Data Management
Select
Insert
Update
Delete
Table Management
Create
Alter
Truncate
Drop
Transactions
Transactions offer a method of executing queries in series, with the ability to roll back to a previous state if an error occurs.
Transactions must be supported by the database engine
Blesta uses the InnoDB engine for all of its tables, and you are encouraged to do the same. Transactions will fail on database engines that do not support transactions.