How to create your own database and display data from it on the site?

Question

SQL

Hello!
I'm changing the question.
In general, I get the current weather data from a third-party resource http://weather data/wsdl, in the wsdl format. I display these weather data on the site. For example, Now the weather in Moscow is:
Temperature +6 C
Pressure 712 mb
Humidity 75%.
The data is updated every hour independently of me and, accordingly, they are not saved on my site.
I want to embed this data in parallel into a chart so that you can see the course of temperature and humidity during the day. For example, here https://realmeteo.ru/moscow/2/current , there are such diagrams at the very bottom of the site.
How can I store these weather values ​​and display them in a chart?

Answer 1

Well, if it's quick, then in visual studio there is a web application template. Use the codefirst approach. Matainit.ru has examples there.

Answer 2

Can you clarify what you mean by "your database"?
It works like this: there is a so-called. "engine" is software that provides you with an API for data input and output. There are many such engines - MySQL, PostgresSql, MS-Sql, MongoDb, SqLite, etc.
All have their pros and cons, you need to choose based on your development configuration and your needs.
Such a server (software) must be running and running on a machine that can be "reached out" from your application.
An alternative to using a database is file storage (where the data is simply stored in a file on disk next to your application).
What exactly to choose - based on your question, it's hard to say. How much data is expected to be stored? What is the most common operation (selection by conditions, record, aggregation)? How many requests per second (hour) need to be processed, etc.
If you have laboratory work at a university and you need to save 50 values, then you can not worry at all and store the data in a file.