sortable

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

26 rows where pk1 = "b" sorted by pk2 descending

descending

Link	pk1	pk2 ▲	content	sortable	sortable_with_nulls	sortable_with_nulls_2	text
b,l	b	l	b-l	-20			$null
b,k	b	k	b-k	-48	0.6697259747698292	0.3957858467912545	$blah
b,j	b	j	b-j	48	0.5945191535334412	0.6573731644725225	$blah
b,i	b	i	b-i	-83		0.9415961272290894	$null
b,h	b	h	b-h	-86	0.4767885171089349		$null
b,g	b	g	b-g	-61		0.5421952013742742	$blah
b,f	b	f	b-f	-33	0.9265180735593334	0.9573176408596732	$blah
b,e	b	e	b-e	4	0.48564112545071847		$blah
b,d	b	d	b-d	-88			$null
b,c	b	c	b-c	-54		0.8613491047618306	$null
b,b	b	b	b-b	86			$blah
b,a	b	a	b-a	5	0.7290758494598506		$blah

Advanced export

JSON shape: default, array, newline-delimited, object

CREATE TABLE sortable (
  pk1 varchar(30),
  pk2 varchar(30),
  content text,
  sortable integer,
  sortable_with_nulls real,
  sortable_with_nulls_2 real,
  text text,
  PRIMARY KEY (pk1, pk2)
);