Do I need to follow ACID principles?
Posted: Sat Apr 05, 2025 5:15 am
Is there a need to read or write data online?
What amount of information are you going to store?
Is there a need to use columns?
I would like to note that it is best to use both versions of the SQL and NoSQL databases. It's just that each of these databases can be used for a separate project, because somewhere relational databases with a tabular version are needed where they will be easier to edit, and somewhere speed is more important and then NoSQL should be used.Each company needs its own database in which you can store data about customers, products, and so on. And to make it convenient to work with the database, it is necessary to use various kinds of relational systems, but among them we can single out MySQL, which has become one of the main systems for working with DBMS.
DBMS - database management special lead system
Windows
To configure MySQL, you need to download it from the official website
MySQL community edition is a free utility.
When you click on this link, you will have to choose which version to download WEB or full. In the screenshot you can see the difference
downloader
WEB - this version automatically downloads everything you need, but it requires Internet access. For example, if you want to install MySQL on a server without the Internet, then this version will not suit you.
Full version – this version can be installed on a system without internet access. It includes all the necessary data for installation on an offline system.
Before downloading, you will be redirected to a page where you will be asked to log in to your Oracle account or register it, and you can do this, but if there is no time, then click on "No thanks …” After that, the download will begin.
What amount of information are you going to store?
Is there a need to use columns?
I would like to note that it is best to use both versions of the SQL and NoSQL databases. It's just that each of these databases can be used for a separate project, because somewhere relational databases with a tabular version are needed where they will be easier to edit, and somewhere speed is more important and then NoSQL should be used.Each company needs its own database in which you can store data about customers, products, and so on. And to make it convenient to work with the database, it is necessary to use various kinds of relational systems, but among them we can single out MySQL, which has become one of the main systems for working with DBMS.
DBMS - database management special lead system
Windows
To configure MySQL, you need to download it from the official website
MySQL community edition is a free utility.
When you click on this link, you will have to choose which version to download WEB or full. In the screenshot you can see the difference
downloader
WEB - this version automatically downloads everything you need, but it requires Internet access. For example, if you want to install MySQL on a server without the Internet, then this version will not suit you.
Full version – this version can be installed on a system without internet access. It includes all the necessary data for installation on an offline system.
Before downloading, you will be redirected to a page where you will be asked to log in to your Oracle account or register it, and you can do this, but if there is no time, then click on "No thanks …” After that, the download will begin.