Push notification from MYSQL

Question

I am having my database created in MYSQL and a WebSocket application(Autobahn Wamp WebSocket v1) created in Python. I have an application which makes entries in my database.

My requirement is that I need to create a trigger in MYSQL which would notify my Python WebSocket application(Autobahn Wamp WebSocket v1) when data gets inserted in my database.

I would like to know whether it is possible to achieve the above mentioned functionality or not, and if yes how?

Thanks in advance.

This seems like a pretty full example with MySQL code: http://stackoverflow.com/questions/13474012/invoke-pusher-when-mysql-has-changed — aychedee, Jul 31 '14 at 06:56
The MySQL data can be inserted by others than your Web app ? — Miguel Prz, Jul 31 '14 at 06:57
PostgreSQL allows you to do this via a TRIGGER and NOTIFY : http://www.postgresql.org/docs/9.3/static/sql-notify.html. I don't whether MySQL has similar functionality. — oberstet, Jul 31 '14 at 08:19

score 3 · Answer 1 · answered Jul 31 '14 at 07:01

3

The python-mysql-replication project maybe interesting. It allows you to receive event like insert, update, delete with their datas from your application

answered Jul 31 '14 at 07:01

Miguel Prz

13,718
29
42

score 1 · Answer 2 · edited Sep 03 '19 at 15:30

1

I think you can use pubsubsql which is Mysql push notification service. The link is as follows :
https://github.com/pubsubsql

edited Sep 03 '19 at 15:30

Bostone

36,858
39
167
227

answered Jun 01 '15 at 11:08

bharatj

2,327
1
25
25

This project lost their .com domain to squatters. I replaced it with GitHub link – Bostone Sep 03 '19 at 15:30

Push notification from MYSQL

2 Answers2