MySQL
JetwareExternal reviews
1,612 reviews
from
and
External reviews are not included in the AWS star rating for the product.
MySQL
What do you like best about the product?
MySQL is not open source anymore in the spirit of FOSS, but it is still an openly configurable DBMS. Proprietary packages like Oracle are very difficult e learn and they like it that way. Oracle has a practice of their salesmen telling you that you can use it in ways that aren't legal, then after you install and migrate to it they send another crew to tell you that you're in violation of the licensing agreement and pay up or get sued. I've seen this extortion happen many times enough to know that it's intentional.
The MariaDB version of MySQL is what I trust. Maybe more work but less hidden hassles.
The MariaDB version of MySQL is what I trust. Maybe more work but less hidden hassles.
What do you dislike about the product?
It tends to have issues with large databases, i.e. > 100GB, with replication failing for strange reasons and needing to be restarted again. Also, you can get into trouble if you don't design your tables correctly. You can't have 5 years of sales records in a huge table and expect to have a dozen indexed fields without serious delays while writing records. Use the views to aggregate a few monthly tables at a time to view records with, and then write to the current month's table only. You don't want to write to a table that has 100,000 records in it with 20 indexes to update as well.
What problems is the product solving and how is that benefiting you?
MySQL can be used in applications obviously, but it is useful as a standalone tool for big data applications as well. It is faster than PostGreSQL on reads without transactions which makes it ideal for manipulating huge tables of data from the SQL command line.
Recommendations to others considering the product:
Use free software if you can. Proprietary software in general has more headaches for administrators than free software. There is more work involved but there are no hidden feature gaps to make you pay even more than you expected to. Oracle is famous for this.
Easy to use
What do you like best about the product?
Useful to know since it's so popular and very easy to use. There are a lot of helpful tutorials provided to help you to learn. MySQL was taught to me in my college classes and I've used it ever since. It's also open source and free to use which is nice when working on projects. It supports both Windows and Mac and is very fast.
What do you dislike about the product?
It would be nice if there was support for mobile devices.
What problems is the product solving and how is that benefiting you?
Fundamentals of databases final project to create a calorie counting software.
I think we all agree that MySQL is the most popular database in the world
What do you like best about the product?
MySQL is a simple database and it has been very popular over the years. I think its most important factor is the ease with which you can learn the syntax of your queries. Furthermore, I also like the fact that it has extensive documentation, which is constantly updated. In addition, they have an application called Workbench that offers a nice graphical interface and tools to do different tasks to the databases, such as import and export of data, performance reports, and tools to add, remove or remove tables.
What do you dislike about the product?
Sometimes migrating large databases from one server to another can usually be a cumbersome process, since the default server configurations do not support reading large amounts of data and do not have long runtime.
What problems is the product solving and how is that benefiting you?
I have worked with MySQL databases since the beginning of my career and its main advantage is that it is completely open source. Currently I use it in my organization to develop web applications with the Linux, Apache, MySQL and PHP stack.
Recommendations to others considering the product:
Of course I would recommend the use of MySQL for the development of any software. MySQL is the most popular database in the world, so it is constantly being updated and has very well-developed documentation.
Excellent Db Tool for Beginners
What do you like best about the product?
The MySQL is an excellent tool for learning relational database and their concepts.I used this tool in my first project there client needs his customers data manipulate and fetch using MySQL tool. So, i had found MySQL is very appealing and easy to use tool.
What do you dislike about the product?
No, i did not find any dislike about MySQL.
What problems is the product solving and how is that benefiting you?
Fixed database schema related issues.
Recommendations to others considering the product:
Yes, i would like to recommend to beginners this tool.
MySQL is my preferred platform to develop projects with Java or PHP
What do you like best about the product?
MySQL has a very easy and simple graphical user interface. I like it because the functions and commands are not difficult to learn. Also, it has really complete and fast import and export tools. Another favorite feature is that there is a lot of useful documentation in different languages on the web. On the other hand, it works very well on Linux servers, which are the ones we have in the organization.
What do you dislike about the product?
MySQL does not work efficiently with large databases, as servers typically exceed maximum wait times when an import is performed, forcing additional work to be done on its configuration.
What problems is the product solving and how is that benefiting you?
MySQL allows me to create and manage databases of mobile application projects that are under development. The most important thing is that we can host our SQL servers for free. On the other hand, its data import and export functions work quickly, saving us time.
Recommendations to others considering the product:
I use this software frequently in the development of my projects. It is an open source solution with really efficient features and easy to use. It is possible to integrate it with programs like XAMPP. I recommend it.
Most light weight database.
What do you like best about the product?
Light weight, takes less space, can be used for any application, with new workbench it's even easier to use even for a person with limited knowledge of DB. you don't have to remember all the queries now because of that.It makes our life easier for taking data dump or execute data migration projects.
What do you dislike about the product?
doesn't have inbuilt integration tool where as few other DB support that.
What problems is the product solving and how is that benefiting you?
We use MYSQL for our internal database, also use it as a data store to upload data for data migration projects. as it's light weight it takes less space in our server. We maintain our entire user details in mysql along with that our entire Database schema is designed on mysql. you can completely restructure your query in mysql.
As you optimize problematic queries, your goal should be to find alternative ways to get the result you want—but that doesn’t necessarily mean getting the same result set back from MySQL. You can sometimes transform queries into equivalent forms and get better performance. However, you should also think about rewriting the query to retrieve different results, if that provides an efficiency benefit. You may be able to ultimately do the same work by changing the application code as well as the query. In this section, we explain techniques that can help you restructure a wide range of queries and show you when to use each technique.
As you optimize problematic queries, your goal should be to find alternative ways to get the result you want—but that doesn’t necessarily mean getting the same result set back from MySQL. You can sometimes transform queries into equivalent forms and get better performance. However, you should also think about rewriting the query to retrieve different results, if that provides an efficiency benefit. You may be able to ultimately do the same work by changing the application code as well as the query. In this section, we explain techniques that can help you restructure a wide range of queries and show you when to use each technique.
Recommendations to others considering the product:
I definitely recommend to use mysql if your organization is mid size or under small category. However, MYSQL can handle heavy duty operation like any other Database in the market in your day to day operation.
Very good relational database
What do you like best about the product?
Mostly used relational database in applications. It is super flexible database I have ever used. It is easy to setup and work on it. Most of the queries I have ever used are supported by mysql
What do you dislike about the product?
built in data manipulation is not available, need to use other tools for it
What problems is the product solving and how is that benefiting you?
Using it for my applications to run database server and data warehouse.
Good for quick testing
What do you like best about the product?
Simple, common, stable platform. Free community version. Easy to stay very 'vanilla'.
What do you dislike about the product?
Not the best UI for development. Need to integrate thrid-party for easier development outside of command-line SQL.
What problems is the product solving and how is that benefiting you?
Basic SQL databases behind PoC's, testing integration with NoSQL and other AI software.
Great to use for data management
What do you like best about the product?
Easy to use the database with a lot of quick management. It’s a great site to use in that it has a lot of great features in managing the data. My favorite feature is sorting and transforming data into another quantitative site.
What do you dislike about the product?
It can be instable at times. Also the licensing is a bit hard to get verify sometimes. It’s somewhat high in price but worth it if you have a larger company and need a huge database. Also, you can share the licensing on other desktops.
What problems is the product solving and how is that benefiting you?
I’ve been able to manage data efficiently and faster. It’s helped my workflow be more smoother. Also, I’ve been able to take on more tasks and conduct higher quality reviews. It’s made me life easier and bosses happier.
Recommendations to others considering the product:
Try it and you can get rid of it if you don’t like it. There are many features that we don’t use so it isn’t as useful but there might be something you need.
MySQL database is the best database to work with open source solutions
What do you like best about the product?
MySQL is best database to work with open source solutions. We are easily able to setup MySQL for our PHP and python based websites. Making connection to MySQL is very easy.
What do you dislike about the product?
MySQL is fast and robust database. It uses a number of modules to connect with PHP and manage the database content.
What problems is the product solving and how is that benefiting you?
MySQL is mainly used with the custom based PHP and python websites in our company. We develop websites for the clients and design DB schema using MySQL.
Recommendations to others considering the product:
MySQL is good for open source projects.
showing 251 - 260