Create a demo of querying OBO in SQL in the browser using sql.js

[cmungall]

h/t @kltm https://sql.js.org/#/

[kltm]

The absolute minimum: ~https://go-public.s3.amazonaws.com/index.html~ https://go-public.s3.amazonaws.com/db.html (see https://github.com/INCATools/semantic-sql/issues/63#issuecomment-1338372578) https://github.com/kltm/obo-sql-js-demo

[kltm]

A few thoughts about this:

• while the file sizes are large, on good internet they are not terrible
• workers could download a prioritized list in the background
• there may be new standard browser API settings that could allow this to be locally cached and only updates downloaded?
• if a subset of OAK commands that are backed by sqlite3 could be ported to JS (manually or wasm), it might make for a nice bit of advertising and playground
• "federated queries"
• may be nice to embed as part of tools so new ontology developers could get something braggable up quickly
• if GO (or anybody else, i.e. OBO) produced sqlite3 files as part of the distro, something like this could easily be embedded to make an easy per-release playground
• "GOOSE"

[kltm]

From @pkalita-lbl on local storage point: https://developer.mozilla.org/en-US/docs/Web/API/IndexedDB_API

[kltm]

@cmungall Now all ontologies: https://go-public.s3.amazonaws.com/db.html