MySQL reviews

My experience with MySQL

Opmerkingen: Overall, my experience with MySQL has been great. Every developer in my office prefer to use MySQL for the database. I myself have a huge fan of this classic database management system. I even tried using other DBM Systems but I couldn't have anything as easy to use as MySQL. This is why I recommend everyone to use MySQL every time.

Pluspunten:

Without a doubt, every feature MySQL offers is very useful and effective. The database management system that MySQL provides is very important in the field I am in. The developers in my company use MySQL for the data management in backend. Our company itself stores the data of its employees in the database using MySQL. I myself have used MySQL a lot. I completed my final year project in university by developing a website which store all of the user's data in MySQL database. It is very easy use and understand. The way it performs even with huge number of data is also very impressive. Data filtering and monitoring are also fluid and easy to carry out using MySQL.

Minpunten:

MySQL is heavily based on queries or commands and it is quite confusing sometimes. Personally, I have a habit of forgetting small details in the queries and commands which I have to google search later. I would prefer to have a GUI based options to work with MySQL or suggestions with commands. But, that is a personal preference, not all users will forget the queries. Other than that, I don't have any complaints with MySQL as of now.

MySQL: A Popular RDBMS for Teaching Database Concepts

Opmerkingen: Great experience using MySQL for teaching database concepts for undergraduate and graduate students.

Pluspunten:

The main feature that I cherish in MySQL is the ability of my students to deploy it locally without the complexities of intricate configurations and deployment mechanisms. I used MySQL as part of the Bitnami WAMP stack (MariaDB is now packaged in Bitnami) to get a complete server bundle that is easy for students to deploy and configure. Before I relied in my teaching on a networked Oracle installation that was not that performance efficient and didn't give students the chance to configure the server environment. Moreover, with a networked configuration testing various SQL concepts would be a bit complex compared to having a local database installation.

Minpunten:

Changing the open-source license by Oracle was a bit disappointing. MariaDB is a kind of open-source alternative to MySQL with very similar features and architecture.

MySQL the default database server

Opmerkingen: We just use MySQL for all of our databases

Pluspunten:

It's the default standard for many companies. MySQL has grown into a very stable product that never crashes. We've made the move to MariaDB, but found that the tables sometimes get corrupted when restarting a database server under heavy load. With the recent speed improvements to MySQL, we have decided to actually migrate back to MySQL.

Minpunten:

I'd really like if they would spend a bit more time on their CLI interface. As in, syntax highlighting in the CLI, an easier way to scroll through multiline queries when going through the history. I would also like it if we can specify a color scheme to use for the output.

10 Years of MySQL

Opmerkingen: MySQL is a robust and scalable choice for many database-driven projects, offering numerous advantages for both beginners and experienced developers. I appreciated this coming in as a novice and learning overtime how important a functioning database is to a project.

Pluspunten:

MySQL's compatibility with various platforms and extensive support for programming languages contributes to its versatility, making it suitable for diverse applications. Moreover, its extensive online community and detailed documentation make troubleshooting and learning effortless.

Minpunten:

MySQL lacks some advanced performance optimization features found in other database management systems. This limitation may require additional effort to optimize complex queries manually.

There is no better database management system than MySQL.

Opmerkingen: I've used MySQL for a few years, and I'd heartily recommend it. It is a very capable and flexible solution for managing your server-based data.

Pluspunten:

Despite being available for free, MySQL has numerous functionalities that are also present in commercial products like SQL Server.

Minpunten:

The majority of other databases, save for MySQL, offer data transfer between DB and distributed file systems like AWS S3.

Quality review of MYSQL

Pluspunten:

- great security features plus many other wide compatibility- it has great community support

Minpunten:

- certain functions are quite limited & complex- not highly cost effective

Review about mysql

Opmerkingen: We run our pos software database with mysql databases

Pluspunten:

Easy to use and very scalable for our organization

Minpunten:

For now we see everything we need for our operation is present

MySQL is the perfect database management system

