5 ms·
I feel you - I recently started a node project on LevelDB and ultimately switched over to an SQL database. The difference though is I went for Postgres 9.3, whi
by twerquie 13y ago
I feel you - I recently started a node project on LevelDB and ultimately switched over to an SQL database. The difference though is I went for Postgres 9.3, which has incredible native JSON support, allowing you to slice parts of your JSON data out as a record set, join them against tables, as well as other crazy things like partial indexes on deeply nested JSON values which may or may not be present.
I really think Pg is starting to blow Mongo out of the water.
- hkarthik 13y agoAny suggestions on ORMs or npm packages to use with pg and node?
- sync 13y agoStars is a great ranking technique, e.g.http://www.node-modules.com/search?q=postgresql&u= http://www.node-modules.com/search?q=postgresql&u=
- dlau1 13y agoI'm using knex [0] which I am pretty happy with. There is also a higher level version built on top of it called bookshelf [1] 0 : https://github.com/tgriesser/knex https://github.com/tgriesser/knex 1 : https://github.com/tgriesser/bookshelf https://github.com/tgriesser/bookshelf
- twerquie 13y agoI'm a big fan of ORMs in other ecosystems (Rails and Django, for example), but in node I like to write more functional-style code, composing small modules into larger applications. For this, check out the fantastic node-postgres adapter from brianc as well as his node-sql package for authoring SQL statements. https://github.com/brianc/node-postgres https://github.com/brianc/node-postgres https://github.com/brianc/node-sql https://github.com/brianc/node-sql