James wrote:
>>I am evaluating to use MiddleKit for our new project development and would like to clarify how MiddleKit with MySQL store data without losing data integrity. For my case, I have an object (order) with couple of sub-objects - order line, if one of the order line update was fail, the whole order including any order lines should not be stored. Did MiddleKit have "transaction processing" in place? Anyone has the same concern?<< MiddleKit does not support transactions, and MySQL is not ACID compliant. Nobody that I'm aware of has plans to add transactions to MK, and the transaction support in MySQL is best described as "unproven." If you're trying to develop an app to handle (presumably) mission critical stuff like orders, you really ought to use a more robust DB. And, if you're ever intending to support ad-hoc queries of your data (as most order processing systems do), you're better off using a standard relational model (IMO). Check the Webware Wiki pages on Database Integration for more discussions and links on DB related matters. ...Edmund. _______________________________________________ Webware-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/webware-devel
