I’m new to the Particle community, so please bear with me. I know there are a ton of services out there, some free, some not, and of varying levels of complexity. I want to keep things as simple as possible and, for the time being at least, as cheap as possible.
So, based on my application description (below), I was wondering if you could recommend a good approach/service for push notifications and database integration.
In general terms, my project consists of a Photon module that, when an event happens (i.e. switch, sensor, alarm, etc), will do the following:
- Send a push notification to a mobile device (I’m only supporting iOS initially)
- Query an online database
- Perform an action based on the values it retrieves from the database (i.e. turn on a relay, flash an LED, etc)
- Update the same online database
- Send another push notification to the mobile device to signal that it’s finished
Now, for each transaction there will be less than a dozen parameters read from the database and only one or two parameters written to it. Also, it will be activity driven (i.e. no regularly timed transactions) and there will likely be less than 10 transactions per day.
NOTE: As per 'ScruffR’s comments, the iOS app will also need read/write access to the database.
So, based on that, can any of you gurus give me some recommendations to point me in the right direction?
I appreciate your time.