We performed a comparison between EDB Postgres Advanced 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."The low cost and functionality allows us to save money on smaller database projects."
"It gives us a solid, less expensive alternative to deploying with Oracle."
"I like that EDB Postgres Advanced Server scales well. A valuable feature of the solution is multi-tenancy support. It also supports JSONB."
"I rate EDB Postgres Advanced Server's stability an eight out of ten."
"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."
"The product is lightweight and highly scalable."
"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."
"An area for improvement in EDB Postgres Advanced Server is JSONB querying. It would be nice to have even stronger JSONB support from the solution."
"I have faced performance issues in the community edition."
"The security is not very robust and the product would be much more useful with more security options."
"The system is aging and not keeping up with the performance of new, enhanced database models."
"It could have a user-friendly GUI and better intelligence features."
"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."
"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."
"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."
EDB Postgres Advanced Server is ranked 6th in Open Source Databases with 6 reviews while SQLite is ranked 9th in Open Source Databases with 7 reviews. EDB Postgres Advanced Server is rated 8.0, while SQLite is rated 7.4. The top reviewer of EDB Postgres Advanced Server writes "Scales well; works in both development and production environments and has multi-tenancy and JSONB support". 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". EDB Postgres Advanced Server is most compared with PostgreSQL, Percona Server, MySQL, YugabyteDB and MariaDB, 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.