PostgreSQL
7.1#41 in database softwareFree planFree planLinuxmacOSSelf-hostedWindows
VisitPostgreSQL vs SQLite
What both publish
| Fact | PostgreSQL | SQLite |
|---|---|---|
| Free plan | Yes | Yes |
| License | The PostgreSQL License permits use, copying, modification, and distribution for any purpose without a fee or written agreement, subject to its conditions. | SQLite source code is in the public domain and is free for commercial or private use without a license. |
| Platforms | The project says PostgreSQL runs on all major operating systems and provides downloads for Linux, macOS, Windows, BSD, and Solaris. | The project lists Android, BSD, iOS, Linux, Mac, Solaris, VxWorks, and Windows as supported platforms. |
| Security | Listed security features include GSSAPI, LDAP, SCRAM-SHA-256, certificate and OAuth 2.0 authentication, access controls, row- and column-level security, and multi-factor authentication. | The security guidance says SQLite is extensively fuzz-tested and recommends defensive settings and lower input limits for applications accepting untrusted SQL. |
PostgreSQL plans
- PostgreSQLFree
SQLite plans
- SQLiteFree
- Public ForumFree
- Annual Maintenance Subscription$1,500 a year
- SQLite Encryption Extension (SEE)$2,000, paid once
- CEROD$2,000, paid once
- ZIPVFS$4,000, paid once
Pick PostgreSQL if…
PostgreSQL suits developers building applications and administrators focused on data integrity and fault-tolerant environments. It is a self-hosted option rather than a managed service.
Pick SQLite if…
SQLite suits developers who need device-local database storage, have low writer concurrency, and expect less than a terabyte of content.