Author Topic: Microsoft's Azure - Anyone using this???  (Read 162 times)

0 Members and 1 Guest are viewing this topic.

Offline NW27

  • Contributor
  • Posts: 48
  • Country: au
Microsoft's Azure - Anyone using this???
« on: September 10, 2019, 01:57:17 am »
Hi All,

I'm creating a IoT device that will need to connect to the cloud for data storage.
I'm looking at using Microsoft's Azure and an SQL database.

Anybody else do this that can ease my learning curve a bit :) ?

Thanks,
Neril.
 

Offline Fred27

  • Supporter
  • ****
  • Posts: 549
  • Country: gb
    • Fred's blog
Re: Microsoft's Azure - Anyone using this???
« Reply #1 on: September 10, 2019, 10:15:23 am »
Three documentation on Azure is very good. Take a look at Microsoft's examples.
 

Offline obiwanjacobi

  • Frequent Contributor
  • **
  • Posts: 914
  • Country: nl
  • What's this yippee-yayoh pin you talk about!?
    • Marctronix Blog
Re: Microsoft's Azure - Anyone using this???
« Reply #2 on: September 12, 2019, 12:50:02 pm »
Let your device call a function with the payload.
The function can then connect to the SQL db and transform and store the data.

If you use something like Table storage, it is way cheaper. An Azure SQL DB is not cheap.
Table storage can also be called directly.

[2c]
Arduino Template Library | Zalt Z80 Computer
Wrong code should not compile!
 

Online NANDBlog

  • Super Contributor
  • ***
  • Posts: 4402
  • Country: nl
Re: Microsoft's Azure - Anyone using this???
« Reply #3 on: September 12, 2019, 01:09:13 pm »
You need some service running on the server, that acts like the endpoint for the communication. Like an MQTT broker. That places the data in the SQL database.  Stuff like this:
http://www.steves-internet-guide.com/logging-mqtt-sensor-data-to-sql-database-with-python/

The Azure server can be just a VM, doing the computing, or you can have just a database access, running on the cloud. One way, you are basically a sysadmin of the VM, and you can just develop the thing on a local linux machine, and then place it on the cloud. This can be easy to set up and develop, and then depending on your requirements, could be enough for years.
And then you can ask them to "give me a database", and they can take care of everything. Could cost more, but if you suddenly end up with 50 million users, you dont have to worry about database scaling. If you dont expect that, just buy a VM. Or you know, several VMs all doing different parts of the entire back/frontend. Whatever makes sense.
 

Offline obiwanjacobi

  • Frequent Contributor
  • **
  • Posts: 914
  • Country: nl
  • What's this yippee-yayoh pin you talk about!?
    • Marctronix Blog
Re: Microsoft's Azure - Anyone using this???
« Reply #4 on: September 12, 2019, 01:15:00 pm »
Azure is most effective if you use its PaaS services. So trying to do it yourself in a VM is 'suboptimal'.

You can get an idea what it'll cost you here: https://azure.microsoft.com/en-us/pricing/calculator/

Arduino Template Library | Zalt Z80 Computer
Wrong code should not compile!
 


Share me

Digg  Facebook  SlashDot  Delicious  Technorati  Twitter  Google  Yahoo
Smf