We performed a comparison between MySQL and SQLite based on real PeerSpot user reviews.
Find out in this report how the two Open Source Databases solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.
"One of the most valuable features is MySQL's ability to run our email system. We use a system called Colab."
"However, it is easy to scale MySQL using the functions provided with the product."
"It's a good tool, a good database platform."
"A good traditional database that supports JSON."
"The solution is easy to use."
"The initial setup for the SQL database is not complex and it even integrates into the platform. You set up the recipe and then just follow the runbook, the build book. Then it works as long as you follow the procedures."
"MySQL has cross-platform support for multiple operating systems. The backups on a Linux machine can be restored on a Windows machine, and vice versa."
"It was easy to install."
"The product is lightweight and highly scalable."
"Its performance should be better. When we use big data, it is slow in performance. We should be able to use mirroring for improved performance."
"It should have some code analytical functions. It can also have a monitoring tool."
"We want high availability and replication features, which are currently missing in this solution. It would be great if they can provide an in-built replication feature, similar to Oracle RAC, in MySQL."
"There are some issues with compatibility with Java environments that need to be improved. When Oracle bought this solution there were some driver changes that caused some issues with operations."
"On the database side, it should be really lightweight, and the data structure should be like MongoDB."
"I would like to have features that allow us to jump between the cloud and our on-premises system."
"MySQL could be improved by adding more automation."
"The solution could improve by having better performance and security."
"The performance could be better."
Until its recent acquisition by Oracle, MySQL was possibly the most renowned open source database enterprise package that could be accessed completely for free. With the merger, the server increased both its features and its price tag, but there is still a free version available to the general community to contribute ideas and suggestions.
MySQL is a fast and relatively inexpensive database management system. It can easily integrate with a wide variety of programming languages, and it is considered to be a very reliable option. One of the most prominent features that customers seem to enjoy is the easy scalability of this system.
MySQL is ranked 1st in Open Source Databases with 53 reviews while SQLite is ranked 5th in Open Source Databases with 1 review. MySQL is rated 8.0, while SQLite is rated 9.0. The top reviewer of MySQL writes "Has a simple and user-friendly installation". On the other hand, the top reviewer of SQLite writes "Lightweight, easy to set up, and free to use". MySQL is most compared with Firebird SQL, PostgreSQL, MariaDB, Oracle Database and SQL Server, whereas SQLite is most compared with Firebird SQL, MariaDB, PostgreSQL and Oracle Berkeley DB.
See our list of best Open Source Databases vendors.
We monitor all Open Source Databases reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.