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.
"Scalable, stable, and easy to manage database system, with a straightforward installation."
"Initial setup is simple."
"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."
"The solution is open-source and free to use."
"The performance is good."
"Postgres is rock solid when deployed according to best practices as documented by the PostgreSQL community. When it's installed correctly, PostgreSQL is an enterprise-grade solution."
"It is easy to use."
"What I like is that it's quite powerful in terms of performance."
"The product is lightweight and highly scalable."
"I had some issues when I integrated with the Jupyter Notebook."
"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."
"I'm not really able to customize it."
"It would be good to have machine learning functionality in this solution, similar to Microsoft SQL Server and other solutions. Machine learning capability for a basic level or a common user would be useful. It can also have good reporting capabilities."
"PostgreSQL could improve by adding data warehousing tools."
"It would be great if the solution offered even more integration capabilities."
"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."
"The interface could be much better."
"The performance could be better."
PostgreSQL is a powerful and fully-featured database management system with which business owners can create object relational tables. It is an open source project that can be acquired for free and heavily focuses on elements such as extensibility and strict standard compliance. PostgreSQL is a flexible server system that can manage large workloads that are being contributed and accessed from a wide range of locations such as in a network, as well as small-scale projects like a single machine or user.
Some technical details of interest about PostgreSQL include:
PostgreSQL is ranked 2nd in Open Source Databases with 39 reviews while SQLite is ranked 5th in Open Source Databases with 1 review. PostgreSQL is rated 8.2, while SQLite is rated 9.0. The top reviewer of PostgreSQL writes "Can be clustered which allows for fault tolerance". On the other hand, the top reviewer of SQLite writes "Lightweight, easy to set up, and free to use". PostgreSQL is most compared with Firebird SQL, MariaDB, MySQL, EDB Postgres Advanced Server and Percona Server, whereas SQLite is most compared with Firebird SQL, MariaDB, Oracle Berkeley DB and MySQL.
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.