Listening for DB Change or for call from webservice

Unity Engine
1

Hi,

I was wondering, is it possible to listen for a change in a database, for example sqlite or mysql, with checking the database continuously ?

Or alternatively, is it possible to act as a webserver and listen for a http call in order to trigger a status update ?

2

Is this db on the web?

  1. if it’s local, you would know if it changed, because you changed it.

  2. if it’s on the web, and thusly it can change due to multiple users manipulating it… relying on a message from mysql is probably not good design. Your server should be the one manipulating the db, so it would know that it changed, and it can dispatch messages.

And yes, you can receive messages from a server… there’s many ways to do it. Many of them are made easier to use via 3rd party frameworks that are available for Unity.