Opmerkingen: Using MySQL has been amazing

Pluspunten:

MySQL is amazing to use for accessing and retrieving data! It is very secure and trustworthy.

Minpunten:

The quality of support can be improved with MySQL

Experience on MySQL

Opmerkingen: MySQL is easy-to-use software, and the wide integration options with other software are also outstanding features. Handling large amounts of data and manipulation of data is also very easy.

Pluspunten:

Managing large data sets in MySQL is its most impactful feature. MySQL is easy to use. Integration with other software is also very easy.

Minpunten:

The user interface is little old. Sometimes I face lagging while working. Integration with other software is easy.

The best for database

Pluspunten:

Really very helpful and eazy to use and integration with most of programs i recomend all to learn and use mysql

Minpunten:

Really nice and support tools and faster with command and easly to use thank oracle for that

Stellar platform. A bit of a learning curve when downloading to get the right tools.

Opmerkingen: Compared with 20 years of Microsoft SQL database work, the switch to MySQL was far superior. Code level language . Remote administration is vastly superior to Microsoft SQL.

Pluspunten:

The platform is stable - always working. Documentation is consistent. Updates are coherent and stable. We use it in 95% of all our projects, and it has been a life saver for our bottom line.

Minpunten:

Choosing the right tool to download was confusing. Obviously written by developers instead of management. I'd suggest a 2-4 step process to help in choosing the right packages. The setup process could use a bit more explanation and be more lucid.

Still good after lots of years

Opmerkingen: I've been using MySQL for 12+ years. It was great then and it's great now. Lots of features have been added and query speed has been improved by a lot.
Since it's a software that has been around us for many years, I insist, the backwards compatibility isn't the desired one, all the needed adjustments to datasets generated in old versions (that are still running in production environments) rely on the dba. Would be great if there could be a utility that handles that.

Pluspunten:

I like that it has a community edition which allows to get the software for free with community support. In the case of red hat/CEntOS host, a repository settings can be added and the installation is pretty straightforward. As long as it is correctly setup according to the server resources and expected demand, it runs pretty fast, it is stable and supports lots of connections.

Minpunten:

I feel that it has been starting to loose its backwards compatibility. If you need to use a previous feature, for example, if you want to use the mysql native password, now you need to specify it when creating a user, otherwise, it won't work straightforward with most CMS software. Also, as some datatypes are being improved (which should be a nice to have feature), when migrating to a newer version, restoring a dump can turn into a headache. The users model have also changed, so, if you had a very large users set, you have to do some work to make it work again in newer versions.

The well balanced

Opmerkingen: I use MySQL in many personal projects, like my automated house project. It was a very good choice, I'm happy with this. Also, in the past, I have worked with MySQL and PHP in my company's intranet page. It was a good tool, but as the company grows, we need to migrate to another platform. Also, it is important to say that if you use the correct database engine with MySQL, you can have foreign keys and other types of constraints so it is very flexible.

Pluspunten:

MySQL is a well balanced product, while it is free to use, it also has many features you can find in corporative solutions, like SQL Server and Oracle. If you ever need help, you will find answers almost everywhere, from their own documentation to stackoverflow and other forums, easily. You will have a very short learning curve with MySQL.

Minpunten:

When you need to deal with great amount of data, like some kind of data warehouse structure or huge amount of measures to analyze, you better go other choices. It starts getting too slow with the same hardware other products will work smoothly. But I guess that is not the purpose for MySQL. In the other hand, if you want it to build a transactional system like an e-commerce platform or even a Blog page, it is a very good choice!

MySQL has always been one of the best relational databases

Opmerkingen: Many of our relational databases work nowadays with MySQL, we find it easier to maintain than PostgreSQL or other alternatives, as well as it's knowledge more broadly distributed due to it being very beginner friendly for web projects, joined with PHP usually.

Pluspunten:

