Database Viewer

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

Database

Loaded: Lesson 10 database · sorting-and-pagination.database-init

CREATE TABLE events (
  id SERIAL PRIMARY KEY,
  name TEXT NOT NULL,
  starts_at TIMESTAMP NOT NULL
);

CREATE INDEX events_starts_at_idx ON events (starts_at DESC);


INSERT INTO events (name, starts_at)
VALUES
  ('Kickoff', TIMESTAMP '2026-01-01 09:00'),
  ('Schema review', TIMESTAMP '2026-01-02 09:00'),
  ('Index workshop', TIMESTAMP '2026-01-03 09:00'),
  ('Aggregation lab', TIMESTAMP '2026-01-04 09:00'),
  ('Join clinic', TIMESTAMP '2026-01-05 09:00');

ANALYZE events;