The avatar for @credmond
Charles Redmond
Public
Edited
May 24, 2023
Insert cell
Insert cell
db = DuckDBClient.of({})
Insert cell
db
DROP TABLE PERSON;
Insert cell
db
DROP TABLE favorite_food;
Insert cell
db
CREATE SEQUENCE seq_personid START 1;
Insert cell
db
CREATE TABLE person
(
person_id USMALLINT default nextval('seq_personid'),
fname VARCHAR(20),
lname VARCHAR(20),
eye_color CHAR(2) CHECK (eye_color IN ('BR','BL','GR')),
birth_date DATE,
street VARCHAR(30),
city VARCHAR(20),
state VARCHAR(20),
country VARCHAR(20),
postal_code VARCHAR(20),
CONSTRAINT pk_person PRIMARY KEY (person_id)
);
Insert cell
db
CREATE TABLE favorite_food
(person_id USMALLINT,
food VARCHAR(20),
CONSTRAINT pk_favorite_food PRIMARY KEY (person_id, food),
CONSTRAINT fk_fav_food_person_id FOREIGN KEY (person_id)
REFERENCES person (person_id)
);
Insert cell
db
INSERT INTO person
(fname, lname, eye_color, birth_date)
VALUES ('William','Turner', 'BR', '1972-05-27');
Insert cell
db
SELECT person_id, fname, lname, birth_date
FROM person
Insert cell
query[0]
Insert cell

Purpose-built for displays of data

Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
Learn more