Shouldn't this request be directed to Taptalk Inc? They seem to charge both the app user and the forum maintainer for "pro" features.
As this is an open source project, they're free to provide a NodeBB taptalk plugin and earn more money 😉
Dear NodeBB Team,
May I humbly request to have Postgresql supported?
I understand that I am asking a lot, I mean, when you commit a feature, you have to support it going forward, so this may become a liability and a big headache, especially given the number of forums you must have on your back.
The upside is that Postgresql integration will allow simple and cost effective setup/hosting (for example in Amazon/Heroku, where Postgresql is provided as a service with automated backups/restore).
I believe (my humble personal opinion), that with Postgresql support, NodeBB will become more popular, especially with the teams that have less IT experience (yes, I admit I am one of them ).
It seems that @Ben-Lubar completed the Postgresql driver and has a pending pull request: https://github.com/NodeBB/NodeBB/pull/5861. It looks like the relevant DB tests passed and the driver is ready for action. Furthermore, from what I read the driver has similar performance to Mongo/Redis. I would love to see it committed to master so I could give it a test run.
Lastly, I realize that you must be extremely busy, so I totally understand if Postgresql is put on the back burner. I have yet to see a similar team that is so helpful. Thus so far you immensely helped my efforts and I am most appreciative.
Thanks again for your kind consideration,
It's in the works: https://github.com/NodeBB/NodeBB/pull/5861
Thank you @PitaJ .
I fully realize Postgres driver is at work, and I quoted the very same pull request you did in my original message.
It is just that @Ben-Lubar 's pool request has been collecting dust for quite some time, while all test seems to perform as expected. Looks like the code is baked and ready for prime-time, at least from where I am sitting
Again, I fully realize you guys are busy!
I sure hope you'll find some time to merge the pull request into master soon.
All the best,
@jjsagan we're in direct communication with him, and it's almost done
Definitely appreciative of @Ben-Lubar 's efforts to bring pgSQL support to NodeBB. Looking forward to merging it in. The main blocker is that we are not too familiar with pgSQL here at NodeBB HQ, and so we'd need someone (in addition to Ben) to maintain it and debug any issues/inconsistencies that arise
If I may suggest, it seems that hmqgg https://github.com/NodeBB/NodeBB/pull/5861 (see Apr-10 comments) may have sufficient knowledge, and is keen on improving the code. Perhaps he may be open to help-out as well.
First allow me to thank you and the team for all the improvements made recently with 1.10+. As always you guys are amazing!
Is there any chance to see @Ben-Lubar 's postgresql pull request integrated soon?
We are currently running the PR on https://what.thedailywtf.com/, and it's working without any new problems.
Wow amazing! how long have you been running? How's the performance in comparison to redis/mongo? When will this gem get integrated into master?
My apology for the many questions, just a bit excited to see this code finally on prime time
I decided to look at the recent commits, and..., well, could not believe my eyes, PostgreSQL just got integrated!
PostgreSQL opens the door for (novice) admins to create forums based on NodeBB, on cloud platforms that don't support MongoDB or Redis, or where such support is too expensive.
With PostgreSQL support, the admin does not need to create and maintain a database on an instance - instead for a similar cost he may opt for PostgreSQL as service. In Amazon AWS for example, the service comes with automated backup and restore. The integration is quite speedy with low to moderate effort (basically reading few AWS documents and following examples).
Besides that, PostgreSQL offers additional features over key-value database, so future releases may benefit as well.
Congratulations on this fine release.
I am grateful for your work and dedication!
Made some progress, but hit a small bump
For those who are converting from Redis:
Open pgAdmin and create a new user/pass (default username is nodebb). Create a new database, and grant login permission to the just created new user
DL the converter and follow the github instructions using the new database name
npm install continuation-local-storage
npm install pg
Change the Config file:
Run ./nodebb setup.
That's how far I got, I am now getting the following error:
Now configuring postgres database:
warn: NodeBB Setup Aborted.
error: type "legacy_object_type" already exists
The legacy_object_type was created by the converter, so something must have gone wrong.
@Ben-Lubar can you please help?
Thanks @Ben-Lubar! I tried running (,/nodebb build ), but got the below. Any idea?
Perhaps the issue sourced from the parameters I provided the converter?
Kindly note, I use Redis, on SCHEMA=1.
--type redis \
--input 'redis://REDIS_SERVER_ADDR:6379/1' \
--sessionType redis \
--sessionInput 'redis://REDIS_SERVER_ADDR:6379/1' \
--outputType postgres \
--output 'postgresql://username:password@PSQL_SERVER_ADDR:5432/MY_NEW_DATABASE' \
Hi @Ben-Lubar ,
I am still stuck at the same spot, no matter what I do.
I guess the converter and the pg driver are a bit incompatible, at least on my database.
However my DB is very small, and quite standard...
Any suggestion how to resolve?
Thank you very much in advance!
Hi @Ben-Lubar ,
Yes they are the same, my apology for the naming confusion.
Kindly note the "/1" indicating SCHEMA=1 - I believe it is required but I was not sure it should appear in both Input and sessionInput,
Thanks for looking into this!
Hi @Ben-Lubar .
No matter what I do, I can't bring up the converted forum generated by nodebb-postgres-converter.
Honestly I am not sure what to do next... Any idea what I should check?