Wiki

Articles tagged with "db", sorted by commentsX
Displaying 1-4 of 4 result(s).

How to use nested DB transactions (MySQL 5+, PostgreSQL)

Created 5 years ago by mindehHow-tos6 comments – viewed 26,220 times – ( +44 ) – version 1.1
Original source code and idea are from: PHP, PDO & Nested Transactions.

Configuring CWebLogRoute for DB profiling

Created 3 years ago by Igor IvanovicTutorials1 comment – viewed 16,966 times – ( +3 ) – version 1.1
/index.php /protected/config/main.php
tags: logger, profiler, db

How to nest DB transactions without actually nesting them.

Created 5 days ago by le_topHow-tos0 comments – viewed 541 times – ( +1 ) – version 1.1
To secure your database from inconsistencies resulting from failing (complex) operations, you (should) use transactions. However, complex methods often rely on other complex methods that themselves build on transactions. This HowTo presents a method to nest or embed transactions without relying on the database's nesting capabilities.

How to store array/widget configuration to the database with config validation rules

Created 6 months ago by Kartik VTutorials0 comments – viewed 2,295 times – ( +29 / -4 ) – version 2.0
You may have scenarios, where you want to store a specific array configuration to the database. A classic example could be saving Yii widget configuration to the database and then retrieving it at runtime, with dynamic parameters set. This wiki discusses one of the approaches to do this. Let's consider you have something like the NavBar configuration below to store in the db: