Joaquim Homrighausen (joho@mastodon.online)'s status on Saturday, 01-Feb-2025 00:05:46 JST

@heiglandreas

The data is stored in an SQL database. I've started to encrypt the (sensitive parts of) data at rest. So I need to do in-memory comparisons and sorting.

Normally, I would compare w/all umlauts, etc, but in this particular case, I want to get a match on "vårsol" when I'm searching for "vårsol" or "varsol". And this matching is, after decryption, done in the application layer.

(And I don't want to use specific database functionality to handle all this.)

@thanius @lpwaterhouse