Joe 7 years ago
For all those interested. I have opened up a Pull Request to migrate us away from MongoDB to PostgreSQL. The plans have been in the pipeline for a long time but I'm going to start work on it now. It will take a while and all the changes can be watched through the PR. https://github.com/pjuu/pjuu/pull/297. Once this is complete we can clean up and add all the features we have planned and hopefully get a bit more performance from our small number of servers. Hope everyone is having a good evening.
  • 7

Replies

  • Joe 7 years ago
    I think I came to the same realisation. Our data is relational and we are basically doing the relations in code rather than in the DB. You are right it may help people host it themselves better. Still not sure about the federation though. I don't how much it is actually used.
    • 0
  • Lnxw37 7 years ago
    Reminds me of http://www.sarahmei.com/blog/2013/11/11/why-you-should-never-use-mongodb/ (though she took it a little too far, IMO).

    I think using #PostgreSQL also offers this advantage over using #MongoDB: If self-hosting of Pjuu and federation between instances takes off, it is easier to find hosting that is compatible with PG.
    • 1
  • Joe 7 years ago
    @lrobot there are a few reasons. The main one is code complexity because there is no joins, backup tooling is much better, bigger community for support, CTEs for efficient recommendations of followers and better support in Debian. Even if we need NoSQL, JSONB in Postgres has more features than Mongo. It should also be easier for others to contribute as more people know SQL. Hope that explains it 😀
    • 2
  • Lrobot 7 years ago
    Just interesting why migrate from mongodb to postgresql?
    • 1
  • Sigg3 7 years ago
    Great!
    • 2
  • Pietlu 7 years ago
    \o/
    • 2