I wanted to ask you about the paradigm I am using to work on my application with respect to the information that it handles: Basically, when I want to update the information I have to call my web service to update the data I store with sqlite. The issue is that you get to a point where this is uncomfortable and unmanageable at the process and user level.
I understand that by ex. FIREBASE provides you with an API where you manage listeners. Where any change suffered by your DATA (NoSql) triggers (as a trigger) changes to all devices in real time.
My query was to know if there is something similar that can be done with sql server as an engine? or any recommendation / advice to see what path to take without having to pay or evaluate if I have no other alternative.