compound_three_primary_keys

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

13 rows where pk1 = "b" and pk3 = "a"

descending

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

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