Follow

Does Pleroma just search posts with SQL?

· · Web · 2 · 0 · 0
@matrix yeah using, ah I forget what they're called but they're the PostgreSQL think that breaks text up into sets of 3 letters for matching

so you search for "cutie" and it goes in and matches for "cut" "uti" and "tie" is my understanding (and the post is already broken efficiently to make that easier)
@pea @matrix @karen that's not the mechanism for post search though, just user search. post search uses the built in full text search mechanism of postgresql.
@lain @matrix @karen oh! i didn't know that, huh

is trigrams quicker with smaller things but full text is more robust i guess?
Sign in to participate in the conversation
Game Liberty Mastodon

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