OFMetadataToStash icon indicating copy to clipboard operation
OFMetadataToStash copied to clipboard

Published 20 hours ago • verified publisher icon ALonelyJuicebox

Improve SQLite Queries

Open ghi820 opened this issue 9 months ago • 0 comments

  • Include stories in the metadata query and remove size = null from the list (reduces useless queries).
  • Consolidate SQL queries for video and image (each one was repeated 4 times) and move the boilerplate GQL-wrapper into a function.
  • Fix the history update sqlite query, which referenced the field instead of the table (causing an sql-error)

ghi820 avatar May 07 '24 01:05 ghi820