How to send updates when data changes using MySQL Database?

Question

Alright I know you might find this as a silly question, but I'd like to ask you if there's a way to have a listener to MySQL like Firebase can do?

"...Firebase only sends updates to our app when data changes." - from learnhowtoprogram article

To make my question clear, I'm using nodejs, express & socket.io and I really wanted to make a simple web app which will automatically update its data once the database(MySQL) changes.

I've made a prototype using socket.io which listens to the client and emit new data from MySQL and vice versa. Yes, it works but in the long run it's horrible.

I hope you could help me with the concepts.

Thanks!

MrCharif · Accepted Answer · 2018-01-28 00:25:54Z

1

yes you can do that if you are using nodejs and socket try this lib : mysql-events

answered Jan 28, 2018 at 0:25

MrCharif

494 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

xtranghero Over a year ago

Thanks MrCharif. I'll check this lib out.

xtranghero Over a year ago

Unfortunately, I wasn't able to fully utilize mysql-events due to binlog_format is fixed in "row". I don't have the privilege to set the default binlog_format= from "mixed" to "row".

Collectives™ on Stack Overflow

How to send updates when data changes using MySQL Database?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related