best way to notify database changes to an app

Solar2D General Questions/Discussion
#1

Hi guys,

I’m kind of lost here. I’m making a multi-player game that displays a table of rows.
My problem is if User “A” adds a new record to the Database while User “B” has the application running, how do you update or notify User "B"of the new record?

I tried using a timer, to query the DB every 10 secs and reload the data…
But that’s gonna be a lot of queries if have multiple users using the app at the same time…

I appreciate any input.
thanks a lot! :slight_smile: [import]uid: 74667 topic_id: 32720 reply_id: 332720[/import]

#2

One question, is the database a local or are you accessing a database server on internet?

joakim [import]uid: 81188 topic_id: 32720 reply_id: 130116[/import]

#3

One question, is the database a local or are you accessing a database server on internet?

joakim [import]uid: 81188 topic_id: 32720 reply_id: 130116[/import]

#4

Hi, it’s on a server. at the moment I’m using Parse, and the Api requests are skyrocket high … thus my concern of finding an ideal way. [import]uid: 74667 topic_id: 32720 reply_id: 130150[/import]

#5

This is a use for Push Notifications.
[import]uid: 19626 topic_id: 32720 reply_id: 130152[/import]

#6

Hi, it’s on a server. at the moment I’m using Parse, and the Api requests are skyrocket high … thus my concern of finding an ideal way. [import]uid: 74667 topic_id: 32720 reply_id: 130150[/import]

#7

Depends on your application but you might want to look into Pubnub or similar. I’m currently testing Noobhub which is similar as Pubnub but self hosted. [import]uid: 65415 topic_id: 32720 reply_id: 130163[/import]

#8

This is a use for Push Notifications.
[import]uid: 19626 topic_id: 32720 reply_id: 130152[/import]

#9

Depends on your application but you might want to look into Pubnub or similar. I’m currently testing Noobhub which is similar as Pubnub but self hosted. [import]uid: 65415 topic_id: 32720 reply_id: 130163[/import]