ol-explore.sql 516 B

12345678910111213
  1. --- Views and such for understanding the contents of the OpenLibrary data
  2. CREATE MATERIALIZED VIEW ol_edition_json_keys
  3. AS SELECT json_key, COUNT(edition_id)
  4. FROM (SELECT edition_id, jsonb_object_keys(edition_data) AS json_key
  5. FROM ol_edition) eks
  6. GROUP BY json_key;
  7. CREATE MATERIALIZED VIEW ol_work_json_keys
  8. AS SELECT json_key, COUNT(work_id)
  9. FROM (SELECT work_id, jsonb_object_keys(work_data) AS json_key
  10. FROM ol_work) eks
  11. GROUP BY json_key;