Skeleton

[naazy]

• pgAdminIII
• postgres App i.e. psql (the need to connect to the SQL server on port 5432)
• Some basic CRUD commands e.g. create database/table
• Example (with focus on Hapi and pg node module)
• Screenshots

[des-des]

@naazy have you looked at sequelize?

[mantagen]

@naazy http://www.sitepoint.com/3-javascript-orms-you-might-not-know/ (don't know which js ORMs you would know if you didn't know any of these)

[naazy]

@des-des no I haven't! Would you recommend?

Sent from my iPhone

On 5 Mar 2016, at 13:12, Eoin McCarthy notifications@github.com wrote:

@naazy have you looked at sequelize?

— Reply to this email directly or view it on GitHub.

[nelsonic]

@des-des six-months-later, would you still recommend using sequelize...? or have you had time to formulate a "if I could start over..." insight you can share with us...?

[mantagen]

Good question

[des-des]

@nelsonic I am not sure a good orm for node exist :(. I would try hard to find an alternative to sequelise if I started a new project, its bloated and painful to use. That said, unless you are working on a very small project, I do not think handwriting all your queries and schema is a good idea, I feel like there should be an abstraction above sql to work with. Something that was not too complex / big but abstracted some sql stuff away would be perfect.

[des-des]

http://knexjs.org/ would be the first thing I looked into

[nelsonic]

@des-des I had a look at Knex the other day. Code seemed OK to me and Docs decent, but what screamed of "unmaintained" was:

• Not following Semver (so we will have to read code to know when a backward-incompatible change is made...)
• The other badges speak for themselves ... 😞

37 Open PRs at the time of writing going back 2 years. and reading through the features being added it's doing way too many things ... 😕

I'd be stoked to read your findings when you are able to investigate the available options! 👍

[nelsonic]

We've been using Ecto in the context of our Phoenix apps and pg with pg-escape in Node.js for an example of this see: https://github.com/nelsonic/time-mvp/blob/master/server/db.js#L46