I'm curious about how my Azure bill will be affected by using either MSSQL or PostgreSQL for my database. If I develop and run these databases locally on my PC and then deploy the database along with my website to Azure, will the choice of database type affect my overall Azure costs? For example, in one case, I might use MSSQL and in another, PostgreSQL. Will I end up with the same bill regardless of which database I use? Also, just to provide some context, I plan to have around 20k products in my database, each with images.
2 Answers
It's generally not a good idea to store images directly in your database. You'll probably regret it later! Instead, consider saving them in Azure Blob Storage, which is optimized for that purpose. It can save you headaches down the line.
Yes, if you deploy both MSSQL and PostgreSQL as separate resources in Azure, you'll be billed for each one. However, if you deploy both databases on a single virtual machine, you'll only pay for the resources that VM uses. So, the key is how you choose to deploy them!
But does it really matter which database I used locally when I deploy? I'm just trying to understand if the local choice has any impact.