compound_three_primary_keys

Data source: github.com/simon/datasette-psutil · About: /-/psutil demo

12 rows where pk1 = "b" and pk3 = "o"

descending

Link	pk1	pk2	pk3	content
b,a,o	b	a	o	b-a-o
b,b,o	b	b	o	b-b-o
b,c,o	b	c	o	b-c-o
b,d,o	b	d	o	b-d-o
b,e,o	b	e	o	b-e-o
b,f,o	b	f	o	b-f-o
b,g,o	b	g	o	b-g-o
b,h,o	b	h	o	b-h-o
b,i,o	b	i	o	b-i-o
b,j,o	b	j	o	b-j-o
b,k,o	b	k	o	b-k-o
b,l,o	b	l	o	b-l-o

Advanced export

JSON shape: default, array, newline-delimited, object

CREATE TABLE compound_three_primary_keys (
  pk1 varchar(30),
  pk2 varchar(30),
  pk3 varchar(30),
  content text,
  PRIMARY KEY (pk1, pk2, pk3)
);
CREATE INDEX idx_compound_three_primary_keys_content ON compound_three_primary_keys(content);