Menu
I have a PostgreSQL database. What I want to do is, detect any changes (insert, update) that happen in the database and then call a webservice. How could I do this?
Thanks in advance for any help.
288
Write-Ahead Log (WAL) is a very important term in transaction processing. In PostgreSQL, it is also known as a transaction log. A log is a record of all the events or changes and WAL data is just a description of changes made to the actual data.
createdb creates a new PostgreSQL database. Normally, the database user who executes this command becomes the owner of the new database. However, a different owner can be specified via the -O option, if the executing user has appropriate privileges. createdb is a wrapper around the SQL command CREATE DATABASE .
PostgreSQL REST API connection allows to create Restful applications with PostgreSQL as a database. A REST API (also known as RESTful API) is an application programming interface (API or web API) . The API follows the constraints of REST architectural style and allows for interaction with RESTful web services.
You should be able to use triggers and the listen/notify functionality in PostgreSQL to achieve something like this:
A set of insert/update/delete triggers create a notification event whenever anything changes in your table, using the created/changed/deleted ID as the payload.
A background process checks for notifications periodically (here's an example using Java/JDBC), and then loads the changed record from the database to do the web service call.
This is not in any way a real-time push-type system, but you have to poll the database for notification events to trigger the webservice call. It will do the trick, though.
100
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
