Let’s hope MLS solves some of this, but there is a certain amount of necessary complexity with syncing encryption keys for groups as people come and go.
I’m very annoyed by issues decrypting messages in private conversations. Nothing is changing, so it should just work after the first message, but no. Random messages can’t be decrypted unless I refresh. Very frustrating.
Nothing, the floozy
Yeah, this feels like “premature optimization”. When you design your applications and databases, it should reflect your understanding of the problem and how you solved it as best as possible. Using DATETIMEOFFSET NULL when you actually mean BIT NOT NULL isn’t saying what you mean. If you already understand that you have a boolean option and you think you might need a timestamp to track it, use 2 columns. Or an audit table. So sayeth the holy SRP.
Yeah, this is one of those constant annoyances that you kinda just live with. It doesn’t matter that much, because compound words were at some point not one word, and there may be separate words that you use today that will join together during your career. Electronic mail became e-mail became email. As long as the casing doesn’t hide the meaning, you’re doing it right. Also be consistent. Don’t recreate such monstrosities as XMLHttpRequest.