Hacker News Reader

Comment by calinet6 | Hacker News Reader

Using a database should really not be a deal-breaker... you should evaluate it on other factors.

My gripe is that it appears tied to SQLite, and I can't use Postgres. Oh well, wasn't planning on using it anyway.

Shouldn't be tied to SQLite (the underlying query builder/orm support Postgres), it's just not "officially" supported yet.

So in theory putting in the correct connection config should allow you to use Postgres.

I find it odd that you feel put off by the single choice of database, while also arguing that users shouldn't mind being tied to databases in general. Surely using SQLite when your setup is better suited to PostgreSQL is a less harmful trade-off than the case where files would have been better suited to your system/requirements.

I suppose. I have never understood an aversion to databases in general (though I do understand the general concept that the filesystem is, in a sense, a perfectly fine database for many purposes).

I just like Postgres, that's all.

I haven't written node code before, so correct me if I'm wrong. The package.json file indicates MySQL as an optional [1] :

    "optionalDependencies": {
        "mysql": "2.0.0-alpha9"
    },

And this guide [2] seems to indicate that PG support is possible.

[1] https://github.com/TryGhost/Ghost/blob/master/package.json

[2] http://www.howtoinstallghost.com/how-to-install-ghost-on-her...

If you're a dev, forking Ghost and replacing the DB with something else isn't an insurmountable task.

Your prep work in isolating the database work may even be something the Ghost people themselves would be interested in merging, as it's just good design to do so (if they hadn't already).

Reply on news.ycombinator.com