We performed a comparison between PostgreSQL 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 tool is user-friendly."
"The database has excellent performance."
"It's a useful solution, that can be widely used."
"It's quite scalable."
"This is an open-source solution, operates at a high speed, and supports more than one SQL language."
"PostgreSQL is stable. It's available, stable, and reliable."
"The PostgreSQL database is similar to the SQL Server but has a slightly different technology that has similar resources as well. If the customer has the confidence using SQL Server, they will be fairly comfortable using this solution."
"The most valuable feature is the performance."
"The product is lightweight and highly scalable."
"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."
"I use Flutter Technology with the JSF plugin."
"The pricing could be better."
"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 interface could be much better."
"If it was free to use, it would be the perfect solution."
"The search option is not very good."
"There are some products out there that have a slightly different method of implementation for the SQL language. Some of those are slightly better in some areas, and PostgreSQL is slightly better in some areas. I would probably like to match all of those products together. It is just down to the functionality. For example, Oracle has a number of options within SQL that are outside of what you would class as the SQL standard. PostgreSQL misses some of those, but PostgreSQL does other things that are better than what Oracle does. I would like to merge those two products so that there is a certain amount of functionality in a single product."
"It would be great if the solution offered even more integration capabilities."
"I'm not really able to customize it."
"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."
"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."
"It could have a user-friendly GUI and better intelligence features."
"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."
PostgreSQL is ranked 2nd in Open Source Databases with 120 reviews while SQLite is ranked 9th in Open Source Databases with 7 reviews. PostgreSQL is rated 8.6, while SQLite is rated 7.4. The top reviewer of PostgreSQL writes " A scalable and stable database for transactional purposes". 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". PostgreSQL is most compared with Firebird SQL, EDB Postgres Advanced Server, MySQL, MariaDB and YugabyteDB, whereas SQLite is most compared with Firebird SQL, MariaDB, MySQL, Oracle Berkeley DB and LanceDB.
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.