Please suggest other search examples

,
12

That’s not currently implemented, but it’s certainly doable, and I like that format!

The way I store captured-at would let me easily do that query, as it’s in “local formatted centiseconds”: now is 2021050908321200.

SELECT * 
FROM Asset 
WHERE Asset.capturedAtLocal/100000000 % 10000 BETWEEN 503 AND 513;

but it’d be an Asset index scan.

I’ll get to this after I get first passes at albums and deletions finished. :+1: