I've done research these past 3 days on how to possibly be notified in realtime for mysql. The issue is MySQL doesn't have that feature available so you have to result to other options like:
- Migrate data to using Cloud Functions with Firebase (FCM)
- Use React to listen for changes
Now it all sounds nice to have these options but I don't want to move any of my data to another DB. I enjoy using MySQL and want to keep my data there. I have registered users and keep track of comments, likes, posts etc. I use a custom API that I developed with php to communicate from MySQL to the mobile application.
What are my options that will allow me to keep my data in MySQL while also being able to implement a realtime notification feature that communicates with my android application? (if you can recommend maybe software and the process on how to go about it) Thank you in advanced!