Streams instead of ORM.

README.md

Streams instead of ORM

Pros:

• Streams?
• More manual query control.
• Combine different transforms depending on use case.

Cons:

• Every dev has to have intimiate knowledge of schema
• Have to know all the information you will need, or have to assume you will need more than you know about (e.g. avatars).
• Have to know all the transforms needed at the point the data is queried for.
• SQL clumsy to work with in javascript (no heredocs or multi-line strings)

example.js

// ORM
app.models.users.find({
  status: 'active', 
  limit: 10, 
  order: 'name ASC', 
  populate: 'avatar'
}, function (err, users) {
  if (err) return next(err);
  app.sanitizeModels(users, req, function (err, users) {
    // Do Something with users.
  });
});

// STREAM
var sql = "SELECT users.*, files.url as avatar_url FROM users " +
          "LEFT JOIN files ON files.id = users.avatar_id" +
          "WHERE status = 'active' " + 
          "ORDER BY name ASC LIMIT 10";
var query = app.mysql.query(sql).stream()
              .pipe(formatters('users'))
              .pipe(sanitize('users', req));
// Do something with the stream?