Notify when database changes

Question

My server database needs to notify the android app when there is insert in a table. For example, when receiving an order I insert it into a SQL Server database. I also want user to get notification in my app about the order. The app is always opened. I use web services to contact with database.

How can I set this up?

score 0 · Answer 1 · answered Sep 24 '16 at 22:59

0

First of all, mysql or other sql servers are not real time databases. You have to notify your client in the same code you insert a record to your database. For this, the best option would be using websockets or push notifications.

So if your application will always be open as you said, you can use both equally. You will just emit the notification to the client(s) just after you inserted the order to database, and they will get it immediately.

For websockets, you can use socket.io. For push notification, i would prefer Google FCM.

answered Sep 24 '16 at 22:59

abeyaz

2,490
1
14
18

can i write php code in my server side that worke when database is updated and contact wthe my firebase consol to send notify to the client(s)?? – Al-amen Pgooja Sep 25 '16 at 14:33
I've found http://stackoverflow.com/questions/37371990/how-can-i-send-a-firebase-cloud-messaging-notification-without-use-the-firebase – Al-amen Pgooja Sep 25 '16 at 14:38
but i don't know how to use it – Al-amen Pgooja Sep 25 '16 at 14:39
Of course you can. You insert and update your records at all. This is the common way – abeyaz Sep 25 '16 at 15:36

Notify when database changes

1 Answers1