Databases are relied upon for storing and storing information, and since the beginning of the computer era various methods have been created in storing and recording information, from storing them in the form of text files, to storing them and organizing them in the form of tables. Many of the platforms branch out from these technologies that provide you with database structure services. In the form of a factor, data storage platforms are divided into two parts: the RDBMS, which is a relational data storage system that relies on tables and the linkage between tables, then the NoSQL, which is unique in storing data in a tree form, with each key storing its value - Key - Value. We have an article for you that explains the most important differences between RDBMS and NoSQL. You can read it here.
Away from all this, only the RDBMS consists of dozens of platforms that help you prepare your own database, and the developer may be confused in choosing the optimal platform and how this platform is distinguished from the rest of the platforms, so we decided to provide you with this guide that explains the pros and cons Each platform has its own features.
Database management systems and the differences between them (MySQL / Postgre / MongoDb ...)
MySQL
MySQL is one of the most popular and widely used platforms for managing databases currently, and it is an open source project available to everyone, it is used mostly in the allocation of relational databases on the web (but it can be customized to respond to databases with desktop programs and also mobile applications ). Its most important features:
The most important feature of MySQL is its great support for many programming languages such as: Php, Python, Rails, C # .. This makes the ability to use MySQL great because it is supported by a huge number of programming languages.
MySQL supports a very large set of data logging patterns, not only here we are talking about relational databases, but also data of type CSV for example, or the large volume Blackhole, which gives him the upper hand to store and register databases professionally.
MySQL also supports importing and exporting databases of various categories. So, for example, its support for a CSV storage system can for example import CSV information and convert it to databases tables and relationships as well, and can in turn be exported and sent to other users, and this allows us to change the hosting of the site or Software without losing information.
Powered by a large number of hosts and cPanel platforms like PhpMyAdmin.
MySQL also has some drawbacks, most notably:
That Oracle is still behind the project, unfortunately despite the company claim that MySQL is an open source system, but many do not dare to deal with this principle (especially the companies developed after the Java incident with Google), and the company is very late in providing security updates to the platform, which makes you Most often it is exposed to database problems.
Despite its support for the relational data system or RDBMS, it is still really weak when it comes to the advanced level in it, the simplest example of this is the support of the Foreign Key in its system, which had to be specified by the code and does not exist manually.
Most of the big tech companies are starting to be alienated from MySQL, the reason is directly because Oracle is also starting to fool into any company you see stuffed with money.
Nevertheless, MySQL remains one of the most popular systems to use, and is easy to install and install, and as a simple user it may be your best choice, but as a company or in a large project it is unfortunately avoided.
The MongoDB
The MongoDB is the NoSQL database management system that is completely different from the RDBMS (you can find the difference between NoSQL and the RDBMS from here) and it is considered one of the best modern systems in database management in an easy and smooth way. The MongoDB is a document-oriented database system that relies heavily on the JSON-like afforestation system, with each Parent having a set of Nodes / Child, and each branch has a key and value (Key = Value). The good thing about the MongoDB platform, or in general, the NoSQL system is that it is possible to record any type of data, whatever it is, unlike the RDBMS, which had to specify the type of data entered before entering it. Because MongoDB is a NoSQL database management system, we will talk about the advantages and disadvantages of NoSQL, and start with its advantages:
Flexible and you can save any type of data as mentioned above, whether image, text, numbers, password, video, file and anything, it is enough to just specify the key and give it any type of value.
High performance compared to the RDBMS, in a relational database management system, at a specific stage you will have to rely on the Index and the Primary Keys in order to categorize the data and fetch it quickly, since the databases will fill and the transmissions and reception will become slow, we can We tell you that this command is not present in NoSQL.
It is adjustable and renewable, at a certain moment you may realize that you need a new table, perhaps, or you need to add something new to the database, in the RDBMS you will find that the matter is difficult to achieve, while in NoSQL it is very easy.
This system also has some drawbacks, most notably:
The files are somewhat bulky due to the big data, as we find that each document contains only some tables and data that may be somewhat large in size, which may force you to choose huge hosts to deal with.
It does not support intersection and intersections, simply in the RDBMS you can combine more tables in one query and are called Joints, in the NoSQL you cannot do that.
Dealing with huge queries in NoSQL consumes a lot of computer resources, especially RAM.
In general, NoSQL is now the most widely used and developed system for many reasons, most notably flexibility and scalability.
Author: Carolyn