My usual apprach is to have value objects that can be loaded or saved to a datastore, ie:
$datastore->beginTransaction();
my $person = $datastore->getPersonById($personid);
...manipulate $person...
$datastore->store($person);
$datastore->commitTransaction();
The main advantages of this is:
- Simplicity: The CRUD approach (Create, Retrieve, Update, Delete) is well understood and aligns well with SQL
- Performance: Access to the datastore is kept to a minimum
- Modularity: The datastore is decoupled from the value objects
I feel it's usually best to leave transaction management to the datastore, rather than trying to hack together something yourself.
-- Michael Snell
-- michael@snell.com