Supabase vs PostgreSQL
People think Supabase is its own kind of database, and it is not. Under it sits a normal PostgreSQL database, the same one you can run yourself. Supabase adds login, file storage and a ready-made API around it. So the SQL you know from Postgres works there too.
Supabase
A hosted back end built on a Postgres database. It adds login and file storage.
Supabase is a hosted back end built around a PostgreSQL database. Each project gets a full Postgres database. Around it, Supabase adds user login, file storage, live updates and small server functions. It also makes an API for your tables. So a web or phone app can read and write data with no server of its own.
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
- Supabase
- A hosted back end built on a Postgres database. It adds login and file storage.
- PostgreSQL
- A free, open-source SQL database with lots of tools. Many teams pick it first.