Database Viewer

Browse the SQL that builds any database used across the lessons, without running it.

Database

Loaded: Lesson 12 database · json-in-postgresql.database-init

CREATE TABLE accounts (
  id SERIAL PRIMARY KEY,
  email TEXT NOT NULL,
  profile JSONB NOT NULL
);


INSERT INTO accounts (email, profile)
VALUES
  ('ada@example.com', '{"plan": "pro", "settings": {"email": true}, "tags": ["sql", "math"]}'),
  ('grace@example.com', '{"plan": "free", "settings": {"email": false}, "tags": ["compiler"]}'),
  ('linus@example.com', '{"plan": "pro", "settings": {"email": false}, "tags": ["kernel", "c"]}');