4 ms·
This is awesome Simon! I actually had it on my todo list to explore using datasette with PLDB. Here's my quick query to see the number of things that are missi
by breck 4y ago
This is awesome Simon! I actually had it on my todo list to explore using datasette with PLDB.
Here's my quick query to see the number of things that are missing a year and also a count of the total things in each year:
https://lite.datasette.io/?csv=https://pldb.com/pldb.csv#/data?sql=select+appeared%2C+count%28*%29+as+count+from+pldb+group+by+appeared+order+by+appeared+desc https://lite.datasette.io/?csv=https://pldb.com/pldb.csv#/da...
2 pieces of feedback (which I'm sure you're aware of):
1. super slow startup time (30seconds or so, but then things are instant).
2. autocomplete column names (and syntax highlighting) for the editor?
- simonw 4y agoYeah the slow startup is because this is using Datasette Lite, which loads an entire Python runtime compiled to WebAssembly into your browser every turn you load the page! Server-side Datasette starts a whole lot quicker than that, eg https://scotrail.datasette.io/scotrail/random_apology https://scotrail.datasette.io/scotrail/random_apology The editor has syntax highlighting in server-side Datasette - I've not got that working in Datasette Lite yet. Column autocompletion would definitely be cool!
- breck 4y ago> which loads an entire Python runtime compiled to WebAssembly into your browser every turn you load the page Oh wow! (the lengths people will go to to avoid learning Javascript ;) ) > Server-side Datasette starts a whole lot quicker than that, eg https://scotrail.datasette.io/scotrail/random_apology https://scotrail.datasette.io/scotrail/random_apology Is there anyone I can pay to take care of setting that up for PLDB?
- simonw 4y agoDrop me an email at swillison at Google's mail provider.