Re: [development] db advanced features: transactions, constraint and data integrity

Ivan Sergio Borgonovo wrote:

I'm developing a couple of modules that will run on pgsql and I noticed how much I relay on "on delete cascade" and how much pain it should be in terms of performances relying on "delete" users and node hooks when you mass delete stuff.

A bunch of my modules require InnoDB. Check out PressFlow Transaction for some of my work. We'll probably work on significant transaction support in Drupal 7. The PHP 5.2 requirement will be invaluable to improving database interaction.