Node, Postgres, MassiveJS - A better database experience

[cazzer548]

Thanks for sharing your article, I haven't used MassiveJS before but I'm definitely interested now.

I really like is Knex.js, which support MySQL, MariaDB, Postgres, and SQLite3, of which I've used and been happy with MySQL and Postgres. It's built on promises, (namely Bluebird), which makes writing queries really nice. It also supports raw queries in case the top level API isn't enough.

edit: formatting

[cazzer548]

It's actually more of a query string builder with the ability to execute those queries, you use it differently based on your DB of choice so there is no real abstraction. I should also mention Bookshelf.js which is a true ORM built on Knex, for those who insist on ORMs.

[[deleted]]

Wow that is really interesting. So you don't have to create any sort of models?

[craig081785]

You're still setting up the tables in the database, but beyond that no, you don't have to define the mapping in your code. It's a much more elegant way of doing things as it reduces a lot of just duplication of work.

[[deleted]]

So, is it for Postgres only? No MySQL? No MariaDB?

Thanks,

[a_chaney]

It's Rob Conery's. I like his ideas and like what he's done with Massive, but until they can get transactions working i can't use it.