We performed a comparison between MySQL, PostgreSQL, and SQLite based on real PeerSpot user reviews.
Find out what your peers are saying about Oracle, PostgreSQL, Firebird and others in Open Source Databases."It's a mature solution that's been around for decades."
"The most valuable features are that it's free and the documentation is good."
"I like MySQL because of its community."
"The initial setup is easy."
"The way that MySQL has improved my organization is that it comes free and also works fine on the technical side."
"For starters, it's free, which is always nice, and it's also pretty straightforward to use. It's a nice conventional database."
"However, it is easy to scale MySQL using the functions provided with the product."
"MySQL is easy and convenient for me. I don't need to rely on anyone. I can write the code and extract the information. It is fast if you know how to use it. The solution is not expensive, and most of the developers know how to use it. It is easy to create tables. The solution is stable and has good performance. The connection with AWS gives regular updates, which is manual otherwise and a nightmare."
"What I like is that it's quite powerful in terms of performance."
"It's quite scalable."
"It is very simple to manage."
"The most valuable feature is the performance."
"The product is very similar to the SQL Server."
"The community support and the open-source community for it are good."
"It's a transactional database, so we use Postgres for most of our reporting. That's where it's helping."
"Initial setup is simple."
"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."
"SQLite’s most valuable feature is the ability to store granular-level backups of databases."
"I use Flutter Technology with the JSF plugin."
"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 haven't encountered any problems in my use cases. So, it has been a stable product for me."
"Clusters are hard to perform so we use no SQL alternates like MongoDB."
"It would be helpful if there were a graphical user interface to administer, configure, and tune it."
"From a user perspective, the initial setup could be simplified a bit."
"MySQL tutorials and guides could be improved. Often they are too complex for someone with no database experience to understand."
"When I run into issues, I really have to research how to fix them."
"MySQL could be improved by adding more automation."
"The replication needs improvement. It's becoming a native cloud product like Oracle DB or Cockroach DB."
"Stability needs improvement and the backup needs to be enhanced."
"It is possible that in the newer version this has been addressed, but I would like the deployment in microservices architecture could be improved."
"The solution needs to improve the query, documentation, and JSON data functionality."
"I have noticed that user and access management should be improved."
"PostgreSQL could improve by providing a geographical solution for tracking trucks and people in the field. They might already have features similar to this and I have not found them. I haven't done research about this topic."
"The performance of PostgreSQL could improve."
"The solution could improve the integration."
"The price could be better."
"It could be more secure."
"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."
"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."