sortable

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

26 rows where pk1 = "d" sorted by sortable_with_nulls

descending

Link	pk1	pk2	content	sortable	sortable_with_nulls ▼	sortable_with_nulls_2	text
d,a	d	a	d-a	48	0.3119572443946952	0.37530695942531844	$null
d,f	d	f	d-f	19	0.4355744930038943		$blah
d,g	d	g	d-g	15	0.46470846660323173	0.6681884704454936	$blah
d,j	d	j	d-j	76	0.4760931107841647		$blah
d,h	d	h	d-h	-54	0.48754993239134437	0.8803199797582254	$blah
d,e	d	e	d-e	11	0.5217467469384799	0.8081992188067559	$blah
d,s	d	s	d-s	98	0.5225725351302178	0.2973531325173874	$blah
d,x	d	x	d-x	-71	0.5445623787105787		$blah
d,p	d	p	d-p	-97	0.5740642196263323	0.34070593256029236	$blah
d,t	d	t	d-t	45	0.6096309122451303	0.7627371043547087	$null
d,l	d	l	d-l	-10	0.7028549421857689	0.23053804129850775	$null
d,y	d	y	d-y	52	0.7489577220696233	0.4391534486737374	$blah
d,c	d	c	d-c	44	0.7826353463610196	0.06895673651964052	$blah
d,n	d	n	d-n	-75	0.8326283633270679	0.014148367256063832	$null

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