compound_three_primary_keys

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

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

descending

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

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