6 ms·

As someone that is in the middle of writing a nodejs thin API layer, working with express-resource, this looks really amazing to me. It looks like I can stop wo

As someone that is in the middle of writing a nodejs thin API layer, working with express-resource, this looks really amazing to me. It looks like I can stop worrying about writing middle thin-API code, and focus on front-end manipulation of a stable middle/backend However, the scale of this really worries me. I really like small tools (flask over django, knockoutjs over angular sometimes,etc) -- and this seems like a LOT to take in to a project, sort of hoping it all just works... Also, why is Postgres support not more prominently stated? It's there, but I had to search for it. And on that note, why is JSON stored in postgres as a varchar? why not use the postgres JSON type (compatibility reasons, maybe?)

rmgraham 12y ago
Postgres almost warrants its own non-generic ORM. That would actually be kinda cool.
- angersock 12y ago
  Hmm.... Especially exposing some of the things like intervals, the geographic features, and a lot of their other cool things. Yeah, I could live with that.
- hardwaresofton 12y ago
  If I understand your comment right, are you looking for something like this: http://bookshelfjs.org/ http://bookshelfjs.org/ I haven't done much work with a relational DB from nodejs (I've just used nosql databases that offered relational functionality -- i.e. rethinkdb), but this seems like as good a thing as any for ORM-y stuff with Postgres
  - woah 12y ago
    The backbone stuff in there kind of made me raise an eyebrow... not sure I really want it.
  - whatthemick 12y ago
    There's also Sequelize (http://sequelizejs.com/ http://sequelizejs.com/) which is increasing its focus on Postgres specific features.
enjoyjava 12y ago
Good catch. We support Postgresql, MS SQL Server, and SOAP too.
- hardwaresofton 12y ago
  Great! I'm actually considering using this in a new project right now - it is very very tempting to think that I could just use this, and have a middle-layer that I don't have to muck with... this would greatly speed up development, I do applaud the team for trying something so ambitious, could be huge

rmgraham 12y ago

Postgres almost warrants its own non-generic ORM. That would actually be kinda cool.

angersock 12y ago
Hmm.... Especially exposing some of the things like intervals, the geographic features, and a lot of their other cool things. Yeah, I could live with that.
hardwaresofton 12y ago
If I understand your comment right, are you looking for something like this: http://bookshelfjs.org/ http://bookshelfjs.org/ I haven't done much work with a relational DB from nodejs (I've just used nosql databases that offered relational functionality -- i.e. rethinkdb), but this seems like as good a thing as any for ORM-y stuff with Postgres
- woah 12y ago
  The backbone stuff in there kind of made me raise an eyebrow... not sure I really want it.
- whatthemick 12y ago
  There's also Sequelize (http://sequelizejs.com/ http://sequelizejs.com/) which is increasing its focus on Postgres specific features.

enjoyjava 12y ago

Good catch. We support Postgresql, MS SQL Server, and SOAP too.

hardwaresofton 12y ago
Great! I'm actually considering using this in a new project right now - it is very very tempting to think that I could just use this, and have a middle-layer that I don't have to muck with... this would greatly speed up development, I do applaud the team for trying something so ambitious, could be huge