let's use logger.debug everywhere instead of print

seems like this is the only line that is changed from the above function - can we just add this conditionally in both search and getRecentResults specified by an optional parameter instead?

I think it would be this single line and a change to the function signature instead - saving like 50 lines of code

like:

var partialQuery = allText
  .join(frames, on: frames[id] == allText[frameId])
  .join(videoChunks, on: frames[chunkId] == videoChunks[id])

if appName != "" {
  partialQuery = partialQuery.join(uniqueAppNames, on: uniqueAppNames[activeApplicationName] == frames[activeApplicationName])
}

let query = partialQuery
  .filter(text.match("*\(searchText)*") && uniqueAppNames[activeApplicationName].lowercaseString == appName.lowercased())
  .select(allText[frameId], text, frames[activeApplicationName], frames[timestamp], videoChunks[filePath], frames[offsetIndex])
  .limit(limit, offset: offset)

since we have the dropdown, should we remove this?

why onHover out of curiosity? This means it's blank until you hover. Could we instead do onAppear?

I had initially implemented it with onAppear, but it would cause the filter to only update on the first time the user clicked on "Search". It means that, if you left the search screen and went back to it again, the filter would stay the same until you restarted the program.

I made a new change adding both onAppear and onHover, which solves the issue of it being blank at first and not updating after the first search.