Can I Subscribe to a DB Table?

mkleehammer / pyodbc

Python ODBC bridge

https://github.com/mkleehammer/pyodbc/wiki

MIT No Attribution

2.92k stars 563 forks source link

Can I Subscribe to a DB Table? #997

Closed ahmedosama9777 closed 2 years ago

ahmedosama9777 commented 2 years ago

Python: 3.8.10
OS: Ubuntu 20.04
DB: Microsoft SQL Server
driver: ODBC Driver 17 for SQL Server

gordthompson commented 2 years ago

What precisely do you mean by "subscribe"?

ahmedosama9777 commented 2 years ago

For example watch for changes on a certain table, so when there is an insertion, update or delete operation I can be notified somehow. Just like subscribers in websockets.

gordthompson commented 2 years ago

pyodbc does not have that sort of capability, but you may get some ideas on Stack Overflow here:

https://stackoverflow.com/search?q=%5Bsql-server%5D+notify+updates