We performed a comparison between PostgreSQL and SQLite based on real PeerSpot user reviews.
Find out in this report how the two Open Source Databases solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."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."
"PostgreSQL is very powerful, easy to manage, and has many features."
"What I like is that it's quite powerful in terms of performance."
"We managed to reduce the storage space needed to 10% of the original size, without affecting data integrity, and we significantly improved the performance."
"The community support and the open-source community for it are good."
"Clustering will be the number 1 feature. It is also open-source so it is free. It can also be clustered, to allow fault tolerance."
"The solution is open-source and free to use."
"This is an open-source solution, operates at a high speed, and supports more than one SQL language."
"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."
"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 user interface could be a bit better."
"When you get a large number of records in a database and start doing various queries, it can adversely impact the performance of the live running systems. That's an area we continue to look at and mean to improve, but it is not only because of PostgreSQL. It is also because of the way the schemas are put together, and certain events are triggered. So, it is because of both parties."
"They need to improve the user experience of the management."
"The search option is not very good."
"PostgreSQL doesn't have a feature for temporal SQL, which is useful for gathering versions of data. This feature should be included in PostgreSQL. This feature is available in MariaDB, SQL Server, Oracle Database, and DB2."
"A better graphic user-interface would be nice to see."
"The user interface for the clients could be easier to use as they are small businesses. From a technical support perspective, the documentation could be improved."
"I find it difficult to get connectors on the tool. For example, .NET has only one free provider in PostgreSQL. I need to pay the provider if I need something more sophisticated features. Other languages like PHP and Java have good community support. We need community support for .NET."
"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."
"A potential drawback is that the database file stored within the application's local storage could be accessible to users."
"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."
"Compared to other tools, the performance was less effective than that of Microsoft Access."
"The performance could be better."
PostgreSQL is ranked 2nd in Open Source Databases with 123 reviews while SQLite is ranked 9th in Open Source Databases with 8 reviews. PostgreSQL is rated 8.4, while SQLite is rated 7.2. The top reviewer of PostgreSQL writes " Real-time data capture optimizes database performance but Views create problems". On the other hand, the top reviewer of SQLite writes " Pretty easy to execute my SQL queries but issues while uploading and importing my dataset". PostgreSQL is most compared with Firebird SQL, EDB Postgres Advanced Server, MySQL, MariaDB and Chroma, whereas SQLite is most compared with Firebird SQL, MariaDB, MySQL, Oracle Berkeley DB and LanceDB. See our PostgreSQL vs. SQLite report.
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.