First of all there's a free community version, as well as alternative software like MariaDB and Percona Server which have an open-source approach as well. There are multiple services to manage MySQL like Amazon RDS as well as similar products on GCP or Azure, so it's not entirely required to have expert knowledge to use these databases if you are willing to pay for support.

Minpunten:

The upgrade process for MySQL requires downtime and it's not easy to perform a rollback either (on some cases it's entirely impossible unless you restore a backup). Managed services don't provide a zero-downtime upgrade process either, except for migration all your info and deltas into a new database (which sometimes is not entirely available)

Robust and easy to implement

Opmerkingen: Robust, easy to use, fast and reliable. Easy to develop stored procedures and triggers

Pluspunten:

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

Minpunten:

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

A very good option for small software development projects

Opmerkingen: To get started in application development, I highly recommend it for its ease of use and how effective it can be for handling data on a small scale. Of course, MYSQL has to be just a step to later migrate to systems that better manage data on a large scale, such as SQL Server or Oracle.

Pluspunten:

Mysql is a good tool to start in the world of software development. It offers a small but powerful product, with effective database management when it comes to bringing us useful information for the business. With a few command lines we can get all the information we need, and its installation and first use is fast and intuitive.

Minpunten:

Although MYSQL works well for small and medium projects, in large-scale projects we can suffer a bit with information and data management, since this tool is not entirely designed to handle large-volume data. It can handle data in large volume, but the way in which it will do it will not be the most efficient or the most optimal, which can cause a certain lack of speed when deploying our project.

Powerful FOSS RDBMS

Opmerkingen: My experience with MySQL has been positive. I haven't found an application that it wasn't suited for yet. It has allowed us to move the majority of our systems off of Windows servers onsite to the cloud. Additionally it's compatible with ArouraDB which allows us to safe money with non production sites.

Pluspunten:

I've used both Microsoft SQL Server and Oracle and what I liked most about MySQL, aside from my personal preference for it's syntax, is that it runs well on all platforms and is easy to setup and maintain. MSSQL limits you to Windows servers and while Oracle will run on various platforms it is difficult to setup and maintain.

Minpunten:

What I like least about MySQL is that backing up and restoring databases is a pain. You basically have to dump the database to a text file that contains every SQL statement needed to recreate the database. I also feel like the MySQL dataconnector for .NET Core isn't well developed or supported. Also MSSQL and Oracle have more ease of use functions when programming.

I love my MySQL (see what I did there)

Opmerkingen: 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.

Pluspunten:

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.

Minpunten:

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.

Strong and Open Source RDBMS

Opmerkingen: In MySql you create the database first, then the tables, and then you add records to the tables before you can query them, following the traditional structure of the Relational Database Management System.So it is flexible to operate .

Pluspunten:

It is free software and also open-source. It's much faster and lighter than MsSQL. It is extremely easy to use and comprehend. It's easy to set up, use, and run. The structure of the language is remarkably similar to that of English sentences.

Minpunten:

I think some of the error messages are so broad that they cannot accurately describe the issue. Some error messages are more bizarre than the problem itself. At times, it creates a sense of insecurity.

Fast and reliable relational DBMS

Opmerkingen: Overall postiive experience - it just works once configured correctly. Even easier to use AWS RDS / Aurora for managed Mysql Instances.

Pluspunten:

Flexibility and 1st level support from most application servers via JDBC ODBC connectorsMost cloud providers offer Mysql as SaSS or additions to PaSS offerings - so in terms of reducing costs to run mysql instances, these can be placed under op expenditure.

Minpunten:

Standalone product support can get expensive (from Oracle).Database restore for master/slave replication can get complex with bin log files manual adjustments being required to fully sync replication.

Will Developed Relational Database System which supports Transactions

Opmerkingen: Had a great experience with Mysql, since it has been the core of transaction systems

Pluspunten:

