News for hackers. Stuff that matters.
Re:A Programming Language Database by simonw on Saturday August 27, 2022 @06:48PM (#32624020)
The CSV file at https://pldb.com/pldb.csv is served with open CORS headers:

    Access-Control-Allow-Origin: *
This means you can open it in web apps like my Datasette Lite application, so you can run SQL queries against it in your browser:

https://lite.datasette.io/?csv=https://pldb.com/pldb.csv#/da...

Here's a more interesting query: https://lite.datasette.io/?csv=https://pldb.com/pldb.csv#/da...

Re:A Programming Language Database by breck on Sunday August 28, 2022 @10:33AM (#32628679)
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#/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?

Re:A Programming Language Database by simonw on Sunday August 28, 2022 @12:49PM (#32629830)
Yeah 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

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!

Re:A Programming Language Database by breck on Sunday August 28, 2022 @03:53PM (#32631470)
> 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

Is there anyone I can pay to take care of setting that up for PLDB?

Re:A Programming Language Database by simonw on Thursday September 01, 2022 @09:04PM (#32685410)
Drop me an email at swillison at Google's mail provider.