mlunar@lemmy.worldtoSelfhosted@lemmy.world•Introducing Bitmagnet: A self-hosted BitTorrent indexer, DHT crawler, content classifier and torrent search engine with web UI, GraphQL API and Servarr stack integrationEnglish
4·
1 year agoHi, 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).
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.