convert point coordinate pair into wkb in javascript/node.js and insert into sqlite db for rendering in TileMill

point-wkt2wkb-sqlite.js

var sqlite3 = require('sqlite3')

var db = new sqlite3.Database('test.db');

var make_wkb_point = function(x,y) {
    var byteorder = 1;
    var len = 1 + 4 + 8*2 ;
    var wkb = new Buffer(len);
    wkb.fill(0);
    wkb[0] = byteorder;
    wkb.writeUInt8(1,1)
    wkb.writeDoubleLE(x,1+4)
    wkb.writeDoubleLE(y,1+4+8)
    return wkb;
}

var add_point = function(x,y,name) {
  var stmt = db.prepare("INSERT into \"point_table\" (id,geometry,name) values (?,?,?)");
  stmt.run(null,make_wkb_point(x,y),name);
  stmt.finalize();
}

db.serialize(function() {
  db.run("CREATE TABLE IF NOT EXISTS \"point_table\" (id INTEGER PRIMARY KEY AUTOINCREMENT, geometry BLOB, \"name\" varchar)");
  add_point(-122,48,'Seattle');
  add_point(-77,39,'DC');
  add_point(0,51,'London');
});

/cc @Vertice