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."We managed to reduce the storage space needed to 10% of the original size, without affecting data integrity, and we significantly improved the performance."
"It is easy to use."
"I like that you can move any relational database from Oracle to PostgreSQL. I also like that it's pretty stable."
"It is easy to install and easy to manage. There is no license on it, so it is free. There is high compatibility with Oracle, and there are many tools for the migration of data from Oracle to Postgre."
"Postgres has some functions called JSONB aggregators or other aggregators, which are quite useful."
"The built-in code procedural language is the most valuable. It has a built-in layer for code procedures. Its installation is very easy and quick, and it is free. It is also stable, and its performance is also good."
"The tool is user-friendly."
"PostgreSQL is very powerful, easy to manage, and has many features."
"SQLite’s most valuable feature is the ability to store granular-level backups of databases."
"I use Flutter Technology with the JSF plugin."
"I haven't encountered any problems in my use cases. So, it has been a stable product for me."
"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."
"It was a bit easy to use compared to other tools. It's simple. I found it pretty easy to execute my SQL queries."
"There are several features I would like to improve that aren't working as expected. It's likely that the latest version is doing something that was missed in the previous versions. For example, the output parameters — the stored procedures — is something new in PostgreSQL that Firebird has already had for a long time."
"The interface climate could be better."
"The performance of PostgreSQL could improve."
"It still needs to be more mature and have some backup feature. We are normally dealing with Oracle's data, and we have very strong online tools to back up the data and do other things. PostgreSQL still needs to do more in this area as well as in the high availability area. There are many external tools that you can use for PostgreSQL's high availability, but there is no embedded tool within PostgreSQL for high availability. It could have a feature similar to Oracle for working on a distributed system. It can have some scripts to improve the monitoring and some tools to do performance analysis. We have a workaround for most of such requirements except for the support for a distributed system, which is very difficult to have. This area should be included in the core of the database itself."
"Instead of the installation agent downloading all the packages for the install, it should allow the user to download the packages separately on their own to do the install."
"PostgreSQL uses high memory compared to its counterparts when a highly demanding load is involved, especially one that makes many concurrent connections to the database."
"I'd like to see better memory management. I think that that's one of the few areas that Postgres does not handle as well as MySQL does or did."
"I had some issues when I integrated with the Jupyter Notebook."
"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."
"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."
"A potential drawback is that the database file stored within the application's local storage could be accessible to users."
"Compared to other tools, the performance was less effective than that of Microsoft Access."
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.