Answers: <p>If you want to keep with almost no code/syntax changes because adapting to another database engine, you can just boot a small VM with SQL Server 2019 Express edition on it.</p>
  
Answers: CC BY-SA 4.0
Answers: 2020-10-04T14:55:46.077Z
Answers: 2020-10-04T14:55:46.077Z
Answers: Pedro Bonilla
Answers: <p>Why not spin up a virtual machine (ec2) and install a LAMP server on it.</p>
  <p>MySQL server is free and the EC2 instance should be way cheaper than the SQL server.</p>
  <p>(We do this on AWS; should work on Azure, too.)</p>
  
Answers: CC BY-SA 4.0
Answers: 2020-10-01T07:26:58.113Z
Answers: 2020-10-01T07:26:58.113Z
Answers: Danny Schoemann
Answers: <p>You can use Storage Account Table.</p>
  
Answers: CC BY-SA 4.0
Answers: 2020-12-16T18:57:11.200Z
Answers: 2020-12-16T18:57:11.200Z
Answers: Piotr Gwiazda
Answers: <p>You may be describing a key value store. It is unlikely that you need SQL or relational.</p>
  <p>To avoid vendor-lock-in, and to control your costs. Avoid complex services from the cloud providers. Rent a machine or virtual machine from them, and put your own services on it. There are many Free and Open Source databases. Do some research: start with key-value stores (these are the simplest, fastest, but also low functionality, databases).</p>
  
Answers: CC BY-SA 4.0
Answers: 2020-10-03T09:54:58.470Z
Answers: 2020-10-03T09:54:58.470Z
Answers: ctrl-alt-delor
Body: <p>I am building a system that processes articles from news websites and pushes the content to an analytics engine. The majority of the Azure cost from an SQL database.</p>
  <p>This database is used to store a list of the urls to different websites. Each row is the name of the news source and the matching url link. If one wishes to add a news source, a new row is added manually. So the number of records is very little and stay like so when productionising, i.e. in alpha phase now, we have about 5 records, long term we may have 100-200 records maximum.</p>
  <p>The bulk of the database cost comes from the read-write operations that happen frequently (every 15 seconds, all the rows are updated).</p>
  <p>We feel like there should be a cheaper alternative Azure resource to store this little amount of data, rather than an expensive SQL database. A no SQL database somewhere, a simple JSON file that can be hosted somewhere on Azure, etc...?</p>
  <p>What are your thoughts?</p>
  
Tags: <azure><cost-management>
Title: Cheap alternative to Azure SQL database
UserDisplayName: webdesignone
ThreadText: # Cheap alternative to Azure SQL database
  
  (Asked by: username_0 on 2020-09-30)
  
  I am building a system that processes articles from news websites and pushes the content to an analytics engine. The majority of the Azure cost from an SQL database.
  
  This database is used to store a list of the urls to different websites. Each row is the name of the news source and the matching url link. If one wishes to add a news source, a new row is added manually. So the number of records is very little and stay like so when productionising, i.e. in alpha phase now, we have about 5 records, long term we may have 100-200 records maximum.
  
  The bulk of the database cost comes from the read-write operations that happen frequently (every 15 seconds, all the rows are updated).
  
  We feel like there should be a cheaper alternative Azure resource to store this little amount of data, rather than an expensive SQL database. A no SQL database somewhere, a simple JSON file that can be hosted somewhere on Azure, etc...?
  
  What are your thoughts?
  
  **Tags:** azure, cost-management
  
  
  ---
  
  ## 4 answers
  
  ### Answer by username_4 on 2020-10-03. Score: 1
  
  You may be describing a key value store. It is unlikely that you need SQL or relational.
  
  To avoid vendor-lock-in, and to control your costs. Avoid complex services from the cloud providers. Rent a machine or virtual machine from them, and put your own services on it. There are many Free and Open Source databases. Do some research: start with key-value stores (these are the simplest, fastest, but also low functionality, databases).
  
  
  ---
  
  ### Answer by username_1 on 2020-10-04. Score: 0
  
  If you want to keep with almost no code/syntax changes because adapting to another database engine, you can just boot a small VM with SQL Server 2019 Express edition on it.
  
  
  ---
  
  ### Answer by username_2 on 2020-10-01. Score: 0
  
  Why not spin up a virtual machine (ec2) and install a LAMP server on it.
  
  MySQL server is free and the EC2 instance should be way cheaper than the SQL server.
  
  (We do this on AWS; should work on Azure, too.)
  
  
  ---
  
  ### Answer by username_3 on 2020-12-16. Score: 0
  
  You can use Storage Account Table.
  
  
  ---
  
  