Mysql is Transactional, you can commit or revert a set of actions in a transaction, it has well implemented all the Transactional feature such as primary key, foreign keys, indexing etc ... so we mainly use mysql for data collection from realtime interactions with the end user, Its Hibernate support gives a edge on realtime interactions, Mysql provides many type of JDBC/ODBC jars, using which it can be integrated to any type of tools and languages, Mysql has a desktop application called Mysql Workbench for performing all the operations on mysql, it comes in handy if you don't remember some of the commands (like migrations , dumping, updating row etc ..), also it provides schema visualisations, tables and its columns are listed which can be dragged into the editor, which makes the mysql to be easily used and reduces the developers time involved in operational work and improves development efficiency, There are lot of other friendly tools such as WAMP/XAMP etc, which can be used for learning purposes, and Mysql has a huge community support

Minpunten:

Mysql dose not support data transfer between DB and Distributed file system such as AWS S3, which most of the other databases dose, We had to use different PSQL database for large non relational data storage, since it is not the intended purpose of Mysql, so we have to maintain two database systems, it wold be better if mysql can give non transactional support as well for large data storage and analytical use case , so that it can be one stop DBS solution for all data actions.

MySQL - One of the best FREE sql DB

Opmerkingen: 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:
* HeidiSQL
* PhpMyAdmin
* 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.

Pluspunten:

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.

Minpunten:

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.

Scalable software for simple to complex applications

Opmerkingen: I have had a generally good experience with MySQL. The MySQL RDBMS overall is an excellent software platform. I use it for an auction website that I designed. It takes quite a bit of study to learn about things like the column types and proper table structuring but as a layperson (i.e. not a professional programmer) you can learn the software well enough to make proper use of the program.

Pluspunten:

MySQL integrated really well with the PHP scripting language. MySQL is what is called a Relational Database Management System (RDBMS). It is a software system that uses the SQL database query language to manipulate data in a database. MySQL provides for data handling, storing, modifying, and deleting in a tabular format. You can design your database so that each table has a key to at least one other table and that each table can access data in every one of the other tables in the database (hence the word "relational"). With a properly designed MySQL database you won't have any orphaned rows or tables. The database queries that use SELECT, UPDATE, or DELETE are simple and straightforward to use with the PHP scripting language. As an end user, like myself, you don't have to install and maintain this software. The MySQL software comes preinstalled on most server hosting plans meaning the server hosting provider does the installation and maintenance for the software.

Minpunten:

The MySQL reference manual is not clear enough in describing how to utilize many of the features for MySQL. The manual is too technical and apparently is designed for persons with a high level of computer programming or technical knowledge. The manual is sometimes confusing when seeking to find the proper column type to use (i.e. TEXT, CHAR, VARCHAR, etc.). The Date and Time functions for MySQL like DATE and DATETIME are hard to understand and difficult to implement. The table join features are difficult to understand and use.

Feature rich and easy to use database management system

Opmerkingen: My experience with MySQL has been amazing.

Pluspunten:

MySQL is easy to install and configure. You can quickly set it up in no time.

Minpunten:

So far for our usage, we are satisfied with the features.

MySql is reliable and great for big organizations, but tedious for a lone noob programmer.

Opmerkingen: Overall, MySQL is a powerful and reliable database management system, but it may have some limitations when handling unstructured data and maintaining the schema. It offers robust data recovery options but might be cumbersome when compared to newer non-relational databases.

Pluspunten:

I have been using MySQL for several years and I have to say, it has proven to be a reliable and powerful database management system. It offers robust data recoveries options such as binary log and InnoDB crash recovery, which gives me peace of mind knowing my data is safe. The data dictionary feature is also extremely useful, it makes managing the database and optimizing queries a breeze. Overall, I highly recommend MySQL to anyone in need of a solid, open-source database management system.

Minpunten:

I have been using MySQL for some time and I have to say, I find it to be quite cumbersome when compared to newer non-relational databases. One major issue I have encountered is the difficulty in handling large amounts of unstructured data, which is common in many modern applications. Additionally, the rigid schema and the effort required to maintain it can be a big headache, especially in a fast-paced development environment. These issues are typical in traditional RDBMS like MySQL and are less prevalent in Nrdbms