Support for PostgreSQL as alternative to MongoDB

Elephants don't fly, most of the time:
http://meteor-postgres.readthedocs.org
https://github.com/meteor/postgres-packages

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

@maxlazio

More context in https://about.gitlab.com/2015/08/22/gitlab-7-14-released/
To ship in 8.0 we need something to integrate around September 7 I think (@maxlazio knows more) so that will be really tight. Alternatively we can ship in 8.1. Please keep us posted.

http://info.meteor.com/blog/an-early-look-at-sql-in-meteor

Some approach to consider
http://www.postgresql.org/docs/9.4/static/datatype-json.html

An early look at SQL in Meteor
https://forums.meteor.com/t/an-early-look-at-sql-in-meteor/8736

More people wanting this to happen
#639

+1

Mongo can be a pain and can be very expensive to scale in the cloud. At least allowing to swap the data store to AWS DynamoDb (also noSQL as a scalable Db-as-a-service) would alleviate some of this for large deployments or in an enterprise setting. But PostgreSQL 9.3 would work too.

We found a few temporary road blocks that the our team is having to deal with.

Meteor is yet to release the official support to SQL, so we are playing only with alpha implementations at this point. That means that some of the core packages, like the accounts, don't work 100% with SQL yet. We are patching what we can to make it work, and hopefully can contribute something back to the to meteor master branch. https://github.com/RocketChat/Rocket.Chat/compare/postgresql
The third party packages we use, also do not support SQL yet, for obvious reasons. We are creating an abstraction layer that overwrites some meteor APIs to make they work without having to fork them (at least most of them) using https://github.com/goodybag/mongo-sql
We are refactoring the all the source code to isolate all DB calls into a package. The idea is to turn it into a replaceable package with the DB of choice. This should be finished this week.
https://github.com/RocketChat/Rocket.Chat/compare/models

Still early days to commit to a date.. but I'll update this issue more regularly on our progress.

Any news on PostgreSQL integration? The ticket was closed almost a year earlier and its very hard to justify using MongoDB with an opensource project nowadays. Thanks in advance

@apjapj

@apjapj I don't believe that rocket chat will support postgresql ever

postgres has had a json/jsonb datatype for a while. it should be fairly easy to just change a document store to a postgres table jsonb store. each table would be a "collection" in mongo with one jsonb field per table.
If there is a decent repository layer this shouldnt be too much work.

Mongo has way less hosting options and is much more expensive to host.
Going this route you could virtually use any database like mysql etc.. as they have json fields as well.

@apjapj

@apjapj @seand88 If you want a similar platform that supports PostgreSQL, look at Mattermost. As noted in #533 (comment), there's no way this is going to happen.

it should be fairly easy to just change a document store to a postgres table jsonb store. each table would be a "collection" in mongo with one jsonb field per table.
If there is a decent repository layer this shouldnt be too much work.

Feel free to try, I'd love to see that you are right :) I think it is not that trivial :)

Merge pull request RocketChat#533 from WideChat/develop_pwa-catchup-6…

Are there any plans to support postgresql? Postgresql can successfully replace mongodb and has higher performance
https://www.enterprisedb.com/news/new-benchmarks-show-postgres-dominating-mongodb-varied-workloads

@loid345

@loid345 we don't have any plans to replace MongoDB right now. But we are always open to contributions if figure out an easy way to make this replacement.

There is maybe hope over there:
https://www.mangodb.io/

Is this still on the list and work in progress?

Any updates?

Any updates?

Please read all the comments, and notably these ones.

#533 (comment)

In short the answer is no, and not for the foreseeable future either.

rip, no stoat or rocket chat on my pi, it's annoying but i'm going to have to find an alternative.

Navigation Menu

Repository navigation

Support for PostgreSQL as alternative to MongoDB #533

95 remaining items

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Support for PostgreSQL as alternative to MongoDB #533

Description

Activity

dosire commented on Aug 23, 2015

engelgabriel commented on Aug 24, 2015

engelgabriel commented on Aug 25, 2015

engelgabriel commented on Aug 25, 2015

engelgabriel commented on Sep 1, 2015

jclabaugh commented on Sep 10, 2015

engelgabriel commented on Sep 16, 2015

95 remaining items

apjapj commented on Sep 25, 2020

piotrkochan commented on Sep 25, 2020

seand88 commented on Sep 25, 2020

kohenkatz commented on Sep 25, 2020

pierreozoux commented on Sep 25, 2020

loid345 commented on Aug 18, 2021

rodrigok commented on Aug 30, 2021

pierreozoux commented on Nov 8, 2021

yourhomelab commented on Feb 8, 2023

yorkfly commented on Sep 30, 2024

reetp commented on Sep 30, 2024

LZeugirdor commented on Feb 11, 2026

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions