Skip to content

PostgreSQL vs SQLite

A side-by-side look at PostgreSQL and SQLite. For an in-depth review of either product, follow the links below.

PostgreSQL

PostgreSQL

Development

PostgreSQL is an open source, object-relational database management system known for its reliability, performance, and SQL compliance. It runs on all major operating systems and has a rich set of features including complex queries, foreign keys, triggers, views, and ACID compliance.

open-sourceobjectrelationalreliableperformantsql-compliant
SQLite

SQLite

Development

SQLite is a relational database management system contained in a C library. It is a popular choice as an embedded database for local/client storage in software applications due to its compact size, reliability, and availability on most platforms.

databaseembeddedlocal-storagec-libraryrelational

Related Comparisons

Oracle Database
IBM Lotus Approach
Apache HBase