@William Thompson Thank you for reaching out.
I am sorry that AI copilot did not share a complete and clear answer to your ask.
When choosing a database for your mobile app, you have a couple of options.
Choosing the right database will depends on your use case.
- What type of data will you store (e.g., files, databases, logs)?
- How much data do you expect to handle?
- What are the read and write patterns (random vs. sequential)?
- Is low latency critical for your application?
Azure Data platform provides different types of Databases. Each option has its strengths, so choose based on your specific app requirements.
Azure Cosmos db , Azure SQL Database, Azure PostgreSQL and MySQL...
- Azure SQL Database: Offers automatic scaling, high availability, and built-in security features. Use Case: If your app requires structured data with strict relationships between tables, Azure SQL Database is a good choice. Azure SQL Database do also have serverless whether you can auto-paise the database for inactive period.
- Azure Cosmos DB: Use Case: If your app requires a versatile and powerful non-relational database that can handle different data models and APIs, Azure Cosmos DB is a good fit. If your app requires massive scale for high throughput or very large database sizes, Cosmos DB is an excellent choice.
- Azure MySQL flexible server: Suitable for web development and relational data processing. Popular choice for web applications.
- Azure PostgreSQL Flexible server: Open-source database system with deployment flexibility. Used in a wide range of application development scenarios.
- Microsoft Power Apps: Great for rapid app development, especially when you don’t want to write extensive code. Suitable for business apps, forms, and simple data-driven applications.
I would suggest reading more about below.
https://learn.microsoft.com/en-us/azure/azure-sql/database/?view=azuresql
https://learn.microsoft.com/en-us/azure/cosmos-db/
https://learn.microsoft.com/en-us/azure/mysql/
https://learn.microsoft.com/en-us/azure/postgresql/
If you want to go for an Azure SQL Database, then this is a complete tutorial that will help.
Please comment below if you need more assistance.
Regards,
Oury