Hi there ! (First post ever yay!)

I’m, like a lot of users lately, been migrating from Reddit to Kbin and Lemmy.

I finally had a good reason to contribute by writting HelmCharts to run Lemmy and Kbin on Kubernetes ( hopefully some of you might be interested !)

Anyways, i was wondering whrn analysing the docker stack of Kbin if instead of running postgresql, it could be replaced by a NoSQL service such as MongoDB.

I felt like the concept of the fediverse and the data structure seem pretty compatible.

And since there have been some performance issues ( probably for database) lately, it might be an interesting way to deal with large volumes of data.

Let me know what you think !

Cheers!

  • birlocke_@kbin.social
    1·
    1 year ago

    I do believe that Mastodon supports Elasticsearch/Opensearch OOTB, so you’re not wrong on NoSQLs being fediverse compatible.
    Personally I haven’t looked into the kbin stack so I can’t give an opinion as to why psql is used over X.

    • Burn1ngBull3t@kbin.socialOP
      1·
      1 year ago

      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 !