PostgreSQL
ELI5 — The Vibe Check
PostgreSQL (just say 'Postgres') is the Swiss Army knife of databases. It is free, incredibly powerful, handles JSON like a NoSQL database, and basically does everything. Most serious vibecoders end up here eventually.
Real Talk
PostgreSQL is an open-source object-relational database management system with over 35 years of active development. It is known for strong ACID compliance, extensibility, support for advanced data types (JSON, arrays, custom types), full-text search, and a rich ecosystem of extensions.
Show Me The Code
CREATE TABLE users (
id SERIAL PRIMARY KEY,
email TEXT UNIQUE NOT NULL,
created_at TIMESTAMPTZ DEFAULT NOW()
);
When You'll Hear This
"We use Postgres for everything." / "Supabase runs on top of PostgreSQL."
Related Terms
ACID (Atomicity, Consistency, Isolation, Durability)
ACID is the four guarantees a reliable database makes about transactions. It is the reason you trust a bank's database with your money.
Index
A database index is like the index in the back of a book. Without it, the database reads every single row to find what you want.
SQL (Structured Query Language)
SQL is the language you use to talk to a database. You ask it things like 'give me all users who signed up this week' and it actually does it.
Supabase
Supabase is Firebase but built on real Postgres SQL. You get a database, auth, file storage, and real-time updates all in one.
Transaction
A transaction groups multiple database operations into one all-or-nothing bundle. Either ALL of them succeed, or NONE of them happen.