_posts/2017-6-8-Pick the right data solution for Azure App Service.html [3:168]: - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - hide_excerpt: true ---
mksunitha
App Service makes building data driven solutions easier via the Azure portal. Azure app service supports various data solutions like SQL , MySQL  etc. To help understand how these data solutions work with App Service (Web Apps, Mobile Apps, Functions) and pick the right solution based on your needs, view the table below. 
* Free Azure SQL DB  offers one SQL Database per subscriptions limited to 32 MB for free for one year. ** Both Linux and Windows App service platforms support use of these data solutions , but based on your application framework you may require additional libraries in your application code to connect to the database. *** Currently App Service backup and restore feature does not support database connections over SSL. **** Azure Functions supports Azure SQL DB , MySQL and PostgreSQL via the  .NET SDK of these respective data services. For cosmos DB you can use binding or the SDK.
Azure SQL DB MySQL in-app  Azure Database for MySQL  Azure Database for PostgreSQL  Cosmos DB
Generally available  ✓ ✓ Public Preview  Public Preview ✓
Free Database Tier  * ✓ ✓
Managed Database as a Service ✓ ✓ ✓ ✓
Remotely access database ✓ ✓ ✓ ✓ ✓
Documentation link link link link link
Scalability ✓ ✓ ✓ ✓
Geo Replication ✓ ✓
SSL ✓ ✓ ✓ ✓
Firewall Configuration ✓ ✓ ✓ ✓
Database Sharding /Partitioning  ✓ ✓
Pricing link link link link
Region Availability  link
Linux Azure Web Apps ** ✓ link ✓ ✓ ✓
Windows Azure Web Apps ** ✓ link ✓ ✓ ✓
App service Backup and Restore *** ✓ ✓ ✓ ✓
Azure Mobile App ✓ ✓
Azure Functions ****  ✓ ✓ ✓  ✓
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - old_posts/2017-6-8-Pick the right data solution for Azure App Service.html [3:168]: - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - hide_excerpt: true ---
mksunitha
App Service makes building data driven solutions easier via the Azure portal. Azure app service supports various data solutions like SQL , MySQL  etc. To help understand how these data solutions work with App Service (Web Apps, Mobile Apps, Functions) and pick the right solution based on your needs, view the table below. 
* Free Azure SQL DB  offers one SQL Database per subscriptions limited to 32 MB for free for one year. ** Both Linux and Windows App service platforms support use of these data solutions , but based on your application framework you may require additional libraries in your application code to connect to the database. *** Currently App Service backup and restore feature does not support database connections over SSL. **** Azure Functions supports Azure SQL DB , MySQL and PostgreSQL via the  .NET SDK of these respective data services. For cosmos DB you can use binding or the SDK.
Azure SQL DB MySQL in-app  Azure Database for MySQL  Azure Database for PostgreSQL  Cosmos DB
Generally available  ✓ ✓ Public Preview  Public Preview ✓
Free Database Tier  * ✓ ✓
Managed Database as a Service ✓ ✓ ✓ ✓
Remotely access database ✓ ✓ ✓ ✓ ✓
Documentation link link link link link
Scalability ✓ ✓ ✓ ✓
Geo Replication ✓ ✓
SSL ✓ ✓ ✓ ✓
Firewall Configuration ✓ ✓ ✓ ✓
Database Sharding /Partitioning  ✓ ✓
Pricing link link link link
Region Availability  link
Linux Azure Web Apps ** ✓ link ✓ ✓ ✓
Windows Azure Web Apps ** ✓ link ✓ ✓ ✓
App service Backup and Restore *** ✓ ✓ ✓ ✓
Azure Mobile App ✓ ✓
Azure Functions ****  ✓ ✓ ✓  ✓
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -