compound_three_primary_keys

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

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

descending

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

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