Use something other than SQL for database storage

[dthaler]

• Investigate just using a .csv or .json or .xml log file store for log storage. See https://github.com/morrisjdev/FileContextCore or FileBaseContext in nuget
• Investigate backing up to Azure SQL database at a low frequency
• Investigate Azure Cosmos DB
  • https://learn.microsoft.com/en-us/azure/architecture/data-guide/technology-choices/data-storage
  • https://learn.microsoft.com/en-us/azure/cosmos-db/how-pricing-works
  • https://learn.microsoft.com/en-us/azure/cosmos-db/

[dthaler]

Learnings:

• FileContextCore doesn't work with .NET 8.0
• FileBaseContext doesn't support migrations.
• Azure Cosmos DB does appear to have partial support for migrations so might be easier to change to, and it does have some free tier.

[dthaler]

Got ok to use an app service and cosmosdb on the orcasound subscription