gQuest

Database Viewer

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

Loaded: Lesson 15 database ยท vectors.database-init

CREATE TABLE documents (
  id SERIAL PRIMARY KEY,
  title TEXT NOT NULL,
  embedding DOUBLE PRECISION[] NOT NULL
);


INSERT INTO documents (title, embedding)
VALUES
  ('SQL indexes', ARRAY[0.90, 0.10, 0.20]),
  ('JSON documents', ARRAY[0.20, 0.80, 0.30]),
  ('Vector search', ARRAY[0.10, 0.20, 0.95]),
  ('JOIN patterns', ARRAY[0.75, 0.25, 0.25]);