The advantage of SQLite is its maturity and stability. It famously has no bugs and has 100% test coverage. I’d say that’s a reason it’s still so ubiquitous
Yeah that’s what I’m doing for emoji as well. When rendering text I check through the text for emoji Unicode and pass all the regular text to the default renderer of NanoVG, and for the emojis I have a texture atlas. If the emojis not already in the atlas I call out to CoreText on iOS to render them for me
@jb55 I worked on a client a couple months back that renders everything through NanoVG in C++, similar to your chosen stack for NoteDeck. I managed to add support for emoji rendering by writing some OS specific code (CoreText for iOS, out to HTML canvas for web, etc…).
I added support for this in Damus, but only did the decoding part of it. At that time (maybe different now) Damus didn’t have seem to have a simple way to make relay URLs interactive. Would be nice if you could tap and then have an option to add it to your list of relays. But currently it just shows the URL