sortable

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

26 rows where pk1 = "b" sorted by sortable

descending

Link	pk1	pk2	content	sortable ▼	sortable_with_nulls	sortable_with_nulls_2	text
b,x	b	x	b-x	17		0.22292354720580898	$blah
b,q	b	q	b-q	29		0.09229846771273342	$null
b,m	b	m	b-m	37	0.2131543122670404	0.8808641736864395	$blah
b,s	b	s	b-s	43	0.07524386007376704	0.9039285715598931	$null
b,j	b	j	b-j	48	0.5945191535334412	0.6573731644725225	$blah
b,o	b	o	b-o	70	0.2993787521999779	0.1035865019182115	$null
b,b	b	b	b-b	86			$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)
);