Hacker News Reader

Comment by j2d3 | Hacker News Reader

"Because we’re in this transition period between PHP and Ruby, we couldn’t use PostgreSQL on Heroku because PHP doesn’t speak PostgreSQL."

sigh

View on HN

Wait, what am I missing here? http://php.net/pgsql

Yeah, I've used both MySQL and Postgres in the same app before (legacy transition/migration). There is no issue with Postgres in PHP, and it works just fine with, e.g., PDO.

Walker from Teespring here. Wanted to jump in and say I was also confused by this, and Evan is on a well-deserved vacation right now so he's not around to clarify.

This was a real-time interview, and I was the one who edited for grammar because Evan had already left. I'm assuming this didn't come out the way he intended it to. I can't imagine (though I could be wrong I suppose) he is under the impression Postgres doesn't work with PHP.

When he gets back I'll have him chime in!

Right on. I didn't imagine that anyone as evidently technically savvy as Evan didn't understand it -- I just wanted to put out the confirmation that PHP and Postgres (in the general case, maybe not at Heroku) work fine together for casual readers.

This limitation (of Heroku's?) is fairly interesting to me. I'm curious as to why (perhaps there just isn't enough demand for Postgres/PHP apps in their experience so they haven't developed support for it?).

I'm guessing that it might mean that Heroku's PHP runtime (or the common PHP buildpack, or however it works) doesn't come with a Postgres driver.

Yonas from Leanstack here. I also edited for grammar after the initial transcription and it looks like his full statement was inaudible. So *Eric was simply saying that Heroku Postgres does not support PHP (https://devcenter.heroku.com/articles/heroku-postgresql). I'll be making the corrections soon.

I don't usually carp about grammatical errors, but if you have any editorial sway, that article has one in the second word of the first sentence.

> Teespring let’s anyone easily create and sell t-shirts.

has a grocer's apostrophe on "let's". It should be "lets", sans apostrophe.

Got it, thanks. We'll have a better editorial process moving forward, sorry for the errors guys.

Are you sure? This repo suggests otherwise: https://github.com/kch/heroku-php-pg/blob/master/index.php

Reply on news.ycombinator.com