Ionic with azure database


#1

What is the best practice for adding a SQL database from azure to ionic. I haven’t been able to figure out how to configure that environment. I’ve tried using cordova-plugin-ms-azure-mobile-engagement am I on the right track? I also don’t have a backend framework installed. is this necessary? I am pretty new to ionic.

Thanks.


#2

Most applications that are storing information on a server are concerned with securing it. The most important thing to remember about this during the design process is this:

The server is the only place you can secure anything. Anybody with a copy of the app binary can access any feature of the app.

So, what you typically want to do is write a REST application server that responds to HTTP endpoints and interacts with the database. What you almost certainly do not want to do is to just accept SQL queries over HTTP and execute them, which is what “adding a SQL database to Ionic” sounds scarily like to me.