compound_three_primary_keys

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

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

descending

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

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);