compound_three_primary_keys

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

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

descending

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

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