@sjw@neckbeard.xyz @p @LukeAlmighty @Jojoisback @roka @lanodan Storing binary in a DB is dumb in most cases though.

@matrix @sjw @p @LukeAlmighty @Jojoisback @roka Yeah, a database should be for data that is parsable and indexable.
If pleroma would be articles-oriented instead of mainly microblogging oriented I would probably put the object content into the filesystem. (so quite like how a regular filesystem would cache mostly inodes and their metadata)
Follow

@lanodan
Maybe for some smaller files that you need really often. A database could cache them in memory, but most files don't get accessed that much and I'm pretty sure web servers cache things in memory too.
@p @LukeAlmighty @sjw@neckbeard.xyz @Jojoisback @roka

Sign in to participate in the conversation
Game Liberty Mastodon

Mainly gaming/nerd instance for people who value free speech. Everyone is welcome.