At least one database (postgres) has a pub/sub messaging facility
(NOTIFY/LISTEN) that you can use to do this. See the postgres docs. We
use this extensively.
On the listen end, you basically want to get down to the psycopg layer,
because sqlalchemy's layers aren't going to be helpful.
1.
Dave,
Thanks for the response. Unfortunately the switch to PostgreSQL, while not
a long ways away, probably will not occur until at least the beginning of
next year and this rewrite is needed now. If there are no other options
available then I'll just need to brute force it. :)
- Ken
On Wed,
I'm going to try to see if I can give enough detail here to allow folks to
make sense, but I will be simplifying things a bit to prevent a 1,000+ line
email, too...
So I have an in-house application that handles software deployments. It
uses a database backend to keep track of current