Core: postgres support

[huobazi]

ref: http://discuss.flarum.org/d/597-does-flarum-support-postgres

[dz0ny]

:+1:

[jirutka]

+1

[korya]

It would be great to see postgres officially supported.

[vjousse]

Just FYI, I'm having a look at the psql support. If you have any news on your side, don't hesitate to let me know.

[fdutheil]

I'd like to add a +1, but I'm not sure of the status of this feature request: is it already upstream and needs testing or is it cancelled after the WIP has stalled?

[vladipus]

I too would like to know if the pg support is there.

[vjousse]

I did some significant work here: https://github.com/flarum/core/pull/856 but was not able to finish it alone.
I suppose it's not a priority right now, but as far as I remember the modifications I made allowed the forum to be installed using postgres.

[phonicmouse]

Guys can you clarify something?
I know from here that you use Laravel's drivers, which support PostgreSQL. So if i try to install flarum simply using PostgreSQL instead of MySQL it just works or not?

[franzliedke]

@phonicmouse As mentioned in that forum thread, the driver needs to be made available in the installer. Once that is done, any problems that arise have to be fixed. Somebody needs to experiment with it and see how much fails. Do you want to give it a shot? :grinning:

[luceos]

From the top of my head, there are some incompatibility issues with either some (Gambit) queries and/or migrations. Either of these are specifically written against a MySQL database and need to be modified.

[phonicmouse]

@franzliedke I'll definitely do it. As soon as i have some spare time I'll work on it 😋
@luceos Well, after we locate them, we just have to make them cross-database, which shouldn't be too hard, but just a bit long, but i've never looked at the code, so...😭

[mkarnicki]

@phonicmouse

we just have to make them cross-database, which shouldn't be too hard

Note there was already an attempt to support Postgres (see above in the thread) and it didn't turn out so simple. Mostly because the integration has to be correct in all aspects from the Flarum perspective, so: easy for the users to choose/setup. In any case, I wish you the very best if you take this on :)! Quite a few folks are looking forward to Postgres support. Few of us have time to work on it though.

[phonicmouse]

@mkarnicki I will definitely have a look at that. And yeah, I think the main issue is just finding the time to work on this. As soon as I have some spare time I'll try to solve this.

[fr0der1c]

It has been for 4 years...

[stale[bot]]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. We do this to keep the amount of open issues to a manageable minimum.
In any case, thanks for taking an interest in this software and contributing by opening the issue in the first place!

[mkarnicki]

I still think this would be a valuable addition, esp. that Laravel makes it so easy to interchange database types one would use, so I'm leaving this comment here hoping the report is not killed by the stale bot and that it maybe receives some attention in the future. Cheers.

[stale[bot]]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. We do this to keep the amount of open issues to a manageable minimum.
In any case, thanks for taking an interest in this software and contributing by opening the issue in the first place!

[franzliedke]

After some discussion in the core team (a while ago)...

We changed our opinion and currently do not plan to tackle this as part of our roadmap. We will, of course, be open for / discuss community contributions for this feature - it was brought up from the community in the first place anyway.

So I am closing this issue to avoid appearing like we plan to work on this feature.

[luceos]

Even though this saddens me deeply. I think the motto "do one thing and do it well" is key here. Let's focus on getting Flarum working exceptionally well with MySQL.

[c33s]

i ask myself why so many people use database abstraction layers like doctrine or many parts from symfony and still develop mysql only code.

[tankerkiller125]

@c33s Often because those libraries and abstractions make working with databases much easier, but often very advanced things (for example search) requires using raw SQL which often is database specific. And since ALL host offer MySQL (including shared host) MySQL tends to win the argument for web apps looking for the largest use. Other databases are great for specific kinds of things (for example Gitlab has to use Postgres because of the database features it needs) but for something like Flarum it makes the most sense to focus on MySQL.

[luceos]

I'd like to point out that we are not entirely excluding alternative Eloquent-compatible database drivers for future versions. But we do for now to prevent any delays on releasing stable.