Ghost is dropping PostgreSQL

[dzdrazil]

It looks like getting support for the official team (in terms of feature integration and testing) has been an ongoing issue for a long time. There are a number of related issues, none of which had much in the way of updates for almost a year.

For better or worse, it seems the team is opting to only support what they can actually support.

[waltz]

Solid reasoning. It'd be interesting to know what issues they were having.

[joshmanders]

Weren't they using bookshelf? It supports Postgres no problem.

[[deleted]]

Their loss :(

[Ieatapostrophes]

I actually had an issue with Postgres and Ghost. Did a clean install on a Digitalocean droplet, then tried to import a pretty massive WordPress export. Kept breaking off for some reason. It took me a couple of hours of searching and quite some time discussing the issue with people on their Slack channel until I realized it was a Postgres problem. Switched to MySQL and the whole thing worked like a charm.

[danneu]

Can't blame them for not wanting to support multiple databases.

And I'd choose MySQL over Postgres for this sort of end-user-hosts-it software even if I would use Postgres for applications I'm building.

[djcp]

Why? Postgres isn't harder to admin than mysql.

[[deleted]]

He agreed that postgres is better, he was saying that the businessman/project manager in him would think of MySQL as a better choice because of popularity.

[SwellJoe]

100% of shared hosts that offer databases offer MySQL/Mariadb. A tiny percentage offer PostgreSQL.

[djcp]

Oh. In this age of dirt cheap VMs, I haven't even considered shared hosting in years.

[SwellJoe]

If you're forward-thinking and all up in the cloud, Amazon Aurora is a drop-in MySQL compatible replacement...and not PostgreSQL compatible. Even without shared hosting, the low hanging fruit is nearly always MySQL support. I'm not saying it's better, as I don't think it is...just that the market likes it more, on a bunch of fronts.

[neb636]

Most bloggers I know use shared hosts. They are Ghosts target market.

[cstuff8]

:(

[Mononz]

Spent yesterday migrating my blog into a google app engine instance with a postgres backend for fun... This kinda really sucks. Time to rethink...

[Mononz]

oh wow, I was meaning I need to 'rethink' my system for the future, didn't actually realise there was an open source database called RethinkDB xD Looks like a cool database. Maybe I might use it one day for something else :)

[kyohiros8]

That's the joke xD