Post #2447764
2026-03-07 12:09 UTC
@hyc@mastodon.social
To be completely fair, SQL requires you to convert to and from string representation the whole time. If performance *really* matters, anything SQL-based is a mistake
@Archivist@social.linux.pizza
Replies (1)
-
@bert_hubert@eupolicy.social 2026-03-07 12:10
@wouter@pleroma.debian.social @hyc@mastodon.social @Archivist@social.linux.pizza this is not necessarily true - sql is just fine with storing binary data, and for example sqlite offers you a fine way to transparently store binary data w/o ever converting. I do this all the time & it is plenty fast.