One of the very nice things about using SQLAlchemy is that since so much of the grunt-work is taken care of for you, it gives you the opportunity to come up with (potentially) hare-brained schemes like the one I just thought of. We would like to do reading of data with one set of logins and do writing with another. The reader 'binds' are pretty straightforward but the writer binds vary quite a bit from database to database and platform to platform (we have integrated security on some OS/dataserver/drivers/languages) The idea I have is to maintain a writer session with the specialized engine bindings and have the reader session copy any dirty data over to it at commit/ flush time (I got the idea from the thread on this group entitled "Updating database after after_insert()"). Is this a total kludge? Has anyone tried to do something like this already?
thanks very much. pjjH --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---