SQLite vs PostgreSQL
People think SQLite is a toy version of Postgres, and it is not. It is a different shape. SQLite has no server, and the whole database is one file inside your app. PostgreSQL is a server that many apps and users connect to at once. SQLite fits a phone app or a small site. Postgres fits a busy app with many writers.
SQLite
A tiny SQL database in one file. There is no server to run.
SQLite is a small SQL database that lives in one file, with no server to run. The app reads and writes that file directly. It is built into phones, web browsers and Python, which makes it one of the most used programs in the world. It is perfect for apps, tests and small sites. It is less suited to many users writing at the same moment.
PostgreSQL
A free, open-source SQL database with lots of tools. Many teams pick it first.
PostgreSQL is a free SQL database known for being careful. It is open source and full of tools. It keeps all four ACID promises and sticks close to the SQL standard. It can also store JSON, map data and text search in the same place. It began as a research project at a big school in 1986. Many teams now pick it as their first choice.
In one line
- SQLite
- A tiny SQL database in one file. There is no server to run.
- PostgreSQL
- A free, open-source SQL database with lots of tools. Many teams pick it first.