Skip to content

recreate full open access data in sqlite3 db format AND expose it to the web using the http range/sqlite hosting "trick" #6

@gregsadetsky

Description

@gregsadetsky

goal: create a front-end "api" to all of the open access data, including the image urls, and host it all for free on github pages as a static site.

plan / how to do it:

  • download latest openaccess datasets from met & chicago (still being distributed as giant csv files..?)
  • merge them with known image urls from this repo
  • shove everything into a sqlite3 database file
  • test/implement/demo a way of querying this database from static/front-end only sites using the technique described here i.e. the database being hosted on github pages as a static file, and sql.js + a lot of magic code doing sql queries against this database over the network using http range requests (i.e. being super efficient in the network queries they do, allowing them to read from the db without downloading the whole file)

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions