Switching from MySQL to PostgreSQL in default install

[Omeryl]

Any particular reason we're using Oracle's MySQL over better/nicer alternatives, like MariaDB?

[it33]

hi Omeryl, thanks for the question. We basically chose MySQL because of its popularity. It wasn't a value judgement, just using what people were most likely to find familiar.

[Omeryl]

Hey @it33, MariaDB is still MySQL, just completely open unlike Oracle's MySQL (it's actually a fork of MySQL maintained by the original developer of MySQL). It has major advantages over Oracle's MySQL.

https://mariadb.org/

[hauleth]

IMHO the nicest solution would be PostgreSQL

[ShawnMilo]

In many people's opinion's, PostgreSQL is a very good database, and MySQL is not, really. Also, very informative, short video of MySQL behaving unforgivably with its default configuration.

[it33]

@Omeryl, @hauleth, @ShawnMilo, I've added feature requests (http://www.mattermost.org/feature-requests/) for MariaDB and Postgres support at http://mattermost.uservoice.com/forums/306457-general/suggestions/8589295-support-for-mariadb and
http://mattermost.uservoice.com/forums/306457-general/suggestions/8589070-support-for-postgresql and made the first upvote on each.

Please consider joining the forum (one click with Twitter, Google or Facebook) to continue the discussion?

This is the third day of the open source project and your input as the earliest members of the community on this topic is highly appreciated.

Since these topics appear to be more feature requests than issues in the context of the project (http://www.mattermost.org/filing-issues/), I'm closing this thread so discussion can continue in the feature request forum.

[Omeryl]

Meh, I don't think a Zendesk sufficiently satisfies things like this. It's an open source project, the first thing people will see is the "Issues" portion of the repo more than likely. Why not properly tag issues? @it33

[it33]

@Omeryl It's a good question.

I think ideally for feature requests we'd want to offer the community a way to vote on, search through and browse trending feature requests similar to http://feedback.gitlab.com/forums/176466-general/filters/hot

GitHub Issues doesn't seem to support what we believe we'll need long term--and I agree Zendesk doesn't either, it's just what we were using for the video game business, and was familiar.

It's starting to break already and maybe we should go to Uservoice for this. I wasn't sure how high priority that work was.

You're making us think a lot this week, @Omeryl. Thank you, don't stop :)

[it33]

After more community discussion and a feature request filing, the core team will be changing from MySQL in the default install to PostgreSQL for the 0.6.0 release at the end of the month: http://mattermost.uservoice.com/forums/306457-general/suggestions/8589070-support-for-postgresql

MariaDB was also considered, but it didn't end up as the top community choice.

@Omeryl, we're also switching to using GitHub issues with proper tags. Thanks again for your feedback. It took us a week, but we're finding our way now.

[kamilion]

Bleh, postgresql instead of rethinkdb? Seriously, you guys even mention them on your blog!

http://www.mattermost.org/on-premises-open-source-slack-alternative/

That was the whole reason I CAME, cause I thought I'd get a nice new rethinkdb project!

Oh well. At least it's postgresql, can't really complain there. Anything but mysql.

Such a shame -- rethinkdb totally fits the mattermost model to a T.
(incidentally, looks like gorethink made it's 1.0.0 release! yay!)
https://github.com/dancannon/gorethink/releases/tag/v1.0.0
Changefeeds are the best thing to ever happen to databases.
http://rethinkdb.com/docs/changefeeds/javascript/
http://rethinkdb.com/api/javascript/changes/
Why would you ever need a separate redis? 💻 🔨

[sun4sun]

so, I'm can help with switching from MySQL to PostgreSQL.
also at this time can check possibilities about RethinkDB

[coreyhulen]

@alexsun thanks. there is already a pull request submitted for postgresql.

[coreyhulen]

postgres if fixed with #170