As i understand, psql has pretty much it’s use for all that relational data, so it makes sense using it. Also since it’s Symfony, it might be easier to work on relational DB such as psql instead of NoSQL where it might not be an easy task.

And yeah if Mastodon supports Elasticseach/Opensearch, i suppose it would be a complement for the full text search as @piotrsikora said.

Thanks for the answer tho !

Thanks for the reply @piotrsikora ! I see, so relational db is pretty much mandatory as i understand, and NoSQL has its place as a complement instead of a replacement

Thanks

A very interesting take ! They might have been a way to structure the data, but indeed it might make more sense to use a relational DB.

Thanks for the answer ^^