On Wed, 6 May 2009 15:43:22 -0700 (PDT), Jeremy Burton <[email protected]> wrote: > My question is what do people suggest are the best approaches for a > database locking scheme using Pylons and SQLAlchemy?
I may be misunderstanding your question completely, but I'd have thought if you use a transactional/ACID compliant database server (e.g. PostgreSQL), you'll get database locking at the database layer for free, and can, for all intents and purposes ignore it. For example, while an update is being performed on a table due to someone having submitted a web form, your other threads will see a consistent copy of the data that represents the state of the database immediately prior to that form submission. All this, without having to explicitly add any locking code to your application tier. Regards, Matt. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "pylons-discuss" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/pylons-discuss?hl=en -~----------~----~----~----~------~----~------~--~---
