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."It is a scalable solution."
"The solution is free to use, which is its most valuable aspect."
"My main reason for using MySQL for this small customer database company and for some kinds of scientific projects was that I had to do the installation myself. I didn't have a database administration team behind me. Therefore, I was looking for something very easy to handle. MySQL is easy to install, connect, and do all such things."
"The most valuable feature of MySQL is its reliability and performance."
"I like the JSON stuff."
"While MySQL offers strong basic functionality."
"It's a mature solution that's been around for decades."
"We use it as a data store and from that perspective, we get everything we need."
"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."
"SQLite’s most valuable feature is the ability to store granular-level backups of databases."
"I haven't encountered any problems in my use cases. So, it has been a stable product for me."
"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."
"I use Flutter Technology with the JSF plugin."
"At times, the autoscaling does not happen when there is a surge in load."
"The interface could be improved."
"MySQL could be improved by adding more automation."
"Scalability could be improved."
"The tool needs to improve table visualization."
"If the customer is already using or has already used Oracle for a long time they will know the look and feel and the character of this database that can fit into their business."
"The replication needs improvement. It's becoming a native cloud product like Oracle DB or Cockroach DB."
"The performance, stability, and security are areas with shortcomings in MySQL, where improvements are required."
"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."
"The performance could be better."
"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."
"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."
"It could have a user-friendly GUI and better intelligence features."
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.