Redis or MongoDB?

[sweetp]

I migrated my forum from mongo to Postgres. using the mentioned plugin. and before the I migrated a mySQL myBB setup to mongo. Its not all that difficult to migrate

[scottalanmiller]

@sweetp said in Redis or MongoDB?:

I migrated my forum from mongo to Postgres.

What was the impetus in going from MongoDB to PostgreSQL? MongoDB does such an amazing job.

[sweetp]

@scottalanmiller im already familiar with Postgres, and monogDB isn't officially compatible with my Plesk VPS.

[JJSagan]

I have been working with PostgreSQL for over two months. So far not a single issue. @Ben-Lubar did an amazing job, and continues to do so - see pull request here:
https://github.com/NodeBB/NodeBB/pull/6745

PostgreSQL is probably the best solution if you are hosting in AWS, since MongoDB is not available unless you can front 20K USD$ per year

[scottalanmiller]

@sweetp said in Redis or MongoDB?:

@scottalanmiller im already familiar with Postgres, and monogDB isn't officially compatible with my Plesk VPS.

Ah, makes sense. I bet the performance with a web hosting service is pretty bad, though.

[scottalanmiller]

@JJSagan said in Redis or MongoDB?:

I have been working with PostgreSQL for over two months. So far not a single issue. @Ben-Lubar did an amazing job, and continues to do so - see pull request here:
https://github.com/NodeBB/NodeBB/pull/6745

PostgreSQL is probably the best solution if you are hosting in AWS, since MongoDB is not available unless you can front 20K USD$ per year

I think that there must be some confusion. MongoDB is the same cost on Amazon as it is anywhere else, free. You must be thinking that using AWS requires you to not use a normal setup but some special AWS service. That's incorrect. You'd run MOngoDB the same as anywhere else, being on AWS might offer additional choices, but not fewer. There is no limitation or cost like you are thinking there. Even if you wanted a hosted MongoDB that you aren't responsible for, MongoDB's own Atlas service is VERY affordable and on AWS.

[JJSagan]

If you want to have pre-configured server managed by aws, I believe mongodb is unavailable.
you can setup your own server, however...

[scottalanmiller]

@JJSagan said in Redis or MongoDB?:

If you want to have pre-configured server managed by aws, I believe mongodb is unavailable.
you can setup your own server, however...

So the same as anywhere else. It's just something you install on your NodeBB VM. The needs even for the busiest sites is very minimal.

But if you want it fully hosted on AWS and fully managed, that's what Atlas is for. And they have a free tier, I believe.

[JJSagan]

Anyway, my point was that PostgreSQL is stable and working.
Take care!

[sweetp]

@scottalanmiller my support forum has pretty low traffic, so it’s not really an issue

Actually the version of postgresql I had to install on my server doesn’t seem to be compatible with my install of Plesk either.

But it works well, and I don’t have to mess around learning how to support mongodb.