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."MySQL's clustering features are very strong, and you can automate scripting, so that helps. We wrote a Terraform script and ran it."
"The initial setup is easy."
"The one interesting thing about this product is that it is open source. It comes from an open source product. MySQL has been positioned as open source, but it also provides support."
"I am totally satisfied with MySQL."
"The connectivity with PHP is quite good."
"It is easy to use."
"MySQL is an easy-to-use solution that provides stability, reliability, flexibility, performance, security, and high availability."
"The product is flexible and easy to use."
"I haven't encountered any problems in my use cases. So, it has been a stable product for me."
"SQLite’s most valuable feature is the ability to store granular-level backups of databases."
"The product is lightweight and highly scalable."
"It was a bit easy to use compared to other tools. It's simple. I found it pretty easy to execute my SQL queries."
"Sometimes, you want data to persist within the app even when there's no internet connectivity. To avoid showing blank screens, we can use SQLite to store data locally and then sync it with the cloud database when connectivity is restored."
"I use Flutter Technology with the JSF plugin."
"In terms of what I'd like to see in the next release, one thing that's always missing is dash boarding. There's no real BI tool for MySQL, like there is in Yellowfin and all the different tools that you get. They all have MySQL connectors, but there's no specific BI tool for MySQL. These open source projects have sprung up, but they're more general purpose."
"It isn't as reliable as an SQL Server."
"We have encountered some performance issues, and the solution takes time for performing complex queries."
"Some problems with big table operations, and a struggle to keep the servers responding in peak situations."
"MySQL could be improved by adding more automation."
"Sometimes, I get lost in the toggles and buttons, and a better visual design would be nice. The layout is not user-friendly or efficient."
"We require more ease of use, scalability, and high availability. These are some of the critical features that we use and look for in a product. It should be easier to manage clusters. Scalability is very important for us because our projects and concurrency requirements are quite big. We also require high availability of the server, application, and other things. It should also have more performance-based features or enhancements from the performance point of view. When we divide a database, it should be able to handle the queries very fast."
"Could use some additional JSON query support in the solution."
"I primarily use SQLite for small-scale applications due to its limitations in storing large amounts of data. For larger-scale projects, I typically opt for MySQL or other alternatives. Storing a large number of dates in SQLite can significantly impact its performance."
"It could have a user-friendly GUI and better intelligence features."
"The performance could be better."
"There are some difficulties on the server side. When syncing data with databases like SQL Server or Oracle, SQLite requires a kind of double effort."
"A potential drawback is that the database file stored within the application's local storage could be accessible to users."
"Compared to other tools, the performance was less effective than that of Microsoft Access."
MySQL is ranked 1st in Open Source Databases with 142 reviews while SQLite is ranked 8th in Open Source Databases with 8 reviews. MySQL is rated 8.2, while SQLite is rated 7.2. The top reviewer of MySQL writes "Good beginner base but it should have better support for backups". On the other hand, the top reviewer of SQLite writes " Pretty easy to execute my SQL queries but issues while uploading and importing my dataset". MySQL is most compared with Firebird SQL, PostgreSQL, MariaDB, Teradata and Oracle Java DB, whereas SQLite is most compared with Firebird SQL, MariaDB, PostgreSQL, Oracle Berkeley DB and LanceDB. See our MySQL vs. SQLite report.
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.