Post #2447765
2026-03-07 12:10 UTC
@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.
Replies (1)
-
@wouter@pleroma.debian.social 2026-03-07 12:20
@bert_hubert@eupolicy.social You mean like https://www.sqlitetutorial.net/sqlite-blob/, correct? Your SQL engine would still be involved, and needs to do string parsing just to understand what it is you want to store in binary. Yes it's faster than converting to base64 and back, but not as fast as a memcpy ala LMDB. I said "*really*" for a reason 😉 @hyc@mastodon.social @Archivist@social.linux.pizza