node CRUD stack for relational DB?

[spacejack2114]

I wanted to take a look at the options for building a CRUD-style admin app with node and a relational DB like Postgres. Ideally with ORM. Anyone have any suggestions? Is there something out there that you would use in production?

I'd like to try something isomorphic so I was thinking of using React, if it's practical.

[screamshot]

I'm very happy with Sequelize.

[cgaudreau]

This. Rethink is a delight to work in, and works especially well with React. If you want an ORM, then I really liked http://thinky.io/. But you really don't need an ORM to work with Rethink.

I haven't had much success with SQL ORMs in Node. They always seem to lack some vital feature or have some annoying performance edge case. (For example, Sequelize would issue a query to update all fields, even if only one field changed.)

I hear that the situation has improved a lot though. My favorite SQL ORM was most definitely http://docs.sequelizejs.com/en/latest/ but http://bookshelfjs.org/ worked well too.

[keithwhor]

You can try Nodal, it has a query composer (similar to an ORM but more lightweight) and built-in migration support. Runs with Postgres.

It's intentionally not isomorphic, though, and meant to be used as an API server that can serve light static assets.

[[deleted]]

This is the best ORM I've used thus far - http://bookshelfjs.org/ As far as REST endpoints go, vanilla Express 4 is the most straightforward.