There’s probably no alternative as polished as that, but it’s not too far off either. You can kinda search like that with photofield (disclaimer: I made it), but many other foss photo libraries also support semantic search by now, LibrePhotos for one.
Hi, those points are certainly valid and I have nothing against these picks!
I just wanted to chime in that perf might not be as big of a problem as you might expect. 5k/hour is 1.4/sec, which sqlite should for sure be able to handle.
In fact, you can do hundreds to thousands of writes/sec, as long as you batch them in transactions (as by default each query is executed in its own transaction).