evansiroky

var fs = require('fs'),
    async = require('async'),
    csv = require('csv');
 
var input = fs.createReadStream(filename);
var parser = csv.parse({
  columns: true,
  relax: true
});
 

ssokolow

-- Reasonably efficient pagination without OFFSET
-- SQLite version (Adapted from MS SQL syntax)
-- Source: http://www.phpbuilder.com/board/showpost.php?p=10376515&postcount=6

SELECT foo, bar, baz, quux FROM table
 WHERE oid NOT IN ( SELECT oid FROM table
                    ORDER BY title ASC LIMIT 50 )
 ORDER BY title ASC LIMIT 10