Re: [sqlalchemy] Sane way to monitor external DB changes from application?

2015-09-02 Thread Dave Vitek
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.

Re: [sqlalchemy] Sane way to monitor external DB changes from application?

2015-09-02 Thread Ken Lareau
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,

[sqlalchemy] Sane way to monitor external DB changes from application?

2015-09-02 Thread Ken Lareau
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