Reviewed on 30/10/2019
MySQL is hands down the best free database software
Comments: Overall, MySQL isn't always the right choice, but for startup applications and smaller projects, it's the best. Over time you have to learn when to use certain database software, but as a general rule of thumb, MySQL absolutely can handle anything with some configuration and the price is incredible (free). Personally, I've done research on JSON based databases and they lack structure and make things a pain in the long run, which is why I'm only mentioning MySQL and SQL Server in this review. There are other similar acceptable alternatives such as postgres but I've never had reason to use them over MySQL.
- If you structure your database correctly, it's very stable
- It's free, and there are MySQL derivatives (MariaDB) that are even more powerful
- The xtradb database engine in MariaDB (a derivative of MySQL) is incredibly fast
- You can do things quickly and have some data integrity risks on small projects, or you can do things properly and have virtually no risk on mission critical applications
- VERY easy to scale and setup database clusters and replication, especially in all of the cloud providers
- The barrier for entry is too low, causing MySQL and MariaDB to get a bad rep because inexperienced users take advantage of its simplicity
- Performance isn't on par with MSSQL/SQL Server without a ton of configuring
Reviewed on 28/10/2019
Robust and easy to implement
Comments: Robust, easy to use, fast and reliable. Easy to develop stored procedures and triggers
Pros: One of the best features of MySQL is that it's easy to configure and start using. I found less of connectivity issues as compared to sql sever or Oracle. Also its platform independent
Cons: Terms used for components and features like schema and database is different than what is used in other dbms. If someone is new and migrating from SQL server or Oracle to this software, they will find the nomenclature a little confusing
Reviewed on 04/10/2019
Comments: We resolved over DBMS issues with MySQL. It is free therefore We resolved our cost issues. It has the best community. We resolved our all issues very easily. Queries are very easy, Therefore we saved over time. If we think to use relational database MySQL is the best. We can recommend for anyone. Drivers are there for any programming language.
Pros: MySQL is a powerful database management system. It is free. Easy to learn and use. I someone new to DBMS. We can recommend that person to MySQL without any trouble. It is supported to any environment. If your server/PC windows, Linux or Mac. It doesn't matter. MySQL support for all Operation systems and very easy to set up in any environment. We can tall like this if we think about the setup and configuration process "MySQL is the most easiest DBMS system to set up and configure". We can create databases and tables very easily. As well as It is a relational database. We can keep up table relations. It supports many data types. Int, Double, Flote, Varchar, Text, Date,Timestamp...etc.We can create table, views,functions,procedure,trigger..etc. It support many character sets. We vey easy to take backups. We can use text files, CSV file, excel files to data upload. bulk data upload support. MySQL queries are very easy. It supports joins, subqueries,union,group,order and so many things are there. Many free client applications are there for MySQL like MySQL workbench, sqlyog, phpadmin. We can run mysql in custom port. We can limit privileges by user roles. Best thing is support. And also MySQl drivers are there for any programming language. If It is Java, PHP, Node...etc doesn't matter. There are many resources for MySQL. MySQL is a world most popular, powerful, easy, wonderful DBMS.
Cons: Actually, It is a relational database. Therefore before the database creation, You want to create ER-Diagram otherwise you are in trouble. When the relationships are increasing. Hard to insert data. As well as. MySQL is not good for large databases. If relations go very hight. data retrieving speed is going down. If table storage is hight, data retrieving speed is going down. If connections are going hights. It returns too many connection errors and MySQL down. We want to restart.
Reviewed on 25/08/2019
Stable Database for Every Project
Pros: I came from programming background who used PHP as primary language and naturally MySQL was the database for the backend. One feature about MySQL is how easy it is to setup and use and how flexible it is to operate. I have used both the CLI (Command Line Interface) and GUI (Graphical User Interface) to interact with the database to create tables, add records, update and remove records, all seem really fast and stable. I used MySQL on my Windows, Mac, and Linux machines without any hiccups. It follows the traditional Relational Database Management System structure with you first create the database, then the tables, then add records to the tables before you can query them. The client used to interface MySQL include the web-based tool like PHPMySQL, and Windows tool like HeidiSQL or MySQL Workbench. These tools all connect to the database very easily. These tools also lets you backup your database for offline storage.
Cons: The recent trend of database has gone from the traditional Relational model to NoSQL, which is a SQL platform that uses mostly JSON format to store data instead of the traditional database tables and records. This is where MySQL lacks, MySQL doesn't have the ability to run as NoSQL so if you intend to use a NoSQL database, MySQL is not for you. One other thing I noticed about MySQL database is if you have a large collection of data and IF your SQL query is not very optimized, the speed to return the data set can be very very slow. Of course, the only way to fix it is optimize or change your query.
Reviewed on 31/07/2019
A thought on MySQL
Comments: As currently I have developed inventory system, clinic system, an backend application for a private company to manage huge no of memberships and ads, and a UK company for manage Business Name , Limited company, trademark and domain registrations and renewals. All of these used with mysql its those are running smoothly. Never had any headaches as through sql queries can manipulate easily and had fast responses for even complex queries and for huge no of data Frameworks used are spring boot and laravel.
Pros: Known and used by most people as most secure and reliable relational database management system. Accompanies 99.99% uptime. Nothing to fears as open source. Can have millions of helps through community. Offers a wide scope of high accessibility like cluster servers master slave replication. Provides high performance even for large volume projects. Growing and improving frequently. Best for cloud applications and big data applications. Supports by huge no of frameworks.
Cons: Red Hat Enterprise Linux, openSUSE, Fedora, Slackware Linux etc moved to MariaDB.
Reviewed on 18/07/2019
MySQL, a Great Free Database Option
Comments: I created a custom database from scratch that tracks inventory assets for the company of which I am currently employed. I also created a couple others that track IT tasks and admin activities.
Pros: Easy to use, syntax is easy to remember, database structure can be built quickly and there is a plethora of tools available to help
Cons: Syntax took some learning, syntax errors sometimes unclear as to what the error actually is. Not a problem if using Workbench
Reviewed on 21/02/2019
MySQL - One of the best FREE sql DB
I believe your experience with MySQL will vary based on the option(s) you choose to interact with it. As mentioned before, you can use the CLI which is used mainly by power users; however, the average Joe can simply use a open source GUI which will make life a whole lot easier. Just to name a few of the FREE GUI software on the web:
* SQL Workbench All are excellent options to make the user experience absolutely the best.
Ever since I began using the software, I felt this bond with the ease of use, ease to remember commands and a large community support backed by tons of online documentations and tutorials. I would say this is one of my best experience using any software and would highly recommend for beginners and power users.
Currently we have many different types of DB on the market (No SQL and SQL). I spent the past 3 years working with MySQL and completely feel in love with the many of its' feature.
* Once you become familiar with the features and the commands, you will find it is super easy and flexible to operate. I interact with it via both the CLI (Command Line Interface) and GUI (Graphical User Interface) and just love the experience.
* It has some easy to use commands that are human readable.
* Ton loads of useful documentations on the web.
* It is an amazing open source RDBMS (Relational Database Management System).
* It can be found bundled with many current software stack (LAMP, MAMP, XAMPP) etc., just to name a few.
* You can create and cutomize databases, tables, routines, procedures which will all make the workflow super easy to manage your data with many advance tools available at your disposal.
* There is the CRUD (Create, Read, Update and Delete) features that are simple to learn and master in your everyday workflow.
Cons: Looking at the NoSQL DB (MongoDB) which uses a document type format to save data in their DB, I would say one of the feature I believe is missing or could be improved, is the way data is stored. What I mean, is that currently in MySQL, if the field is not created, you can't insert data as it will not automatically create necessary fields, while with MongoDB, if the particular field has not been created before data was inserted, it will be done on the fly while uploading or inserting data.
Reviewed on 07/12/2018
lightweight but reliable and effective.
Comments: MYSQL saved my company money on longtime basic and have also resulted in faster processing time from database call and query while its ability to work well with third-party interface application meant that I do not have to work from command prompt screen.
I used MySQL in a project that was covered under the GPL license thus it was free. This helped My company save a lot of expenses compared to when we were using another DB software.
My adaptation to MYSQL was quick based on my previous use and knowledge of MSSQL which have similar Coding structure and many parallel functions.
MYSQL, been open sourced means that there are tons of thousands of supports and help is available on the internet. I have found this to be particularly very helpful in sorting out otherwise difficult situations.
Reliability of MYSQL is the reason MYSQL is the most used database client and I cannot agree less! Been a witness to its reliability, I can say that MYSQL does what it was designed for effectively…and to think it is always been improved upon.
I have used MYSQL with Apache/Tomcat JAVA, Perl. , PHP and JSP and it Worked seamlessly with them. I have observed that MYSQL works best for me when called from Spring Web Flow either through a Hibernate layer or JDBC though.
MYSQL is flexible, easy to install because of its lightweight and can scale to very heavy DB without the need for additional support. So far, there has not been a need to change to a new database management application for us. The only downside I have noticed is on query time speed. for instance, a query that use to call for 0.18 seconds now does 0.23 seconds due to DB expansion over the period of 1 year which is still acceptable.
The need for technical support is overwhelming even though you will most likely find help on the internet.
It is difficult to get your actual database performance base on your system specs adaptation like memory utilization and usage during different calls.
There is a shocking lack of documentation for many functions embedded within the program and I had to resort to the internet to uncover their uses.
You are going to have to learn MYSQL irrespective of your previous knowledge of query languages. This can be more difficult if you are totally new to structural languages and querying tables.
The fact that MySQL does not support ARRAY data types means it cannot be adapted to certain situations and projects. I advise you get detailed need analysis before jumping on MYSQL to avoid data type mismatch and project regrets.
Reviewed on 23/10/2018
Outstanding Database System
Comments: I have been using MySQL for years now to design and deploy dynamic websites and online software. It is one of the easiest and best database systems I have used. It does have a few quirks and things that can get a little frustrating from time to time, but all in all it is an amazing system and I don't hesitate to recommend it to anyone. Because it is free there really isn't a lot of direct support for it. That said there is a huge community of users and it is normally very easy to find an answer to question or get help when you need it. This is truly one of the best database systems you can use.
- First off it is free and open source
- Excellent scale-able database system
- Works perfectly with Linux or Unix servers
- When paired with PHP MyAdmin you can easily work inside your databases from anywhere
- Excellent storage capacity and retrieval
- Can easily store millions of records without issue
- Did I mention it is FREE!
- Unless you want to be working in a command prompt you need to install 3rd party software like PHP MyAdmin to administrate the database; that said most hosting companies install these by default for you already.
- Some built-in functions to MySQL actually slow down queries to a crawl and ignore your indexes; for example using the DATE() on a datetime column ignores any index in that column.
- Not as robust as Oracle or SQL for large datasets; it will work but it does slow down performance as your data pool grows. Normally this does not happen until you get well into the millions of records and even then there are things you can do to speed up performance but it is worth noting it is not as fast out of the box as other enterprise systems.
Reviewed on 25/06/2018
MySQL is a super database program and it's free!
Comments: First, I pay nothing for this software, its open source and freely downloadable on as many computers as you want. Second, it is reliable. Backups are a breeze with mysqldump statements, and restores are just as easy and quick. Third, it is very fast. Do yourself a favor. Take the time to learn this database software. You won't regret it.
Pros: When I first started keeping a customer database, I started with MS Access because it seemed the fastest and easiest option and I had MS Office already. Then I discovered the Linux operating system and decided I wanted to use open source software whenever possible. And the first program I found was MySQL. I converted my ACCESS database over to MySQL and haven't looked back since. This was in 1998. Soon thereafter I found that I could write PHP web pages to display my customer database records in a lot of neat ways, so I learned to how to write PHP pages. I've been using MySQL and PHP pages ever since. MySQL is fast, it has all the features you want, and don't worry about number of records in your databases it will handle all you need.
Cons: I was familiar with the linux terminal when I started using MySQL so that wasn't completely foreign to me. Of course I quickly realized database language is completely different, so I had to start learning select statement, insert delete etc. But since there weren't many complicated things I needed to do (mostly just select statements insert delete update statements) it didn't take me long to be able use the MySQL cli. Although there are GUI tools for MySQL, I never really spent much time on them, other than phpMySQL, which is a great tool for MySQL. The downside of MySQL is you have to learn its language. And that takes time. But then again that's the beauty of MySQL.
Reviewed on 16/04/2018
Excellent database management system
Carlos aogusto M.
Comments: I am a developer of systems under web environment, and in many opportunities I use the MySQL database manager, it is a fundamental tool in my team for a long time.
Pros: MySQL is open source software that allows anyone to use it and modify it. Anyone can download the MySQL source code and use it without paying. Anyone interested can study the source code and adjust it to their needs. MySQl is a relational, multi-threaded and multi-user database system with more than six million installations and is widely used in web applications, such as Drupal or phpBB, on platforms (Linux / Windows-Apache-MySQL-PHP / Perl / Python) Its popularity as a web application is mostly related to PHP, which usually appears in combination with MySQL. This database manager is one of the best in terms of performance since the speed of opreciones is very good. You can be executed in low-resource machines since the consumption of requirements for its execution is very low. It supports several opertative systems and is very easy to install and configure. There are a number of good quality software tools that provide management and development workspace functions. MySQL Workbench and TOAD for MySQL are good examples. Being open source there is a large amount of help on the Internet and this should help to reduce, in a production environment, incident handling times. Also, a lot of information so that your development team can read.
A large percentage of MySQL utilities are not documented.
The support for triggers is basic so there are certain limitations in what can be done with them.
By handling referential integrity with non-transactional MyISAM tables.
It does not treat them differently from the rest of the fields. Privileges for a table are not automatically deleted when a table is deleted. A REVOKE command must be explicitly used to remove privileges from a table.
Reviewed on 23/11/2016
I started in Access/Excel, then MSSQL. Now: The only DB system we use is MySQL
Comments: A couple lifetimes ago I worked with Lotus1*2*3. In my next life I eventually settled on Microsoft Excel and Microsoft Access for data storage and manipulation. I maintained the necessary tech memberships to allow access to all forms of Microsoft software, and built example systems for existing clients in both Microsoft SQL and MySQL. Hands down the MySQL based systems have always won the client vote, sometimes simply for the pricetag and sometimes for the simple open-source power of the community of available implementations. MySQL can work faster and it can work more securely. I have had a few clients who have preferred PostreSQL (because they were already married to it) and we've written a few applications for it. We've also modified many legacy Microsoft SQL applications. Usually, however, we're called in to migrate from MSSQL to MySQL any time a company actually performs any form of study to determine what's best moving forward. The criteria is simple: If the change is due to an internal or external check to find what their best answer is: The answer is always "MySQL". If, however, the solution was determined by "someone got ahold of the boss/owner/CEO and a unilateral decision was made without any other input", then the solution installed was two things: Expensive and short-lived. No joke. This applies to any software that requires data storage that we've dealt with in that last 10 years (IE: "This" lifetime). From CRM to Telephony and Web. I gave up my TechNet subscription over 6 years ago because no client had chosen a Microsoft solution for Server-side operations in three years.
Pros: Cost. Reliability. Ease of installation. Power.
Cons: While I have had some complaints about error locating in the MySQL code we write, I understand that the underlying technology would be degraded by more checks and balances within the system. Plus: This concept applies equally to every version of SQL we use (Postgre and MSSQL included).
Reviewed on 14/01/2018
Best open source relational database for beginners and experienced professionals
Comments: I are working on a recruitment drive management software. I use MySQL database to store all my dynamic application data like user, college, company, recruitment drive, student etc. MySQL provides easy to use interface to make db queries to read, update, create and deletion of data. I got benefit using MySQL in terms of reliability, speed, easy to use interface, simple query syntax and support of joins. MySQL provides easy to understand documentation to understand its insights to get the full benefit from it. I recommend MySQL to all entry level and experienced developers, administrators and engineers. It support all types of basic and enterprise level needs of storing relational data. MySQL is easily adaptable with all programming languages.
Pros: MySQL is the simple, fast, popular open source and freely available database for software developer. MySQL provides adapter to integration to almost all types of programming languages. MySQL query syntax is easier to learn compared to all other database management software. It also support highly complex and advanced SQL queries. It is being maintained by Oracle. MySQL has good documentation. MySQL provides a tool called Workbench to write queries and look in the table data. MySQL provides the indexing and hashing for faster reading of data.
Cons: MySQL doesn't support complex data types like: JSON and ARRAY. MySQL does not support SQL check constraints that is used to validate data stored in a column. MySQL doesn't support common table expression. MySQL doesn't support full outer joins. It is costly to increase connections limit in MySQL.
Reviewed on 19/04/2018
Excellent relational database manager
Comments: As it's extremely easy to use, iv'e had no reason to change over to another database manager. However in theory it is scalable up to 8 TB, MySQL can not work efficiently with large database which is becoming a growing concern for me as my companies data is growing substantially.
Pros: iv'e been developing for a few years now and using MySQL has made my programming an absolute breeze. MySQL is designed to focus on big data, especially for web development I originally used Microsoft SQL Server but chose to use MySQL instead which provides a great opportunity for a platform that is easy to integrate., is easily scaleable and has great data integrity. As i use MySQL for my company, we now have over 300 various active tables processing our data on a daily basis. Plugging into my IDE's for web development is extremely easy and reliable to work with. Because of its popularity over the years, there are solutions to nearly everything in MySQL. The amount of online learning material makes this a simple investment for anyone looking to utilize databases in their projects MySQL is a great place to start for companies that don't foresee using relational databases.
Cons: Porting a MySQL application to Microsoft SQL Server, or to a competing SQL database engine, requires a significant amount work. as MYSQL is not backward compatible. Although in theory it is scalable up to 8 TB, MySQL can not work efficiently with large database.
Reviewed on 22/08/2019
I love my MySQL (see what I did there)
Comments: I thoroughly enjoy working with MySQL and will continue to do so for the foreseeable future. For linux hosting environments there is no other database tool of choice for me.
Pros: I enjoy MySQL as a web-based SQL database tool. In particular, it's comparability with PHP makes it a formidable tool when creating hosted web applications. I myself have used MySQL to create MANY web based databases for web applications, websites and CMS powered websites alike. Very few downsides to using MySQL and it's basically globally accepted by the Web Development community.
Cons: Very few things. If I had to pick something I would say that the PHPMyAdmin user interface for MySQL databases could definitely use an update. To be honest though, I'm not even sure if PHPMyAdmin is a part of MySQL or cPanel itself so take this criticism with a grain of salt.
Reviewed on 07/07/2018
MySQL is very fast and powerful for small and medium projects
Comments: I have had many benefits of Mysql, my first mysql for professional use, I have installed many systems using Mysql from content managers to web applications made to measure, I have grown with mysql for many years using it both to work in companies and for particular jobs for companies. clients I have won the congratulations of my bosses as well as promotions and congratulations from my client for certain jobs
Pros: Mysql has been my favorite database since I started programming, it's easy to install, it's simple to find an application that connects to the database and do the administration in graphical mode, many content managers and e-commerce stores use mysql by default and has helped me carry out several projects, I like that most hosting providers have MySQL support at no additional cost. It is free this is important to reduce the costs in the projects. Mysql is certainly fast and light, the installation requirements are minimal and with few resources, I have used it in Windows and Linux without any problem in both, but the host operating system has never been a limitation and I use it in a Linux environment every time it's possible. Something I like a lot is the documentation that there is of all kinds, which helps the administration and the development of new applications.
Cons: I think that mysql needs to improve in terms of the variety of data types in other databases. I find more complex types of data that are sometimes necessary, another point that should be improved is the power of the procedures that I consider limited compared to those of others. Other brands. Since Oracle bought mysql, the community is not sure about the future of this software, so it has created mistrust in me and I do not like this.
Reviewed on 15/09/2019
A Great Database for an organisation's need.
Comments: My overall experience with MySQL is very positive and owing to the high performance and low operational cost, I would love to work on MySQL again.
Pros: The best thing about MySQL is that it is Open Source. The total cost of ownership in a production environment is very low and performance wise, it is very high performance database. Also, the support for MySQL over the internet is vast and very helpful.
Cons: The thing I like the least about MySQL is it requires a steep learning curve and one must be familiar with SQL concepts in order to use it efficiently. Also, for complex business logic, it tends to get very hard to handle.
Reviewed on 20/04/2019
The standard for most web projects
Pros: This is the standard for most applications online. MySQL is a powerful and professional RDBMS that has almost anything you can expect. At data level, you have: partitioning, text indexing, geo data type (you can search items near a location), and even NoSQL if you need so. Talking about systems, you can set up Master-Slave systems to improve read availability or even Master-Master for high availability. You can build more robust (but complex) systems with clusters too. MySQL has two models: propietary one and Open Source (‘Community’ version). The fact that this is Open Source has made it the most used RDBMS in the Internet, and the most compatible at tools level (you will find plenty of tools to manage your server via GUI, and probably the development tools you are using already work with MySQL).
Cons: MySQL is mostly centered around the server. Oracle (the owner of the product) only have two or three very simple management tools (plus the CLI tool), clearly surpassed by lots of tools (both free and commercial). It means there are no official extra products around the RDBMS, like Forms, Reporting tools or so; if you need them , you will have to look for 3rd party products.
Reviewed on 29/10/2019
Comments: Overall it is a good open source DBMS database for beginners to try out and learn the concepts.
Pros: MySql is the Open source Database and anyone can use it without any licence cost. Queries are very simple and common to other RDBMS database. MqSQL Drivers(API) are available for all the Programming languages which makes easy to connect database from the code. This is platform independent and can be installed in any OS(Windows, Linux ). We can create procedures, triggers easily with MYSQl and the data back up can be handled softly. It supports CSV, Excel and Plain Text files for Uploading.
Cons: If the table has relatively more data count, the performance for query retrieval is slow. when you have too many open connections, database will go down and you will see the connection errors.
Reviewed on 06/07/2018
An Opensource Necessity for Any PHP Website
P christopher B.
Comments: While there is a large learning curve, MySQL is a powerful tool that allows you to manipulate data easily with simple SQL statements.
Pros: MySQL first and foremost is an opensource database management system. That in and of itself makes it extremely valuable as it is already free. Essentially, MySQL allows you to create different databases. Within these databases, you can have any number of tables. These tables can hold all kinds of information. From unique ids to integers to strings, almost any kind of data can be stored in their database system. It runs based on the SQL language which makes sorting data a breeze and search functions are brilliant once you learn the language. I often use MySQL in relation to PHP websites, and it is integrated seamlessly. Pulling data from a database, adding to it, and updating information is very simple using this program. It's a very powerful tool with a lot of features. Furthermore, it also is easy to install on almost any website as long as you have ftp access.
Cons: MySQL is not easy to use. While there are a ton of different features, you need to know what you are doing. It is a large learning curve and can take a lot of time for users to get a hang of it. Once the learning curve is breached, it becomes quite a bit easier, Breaching that learning curve is tough, however. Furthermore, MySQL runs slow on large tables. While this is understandable, updates could be made to increase the speed of the program.
Reviewed on 24/08/2019
Powerful free database software
Comments: The MySQL is mainly used as a backend for content management systems aka CMS. I can easily manage MySQL database and the corresponding tables using the web-based tool. Moreover, the creation of databases and tables are easy.
Pros: The big advantage of MySQL is that the database is available free of cost. The MYSQL can be used with web-based content management systems such as WordPress, Drupal, Joomla, and others. Actually, the amount of software that employs MYSQL is higher than any other database package. As a blogger, I work with WordPress and I found it convenient to use MYSQL. I need not have to learn the database commands since most of the work is done in the background. I just need to open PHYMYAdmin to work with the tables and run commands. If you would like to manage ySQL databases, then you can make use of third-party sofrtware tools.
Cons: The MySQL is not fully compatible with Windows servers. I had faced several errors while working with WordPress and other tools using Windows servers. I have concerns about the security of the MySQL database but it can be rectified by adopting stronger passwords.
Reviewed on 02/08/2019
Comments: We have a financial application and the database used is mysql, we have many simultaneous requests
Pros: Main database, with numerous configuration possibilities, from login type, to different backups and exportation;
Cons: Simple tasks such as INSERT, SELECT, UPDATE, and DELETE are easy to understand, but replication and other tasks require a little more dedication.
Reviewed on 10/08/2018
My mysql Experience
Comments: If u have a small size and medium size business, with data that does not require a lot of security use Mysql for sure and by far the best option
Pros: Simply amazing, the response speed of the query both in the bath and in the phpyadmin interface. The low cost of the resources required makes it suitable for applications and programs of small to medium size which makes it really functional, personally in my previous work and by company policies that only required open source applications and Free, mysql me It was the perfect answer because it had everything, speed, optimization, performance, easy to install and manage
Cons: As an administrator I have always tried to achieve the standardization of all my systems, both in codification and in the behavior of the databases and in mysql I have found many failures that even with (more than 15 years in the market), errors are found without the proper documentation, errors that even the community of oracle and mysql have not been able to solve, to the nomenclature of the errors is very generic and a single error code can refer to several different errors
Reviewed on 16/05/2019
The de facto standard for relational databases
Comments: MySQL has made it possible to set up and rapidly deploy small-scale applications which require a relational database. If effectively managed, it can be applied to large-scale applications as well.
Pros: MySQL is the DBMS you go to for any of your relational database needs; it sets the standard for how a relational database should behave and provides a lot of advanced features as well. With the recent improvements such as adding the JSON data type it can act as a hybrid between relational and document-based databases as well.
Cons: MySQL can be a pain to scale, and suffers from some complex configuration issues.
Reviewed on 22/08/2018
Comments: My experience using mysql has been satisfactory, for 5 years I used it together with joomla for the administration of a web page.
- It is one of the most downloaded worldwide, it is easy to use with graphic tools such as Phpmyadmin for example.
- It is very linked to web programming, so, content managers such as Joomla or Drupal place it as their first option, within the technical requirements, the latest versions indicate that they should use the
version of mysql 5.5.3. - I recommend working with mysql when you are studying or starting in the world of programming to practice the sql language. - It allows to work with relational databases, personally I have not worked with large volumes of data so I can not say that it handles them without problems, however with a web page that stored multimedia
material developed in Joomla I was very good. - Mysql can be used in any operating system, I relate it directly to windows since it is very easy to install in the famous packages that include php + mysql + apache. - Various adaptations or forks have been generated from mysql, such as MariaDB - In general, it has all the advantages of a database manager, robust, simple, flexible
Cons: - I have read that it does not have a lot of documentation, however, I think that it should be searched better, since the forums are the best allies. - Personally a cons, is that it has been purchased by Oracle. - MySql has double licensing