node js sql modules able to output json responses from an sql database

Question

i'm looking for node modules to connect with my postgresql database.

Also, in order to keep code good enough to understand and maintain, i need something more.

My research gave me a few options:

My main needs are:

To be able to either avoid query string concats or load external queries
Receive or automatically transform the query result into json (so my express controller can answer my angular frontend)
Avoid as much as possible any performance issue

I'll thank and take a good look on any recommendation, and will update this thread to share my findings.

Julián Duque · Accepted Answer · 2015-07-30 18:48:42Z

1

I can recommend for PostgreSQL BookShelf (http://bookshelfjs.org/), it's based on the Knex Query Builder (http://knexjs.org/)

answered Jul 30, 2015 at 18:48

Julián Duque

9,7771 gold badge23 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

thanks a lot, i'm using knex and the migrations thing to manage my postgre database. it's quite neat.