gQuest

Database Viewer

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

Loaded: Lesson 11 database ยท text-search-basics.database-init

CREATE TABLE articles (
  id SERIAL PRIMARY KEY,
  title TEXT NOT NULL,
  body TEXT NOT NULL
);


INSERT INTO articles (title, body)
VALUES
  ('PostgreSQL indexing guide', 'Indexes help PostgreSQL find rows.'),
  ('SQL join guide', 'Joins combine rows from different tables.'),
  ('JSON in Postgres', 'jsonb stores structured documents.'),
  ('Vector search notes', 'Similarity search compares embeddings.');