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."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."
"The low cost and functionality allows us to save money on smaller database projects."
"SQLite’s most valuable feature is the ability to store granular-level backups of databases."
"I use Flutter Technology with the JSF plugin."
"The product is lightweight and highly scalable."
"The system is aging and not keeping up with the performance of new, enhanced database models."
"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."
"It could have a user-friendly GUI and better intelligence features."
"The performance could be better."
"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 5 reviews. EDB Postgres Advanced Server is rated 8.0, while SQLite is rated 7.6. 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 "Helps to access data directly from my local storage or databases". 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.