#Downloads no longer time out
CSV downloads for large agencies or reports were failing before any data reached the browser. The query ran against the same database connection pool used by the rest of the site. Under load, a download query holding a connection for several minutes would block search and page requests behind it until it timed out.
#Plate search strips spaces and ampersands
Flock records do not include spaces in license plate numbers. Some states print plates with spaces — ABC 1234 instead of ABC1234. I’m also told “&” is a valid character for plates on some states.
Searching with a space or & in the plate now works: both characters are stripped before the lookup runs. A notice appears in the results when this happens.
#Quoted phrase search now works correctly
Searching for an exact phrase in quotes — "stolen vehicle", for example — was broken when the phrase contained quotation marks. PostgreSQL’s full-text search uses the english dictionary by default, which stems words and strips stopwords. That led to unexpected results.
Quoted searches now use the simple dictionary, which matches words exactly as written. Unquoted searches continue to use english. phrases.