We performed a comparison between Percona Server and SQLite based on real PeerSpot user reviews.
Find out what your peers are saying about Oracle, PostgreSQL, MariaDB and others in Open Source Databases."We find the product mostly stable."
"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."
"SQLite’s most valuable feature is the ability to store granular-level backups of databases."
"The product is lightweight and highly scalable."
"If Percona had flashback capabilities, it would be ideal."
"A potential drawback is that the database file stored within the application's local storage could be accessible to users."
"The performance could be better."
"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."
"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."
Percona Server is ranked 8th in Open Source Databases with 2 reviews while SQLite is ranked 9th in Open Source Databases with 7 reviews. Percona Server is rated 7.6, while SQLite is rated 7.4. The top reviewer of Percona Server writes "Open-source and free to use with a good community". On the other hand, the top reviewer of SQLite writes "Good for scenarios where you need offline capabilities within your mobile applications, stable and useful plugin". Percona Server is most compared with MariaDB, MySQL, EDB Postgres Advanced Server, PostgreSQL and Oracle MySQL Cloud Service, whereas SQLite is most compared with Firebird SQL, MariaDB, PostgreSQL, MySQL 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.