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."
"It is very useful for both structured and unstructured data. You can store unstructured and structured data in PostgreSQL. It is easy to use. You can easily manage things through PostgreSQL Admin. It is cost-effective. Its on-premise version is free. It is agnostic of on-premise or cloud. You can install it on the cloud or on-premises. It is available with all clouds, and you can also install it on desktop or Windows Servers."
"What I like is that it's quite powerful in terms of performance."
"We often use PostgreSQL for operations monitoring because we are a manufacturing company."
"PostgreSQL has complete SQL dialects and is useful for writing sophisticated and complex queries. We have experience with Oracle database. My partner is experienced in DDA and he writes sophisticated SQL queries. The solution helps to get the job done in the best possible way. In today’s age, most developers do not have strong SQL knowledge or language command. They find it difficult to write even a SQL statement. These developers write cool queries which perform badly on the database end. As DBAs, we constantly urge the developers not to write bad queries, help them learn more, and write placebo commands."
"The tool is user-friendly."
"It is very scalable and comes with a bonus: no licensing issues as you scale with your databases."
"The database has excellent performance."
"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."
"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."
"I use Flutter Technology with the JSF plugin."
"SQLite’s most valuable feature is the ability to store granular-level backups of databases."
"The solution needs to improve the query, documentation, and JSON data functionality."
"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."
"There could be a plugin to distribute the data on servers for the product."
"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."
"It needs more integration."
"PostgreSQL is a stable system, but from a security point of view, it still needs improvement."
"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."
"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."
"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."
"The performance could be better."
"It could have a user-friendly GUI and better intelligence features."
"Compared to other tools, the performance was less effective than that of Microsoft Access."
"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."
PostgreSQL is ranked 2nd in Open Source Databases with 123 reviews while SQLite is ranked 8th 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 OpenSearch, 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.