{"_id":"sqlite-fts","_rev":"21-df9763cc48ed3f221b47d54882b8d7b6","name":"sqlite-fts","description":"SQLite3 bindings for Node with FTS4 enabled","dist-tags":{"latest":"0.0.9"},"versions":{"0.0.1":{"name":"sqlite-fts","description":"SQLite3 bindings for Node with FTS4 enabled","version":"0.0.1","homepage":"http://github.com/quartzjer/node-sqlite-fts","author":{"name":"Jeremie Miller","email":"jeremie@jabber.org"},"contributors":[{"name":"Artem Kustikov"},{"name":"Eric Fredricksen"},{"name":"John Wright"},{"name":"Ryan Dahl"},{"name":"Orlando Vazquez","email":"ovazquez@gmail.com","url":"http://2wycked.net"}],"repository":{"type":"git","url":"git://github.com/quartzjer/node-sqlite-fts.git"},"main":"./sqlite-fts","engines":{"node":">=0.4.0"},"scripts":{"test":"./run-tests","preinstall":"node-waf configure build"},"licenses":[{"type":"BSD"}],"_npmUser":{"name":"quartzjer","email":"jeremie@jabber.org"},"_id":"sqlite-fts@0.0.1","dependencies":{},"devDependencies":{},"_engineSupported":true,"_npmVersion":"1.0.103","_nodeVersion":"v0.4.10","_defaultsLoaded":true,"dist":{"shasum":"623891a59cd1c0cef04c1025fb80d6ac1c31354e","tarball":"https://registry.npmjs.org/sqlite-fts/-/sqlite-fts-0.0.1.tgz","integrity":"sha512-wXhegrlZlpht+ctibccEa+nPv+f17YTwscUq0bZUyTL4VGQmOijm5QCZ8JMa6iGfCwwh+QJNofwNaVTnV8962g==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIBUc9HDdmLA57GYlaU3XjZXzA14r2aJLNbBPChaihS1rAiAUuuPodkuu7o3ZLfWsTmDJQEErB6GSjSI6WA263/gExw=="}]},"maintainers":[{"name":"quartzjer","email":"jeremie@jabber.org"}]},"0.0.2":{"name":"sqlite-fts","description":"SQLite3 bindings for Node with FTS4 enabled","version":"0.0.2","homepage":"http://github.com/quartzjer/node-sqlite-fts","author":{"name":"Jeremie Miller","email":"jeremie@jabber.org"},"contributors":[{"name":"Artem Kustikov"},{"name":"Eric Fredricksen"},{"name":"John Wright"},{"name":"Ryan Dahl"},{"name":"Orlando Vazquez","email":"ovazquez@gmail.com","url":"http://2wycked.net"}],"repository":{"type":"git","url":"git://github.com/quartzjer/node-sqlite-fts.git"},"main":"./sqlite-fts","engines":{"node":">=0.4.0"},"scripts":{"test":"./run-tests","preinstall":"node-waf configure build"},"licenses":[{"type":"BSD"}],"dependencies":{},"devDependencies":{},"_npmUser":{"name":"quartzjer","email":"jeremie@jabber.org"},"_id":"sqlite-fts@0.0.2","_engineSupported":true,"_npmVersion":"1.0.103","_nodeVersion":"v0.4.10","_defaultsLoaded":true,"dist":{"shasum":"af5043cb68f1968b3914bb675ddd7e3040f187bb","tarball":"https://registry.npmjs.org/sqlite-fts/-/sqlite-fts-0.0.2.tgz","integrity":"sha512-McwPPslKLgjZNyzzIZ+yU3EA/hQQZts+l/LFZDyEtOwcjOMrWSGg/IQuM/DwnpD8ZY2Pb7ugct7sgtV7yzuADw==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQCfpkKwxYGIIZeDD8kdQPGkHy6oSJ7ugTymuClwtr7H4QIhAMEg9lndH3zSaRlBNB1S/osOrNvNPx0qBxGNf91BnvCw"}]},"maintainers":[{"name":"quartzjer","email":"jeremie@jabber.org"}]},"0.0.3":{"name":"sqlite-fts","description":"SQLite3 bindings for Node with FTS4 enabled","version":"0.0.3","homepage":"http://github.com/quartzjer/node-sqlite-fts","author":{"name":"Jeremie Miller","email":"jeremie@jabber.org"},"contributors":[{"name":"Artem Kustikov"},{"name":"Eric Fredricksen"},{"name":"John Wright"},{"name":"Ryan Dahl"},{"name":"Orlando Vazquez","email":"ovazquez@gmail.com","url":"http://2wycked.net"}],"repository":{"type":"git","url":"git://github.com/quartzjer/node-sqlite-fts.git"},"main":"./sqlite-fts","engines":{"node":">=0.6.0"},"scripts":{"test":"./run-tests","preinstall":"node-waf configure build"},"licenses":[{"type":"BSD"}],"dependencies":{},"devDependencies":{},"_npmUser":{"name":"quartzjer","email":"jeremie@jabber.org"},"_id":"sqlite-fts@0.0.3","_engineSupported":true,"_npmVersion":"1.1.0-beta-4","_nodeVersion":"v0.6.6","_defaultsLoaded":true,"dist":{"shasum":"5bd89c3078f42264c5c03cadc3d0c4a3b9fc7f3e","tarball":"https://registry.npmjs.org/sqlite-fts/-/sqlite-fts-0.0.3.tgz","integrity":"sha512-EoTGQeyphbGaKenOKHPMZak0abku+WqgQLHkoWDJjeVHHz3ENVEzVjblQ6grn5TArSjcpqTFmWzPgN/zlCPgNw==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIEwZleAsq86emlBpZfrFzMbKUICcZcKnd70d+5TvL4cmAiAzWX2xVaX96/Tt3eD3UngzUwX8a+MYiVgZq0APh9WwTg=="}]},"readme":"# NAME\n\nnode-sqlite - Asynchronous SQLite3 driver for Node.js\n\nSQLite calls block, so to work around this, synchronous calls happen within\nNode's libeio thread-pool, in a similar manner to how POSIX calls are\ncurrently made.\n\n# SYNOPSIS\n\n## High-level Driver\n\n    var sys    = require('sys'),\n        sqlite = require('sqlite');\n\n    var db = new sqlite.Database();\n\n    // open the database for reading if file exists\n    // create new database file if not\n\n    db.open(\"aquateen.db\", function (error) {\n      if (error) {\n          console.log(\"Tonight. You.\"));\n          throw error;\n      }\n      db.execute\n        ( \"INSERT INTO aqua_teens (name) VALUES (?)\"\n        , ['meaty meaty moo']\n        , function (error, rows) {\n            if (error) throw error;\n            console.log(\"Aqua teen added.\");\n          }\n        );\n      var sql = 'SELECT name FROM dudes WHERE type = ? AND age > ?';\n\n      db.prepare(sql, function (error, statement) {\n        if (error) throw error;\n\n        // Fill in the placeholders\n        statement.bindArray(['milkshake', 30], function () {\n\n          statement.fetchAll(function (error, rows) {\n            // ...\n            statement.finalize(function (error) {\n              console.log(\"All done!\");\n            });\n          });\n        });\n      });\n    });\n\n# API\n\n## Database Objects\n\nTo create a new database object:\n    var sqlite = require('sqlite');\n\n    var db = sqlite.Database();\n\n### database.open(filename, function (error) {})\n\nOpen a database handle to the database at the specified filename. If the file\ndoes not exist the bindings will attempt to create it. The callback takes no\narguments.\n\nA filename of \":memory:\" may be used to create an in-memory database.\n\n### database.close(function (error) {})\n\nClose the database handle.\n\n### database.execute(sql[, bindings], function (error, rows) {})\n\nExecute a SQL query, `sql` with optional bindings `bindings` on the currently\nopened database. The callback will be executed once with all the rows returned\nfor the query. This is much faster than `database.query` since there are less roundtrips into the thread-pool.\n\n### database.query(sql, [bindings,] function (error, row) {})\n\nExecute a SQL query, `sql`, with optional bindings `bindings` on the currently\nopened database. The callback will be executed once per row returned, plus\nonce more with row set to undefined to indicate end of results.\n\n### database.executeScript(SQL, function (error) {});\n\n    db.executeScript\n      (   \"CREATE TABLE table1 (id, name);\"\n        + \"CREATE TABLE table2 (id, age);\"\n        + \"INSERT INTO table1 (1, 'Mister Shake');\"\n        + \"INSER INTO table2 (1, 34);\"\n      , function (error) {\n          if (error) throw error;\n          // ...\n        });\n\nExecute multiple semi-colon separated SQL statements. Statements must take no\nplaceholders. Each statement will be executed with a single step() and then\nreset. This is ideally suited to executing multiple DDL statements.\n\n### database.prepare(SQL, [options,] function (error, statement) {})\n\nCreate a prepared statement from an SQL string. Prepared statements can be\nused used to iterate over results and to avoid compiling SQL each time a query\nis performed.\n\nOptions:\n\n- lastInsertRowID: boolean, default false.\n    If true, when this statement is step()'d over, the context object (this) in\n    the callback will contain a lastInsertRowID member with the ID of the last\n    inserted row.\n\n- affectedRows: boolean, default false.\n    If true, when this statement is step()'d over, the context object (this) in\n    the callback will contain an affectedRows member with the number of\n    affected rows for the last step.\n\n## Statement Objects\n\n### statement.bindArray(array, function (error) {})\n\n    statement.bindArray([1, 'robots', 4.20], callback)\n\nBind array items to place-holder values (? or $foo) in statement.\n\n### statement.bindObject(object, function (error) {})\n\n    statement.bindObject({ $name: 'meatwad',\n                           $occupation: 'Former detective' }, callback)\n\nBind object properties to named place-holder values ($foo, $bar, $baz) in\nstatement.\n\n### statement.bind(position, value, function (error) {})\n\n    statement.bind(1, \"tango\", function (error) {})\n\nBind a value to a place-holder position. Because binding place-holders is done\nby position (not index), the first place-holder is at position 1, second at\nplace-holder position 2, etc.\n\n### statement.clearBindings()\n\nImmediately clear the bindings from the statement. There is no callback.\n\n### statement.step(function (error, row) {})\n\nFetch one row from a prepared statement and hand it off to a callback. If\nthere are no more rows to be fetched, row will be undefined. Rows are\nrepresented as objects with properties named after the respective columns.\n\n### statement.fetchAll(function (error, rows) {})\n\nFetch all rows in statement and pass them to the callback as an array of\nobjects, each object representing one row.\n\n### statement.reset()\n\nImmediately reset a statement object back to it's initial state, ready to be\nstep() or fetchAll()'d again.\n\n### statement.finalize(function (error) {})\n\nFree SQLite objects associated with this statement and mark it for garbage\ncollection.\n\n## Supported Types\n\nAt the moment, the supported types are TEXT, NUMBER, FLOAT and NULL.\n\n# BUILDING\n\nTo obtain and build the bindings:\n\n    git clone http://github.com/orlandov/node-sqlite.git\n    cd node-sqlite\n    node-waf configure build\n\n# TESTS\n\nRunning the unit tests could not be easier. Simply:\n\n    git submodule update --init\n    ./run-tests\n\n# SEE ALSO\n\n* http://sqlite.org/docs.html\n* http://github.com/grumdrig/node-sqlite/\n\n# AUTHORS\n\nOrlando Vazquez [ovazquez@gmail.com]\n\nRyan Dahl [ry@tinyclouds.org]\n\n# THANKS\n\nMany thanks to Eric Fredricksen for his synchronous driver on which this\ndriver was originally based.\n\n* http://github.com/grumdrig/node-sqlite/\n* http://grumdrig.com/node-sqlite/\n\n# LICENSE\n\nnode-sqlite is BSD licensed.\n\n(c) 2010 Orlando Vazquez\n","maintainers":[{"name":"quartzjer","email":"jeremie@jabber.org"}]},"0.0.4":{"name":"sqlite-fts","description":"SQLite3 bindings for Node with FTS4 enabled","version":"0.0.4","homepage":"http://github.com/quartzjer/node-sqlite-fts","author":{"name":"Jeremie Miller","email":"jeremie@jabber.org"},"contributors":[{"name":"Artem Kustikov"},{"name":"Eric Fredricksen"},{"name":"John Wright"},{"name":"Ryan Dahl"},{"name":"Orlando Vazquez","email":"ovazquez@gmail.com","url":"http://2wycked.net"}],"repository":{"type":"git","url":"git://github.com/quartzjer/node-sqlite-fts.git"},"main":"./sqlite-fts","engines":{"node":">=0.6.0"},"scripts":{"test":"./run-tests","preinstall":"node-waf configure build"},"licenses":[{"type":"BSD"}],"dependencies":{"extend":"1.0.0"},"devDependencies":{},"_npmUser":{"name":"quartzjer","email":"jeremie@jabber.org"},"_id":"sqlite-fts@0.0.4","_engineSupported":true,"_npmVersion":"1.1.0-beta-10","_nodeVersion":"v0.6.7","_defaultsLoaded":true,"dist":{"shasum":"33520035967bf63be4388b2e5c0bd73a84ed91fd","tarball":"https://registry.npmjs.org/sqlite-fts/-/sqlite-fts-0.0.4.tgz","integrity":"sha512-iQjHeJio5/Oiw0f7jtZB1qBGvR+AGfJ/EVChj05XYlKM/lviZzeAnKDG4cNEg4K+wwW34kQtIrBIf3gdK0gupQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIGcpphL4NVFElZcLOEEOxxEh+cTMZPr2sR/u+FUBSOEzAiB+LeKHo5vr0jNEPdojP8xti9Mcj1mmH+rrULCBAJ/grA=="}]},"readme":"# NAME\n\nnode-sqlite - Asynchronous SQLite3 driver for Node.js\n\nSQLite calls block, so to work around this, synchronous calls happen within\nNode's libeio thread-pool, in a similar manner to how POSIX calls are\ncurrently made.\n\n# SYNOPSIS\n\n## High-level Driver\n\n    var sys    = require('sys'),\n        sqlite = require('sqlite');\n\n    var db = new sqlite.Database();\n\n    // open the database for reading if file exists\n    // create new database file if not\n\n    db.open(\"aquateen.db\", function (error) {\n      if (error) {\n          console.log(\"Tonight. You.\"));\n          throw error;\n      }\n      db.execute\n        ( \"INSERT INTO aqua_teens (name) VALUES (?)\"\n        , ['meaty meaty moo']\n        , function (error, rows) {\n            if (error) throw error;\n            console.log(\"Aqua teen added.\");\n          }\n        );\n      var sql = 'SELECT name FROM dudes WHERE type = ? AND age > ?';\n\n      db.prepare(sql, function (error, statement) {\n        if (error) throw error;\n\n        // Fill in the placeholders\n        statement.bindArray(['milkshake', 30], function () {\n\n          statement.fetchAll(function (error, rows) {\n            // ...\n            statement.finalize(function (error) {\n              console.log(\"All done!\");\n            });\n          });\n        });\n      });\n    });\n\n# API\n\n## Database Objects\n\nTo create a new database object:\n    var sqlite = require('sqlite');\n\n    var db = sqlite.Database();\n\n### database.open(filename, function (error) {})\n\nOpen a database handle to the database at the specified filename. If the file\ndoes not exist the bindings will attempt to create it. The callback takes no\narguments.\n\nA filename of \":memory:\" may be used to create an in-memory database.\n\n### database.close(function (error) {})\n\nClose the database handle.\n\n### database.execute(sql[, bindings], function (error, rows) {})\n\nExecute a SQL query, `sql` with optional bindings `bindings` on the currently\nopened database. The callback will be executed once with all the rows returned\nfor the query. This is much faster than `database.query` since there are less roundtrips into the thread-pool.\n\n### database.query(sql, [bindings,] function (error, row) {})\n\nExecute a SQL query, `sql`, with optional bindings `bindings` on the currently\nopened database. The callback will be executed once per row returned, plus\nonce more with row set to undefined to indicate end of results.\n\n### database.executeScript(SQL, function (error) {});\n\n    db.executeScript\n      (   \"CREATE TABLE table1 (id, name);\"\n        + \"CREATE TABLE table2 (id, age);\"\n        + \"INSERT INTO table1 (1, 'Mister Shake');\"\n        + \"INSER INTO table2 (1, 34);\"\n      , function (error) {\n          if (error) throw error;\n          // ...\n        });\n\nExecute multiple semi-colon separated SQL statements. Statements must take no\nplaceholders. Each statement will be executed with a single step() and then\nreset. This is ideally suited to executing multiple DDL statements.\n\n### database.prepare(SQL, [options,] function (error, statement) {})\n\nCreate a prepared statement from an SQL string. Prepared statements can be\nused used to iterate over results and to avoid compiling SQL each time a query\nis performed.\n\nOptions:\n\n- lastInsertRowID: boolean, default false.\n    If true, when this statement is step()'d over, the context object (this) in\n    the callback will contain a lastInsertRowID member with the ID of the last\n    inserted row.\n\n- affectedRows: boolean, default false.\n    If true, when this statement is step()'d over, the context object (this) in\n    the callback will contain an affectedRows member with the number of\n    affected rows for the last step.\n\n## Statement Objects\n\n### statement.bindArray(array, function (error) {})\n\n    statement.bindArray([1, 'robots', 4.20], callback)\n\nBind array items to place-holder values (? or $foo) in statement.\n\n### statement.bindObject(object, function (error) {})\n\n    statement.bindObject({ $name: 'meatwad',\n                           $occupation: 'Former detective' }, callback)\n\nBind object properties to named place-holder values ($foo, $bar, $baz) in\nstatement.\n\n### statement.bind(position, value, function (error) {})\n\n    statement.bind(1, \"tango\", function (error) {})\n\nBind a value to a place-holder position. Because binding place-holders is done\nby position (not index), the first place-holder is at position 1, second at\nplace-holder position 2, etc.\n\n### statement.clearBindings()\n\nImmediately clear the bindings from the statement. There is no callback.\n\n### statement.step(function (error, row) {})\n\nFetch one row from a prepared statement and hand it off to a callback. If\nthere are no more rows to be fetched, row will be undefined. Rows are\nrepresented as objects with properties named after the respective columns.\n\n### statement.fetchAll(function (error, rows) {})\n\nFetch all rows in statement and pass them to the callback as an array of\nobjects, each object representing one row.\n\n### statement.reset()\n\nImmediately reset a statement object back to it's initial state, ready to be\nstep() or fetchAll()'d again.\n\n### statement.finalize(function (error) {})\n\nFree SQLite objects associated with this statement and mark it for garbage\ncollection.\n\n## Supported Types\n\nAt the moment, the supported types are TEXT, NUMBER, FLOAT and NULL.\n\n# BUILDING\n\nTo obtain and build the bindings:\n\n    git clone http://github.com/orlandov/node-sqlite.git\n    cd node-sqlite\n    node-waf configure build\n\n# TESTS\n\nRunning the unit tests could not be easier. Simply:\n\n    git submodule update --init\n    ./run-tests\n\n# SEE ALSO\n\n* http://sqlite.org/docs.html\n* http://github.com/grumdrig/node-sqlite/\n\n# AUTHORS\n\nOrlando Vazquez [ovazquez@gmail.com]\n\nRyan Dahl [ry@tinyclouds.org]\n\n# THANKS\n\nMany thanks to Eric Fredricksen for his synchronous driver on which this\ndriver was originally based.\n\n* http://github.com/grumdrig/node-sqlite/\n* http://grumdrig.com/node-sqlite/\n\n# LICENSE\n\nnode-sqlite is BSD licensed.\n\n(c) 2010 Orlando Vazquez\n","maintainers":[{"name":"quartzjer","email":"jeremie@jabber.org"}]},"0.0.5":{"name":"sqlite-fts","description":"SQLite3 bindings for Node with FTS4 enabled","version":"0.0.5","homepage":"http://github.com/quartzjer/node-sqlite-fts","author":{"name":"Jeremie Miller","email":"jeremie@jabber.org"},"contributors":[{"name":"Artem Kustikov"},{"name":"Eric Fredricksen"},{"name":"John Wright"},{"name":"Ryan Dahl"},{"name":"Orlando Vazquez","email":"ovazquez@gmail.com","url":"http://2wycked.net"}],"repository":{"type":"git","url":"git://github.com/quartzjer/node-sqlite-fts.git"},"main":"./sqlite-fts","engines":{"node":">=0.6.0"},"scripts":{"test":"./run-tests","preinstall":"node-waf configure build"},"licenses":[{"type":"BSD"}],"dependencies":{"extend":"1.0.0"},"devDependencies":{},"_npmUser":{"name":"quartzjer","email":"jeremie@jabber.org"},"_id":"sqlite-fts@0.0.5","_engineSupported":true,"_npmVersion":"1.1.0-beta-10","_nodeVersion":"v0.6.7","_defaultsLoaded":true,"dist":{"shasum":"2c4f8c1e8d73605b683d6f6dbe9096d9ead02965","tarball":"https://registry.npmjs.org/sqlite-fts/-/sqlite-fts-0.0.5.tgz","integrity":"sha512-LfwLkpozHlzbJBEDnh4HTCt138P7sWXb6JpxZPVf7onIKUH2zeCdU0jCL561V95yul9Sb9DR8XsuuudCBlgzNA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIDkmcDEu/tjiymLtlBbzknO0AfscTHnIRk9L90SW+4QJAiEAtmAUZDOFcQQXAyi6WS1zw+sbkwgqjlanqQ2qrs5dhDg="}]},"readme":"# NAME\n\nnode-sqlite - Asynchronous SQLite3 driver for Node.js\n\nSQLite calls block, so to work around this, synchronous calls happen within\nNode's libeio thread-pool, in a similar manner to how POSIX calls are\ncurrently made.\n\n# SYNOPSIS\n\n## High-level Driver\n\n    var sys    = require('sys'),\n        sqlite = require('sqlite');\n\n    var db = new sqlite.Database();\n\n    // open the database for reading if file exists\n    // create new database file if not\n\n    db.open(\"aquateen.db\", function (error) {\n      if (error) {\n          console.log(\"Tonight. You.\"));\n          throw error;\n      }\n      db.execute\n        ( \"INSERT INTO aqua_teens (name) VALUES (?)\"\n        , ['meaty meaty moo']\n        , function (error, rows) {\n            if (error) throw error;\n            console.log(\"Aqua teen added.\");\n          }\n        );\n      var sql = 'SELECT name FROM dudes WHERE type = ? AND age > ?';\n\n      db.prepare(sql, function (error, statement) {\n        if (error) throw error;\n\n        // Fill in the placeholders\n        statement.bindArray(['milkshake', 30], function () {\n\n          statement.fetchAll(function (error, rows) {\n            // ...\n            statement.finalize(function (error) {\n              console.log(\"All done!\");\n            });\n          });\n        });\n      });\n    });\n\n# API\n\n## Database Objects\n\nTo create a new database object:\n    var sqlite = require('sqlite');\n\n    var db = sqlite.Database();\n\n### database.open(filename, function (error) {})\n\nOpen a database handle to the database at the specified filename. If the file\ndoes not exist the bindings will attempt to create it. The callback takes no\narguments.\n\nA filename of \":memory:\" may be used to create an in-memory database.\n\n### database.close(function (error) {})\n\nClose the database handle.\n\n### database.execute(sql[, bindings], function (error, rows) {})\n\nExecute a SQL query, `sql` with optional bindings `bindings` on the currently\nopened database. The callback will be executed once with all the rows returned\nfor the query. This is much faster than `database.query` since there are less roundtrips into the thread-pool.\n\n### database.query(sql, [bindings,] function (error, row) {})\n\nExecute a SQL query, `sql`, with optional bindings `bindings` on the currently\nopened database. The callback will be executed once per row returned, plus\nonce more with row set to undefined to indicate end of results.\n\n### database.executeScript(SQL, function (error) {});\n\n    db.executeScript\n      (   \"CREATE TABLE table1 (id, name);\"\n        + \"CREATE TABLE table2 (id, age);\"\n        + \"INSERT INTO table1 (1, 'Mister Shake');\"\n        + \"INSER INTO table2 (1, 34);\"\n      , function (error) {\n          if (error) throw error;\n          // ...\n        });\n\nExecute multiple semi-colon separated SQL statements. Statements must take no\nplaceholders. Each statement will be executed with a single step() and then\nreset. This is ideally suited to executing multiple DDL statements.\n\n### database.prepare(SQL, [options,] function (error, statement) {})\n\nCreate a prepared statement from an SQL string. Prepared statements can be\nused used to iterate over results and to avoid compiling SQL each time a query\nis performed.\n\nOptions:\n\n- lastInsertRowID: boolean, default false.\n    If true, when this statement is step()'d over, the context object (this) in\n    the callback will contain a lastInsertRowID member with the ID of the last\n    inserted row.\n\n- affectedRows: boolean, default false.\n    If true, when this statement is step()'d over, the context object (this) in\n    the callback will contain an affectedRows member with the number of\n    affected rows for the last step.\n\n## Statement Objects\n\n### statement.bindArray(array, function (error) {})\n\n    statement.bindArray([1, 'robots', 4.20], callback)\n\nBind array items to place-holder values (? or $foo) in statement.\n\n### statement.bindObject(object, function (error) {})\n\n    statement.bindObject({ $name: 'meatwad',\n                           $occupation: 'Former detective' }, callback)\n\nBind object properties to named place-holder values ($foo, $bar, $baz) in\nstatement.\n\n### statement.bind(position, value, function (error) {})\n\n    statement.bind(1, \"tango\", function (error) {})\n\nBind a value to a place-holder position. Because binding place-holders is done\nby position (not index), the first place-holder is at position 1, second at\nplace-holder position 2, etc.\n\n### statement.clearBindings()\n\nImmediately clear the bindings from the statement. There is no callback.\n\n### statement.step(function (error, row) {})\n\nFetch one row from a prepared statement and hand it off to a callback. If\nthere are no more rows to be fetched, row will be undefined. Rows are\nrepresented as objects with properties named after the respective columns.\n\n### statement.fetchAll(function (error, rows) {})\n\nFetch all rows in statement and pass them to the callback as an array of\nobjects, each object representing one row.\n\n### statement.reset()\n\nImmediately reset a statement object back to it's initial state, ready to be\nstep() or fetchAll()'d again.\n\n### statement.finalize(function (error) {})\n\nFree SQLite objects associated with this statement and mark it for garbage\ncollection.\n\n## Supported Types\n\nAt the moment, the supported types are TEXT, NUMBER, FLOAT and NULL.\n\n# BUILDING\n\nTo obtain and build the bindings:\n\n    git clone http://github.com/orlandov/node-sqlite.git\n    cd node-sqlite\n    node-waf configure build\n\n# TESTS\n\nRunning the unit tests could not be easier. Simply:\n\n    git submodule update --init\n    ./run-tests\n\n# SEE ALSO\n\n* http://sqlite.org/docs.html\n* http://github.com/grumdrig/node-sqlite/\n\n# AUTHORS\n\nOrlando Vazquez [ovazquez@gmail.com]\n\nRyan Dahl [ry@tinyclouds.org]\n\n# THANKS\n\nMany thanks to Eric Fredricksen for his synchronous driver on which this\ndriver was originally based.\n\n* http://github.com/grumdrig/node-sqlite/\n* http://grumdrig.com/node-sqlite/\n\n# LICENSE\n\nnode-sqlite is BSD licensed.\n\n(c) 2010 Orlando Vazquez\n","maintainers":[{"name":"quartzjer","email":"jeremie@jabber.org"}]},"0.0.6":{"name":"sqlite-fts","description":"SQLite3 bindings for Node with FTS4 enabled","version":"0.0.6","homepage":"http://github.com/quartzjer/node-sqlite-fts","author":{"name":"Jeremie Miller","email":"jeremie@jabber.org"},"contributors":[{"name":"Artem Kustikov"},{"name":"Eric Fredricksen"},{"name":"John Wright"},{"name":"Ryan Dahl"},{"name":"Orlando Vazquez","email":"ovazquez@gmail.com","url":"http://2wycked.net"}],"repository":{"type":"git","url":"git://github.com/quartzjer/node-sqlite-fts.git"},"main":"./sqlite-fts","engines":{"node":">=0.6.0"},"scripts":{"test":"./run-tests","preinstall":"node-waf configure build"},"licenses":[{"type":"BSD"}],"dependencies":{"extend":"1.0.0"},"devDependencies":{},"optionalDependencies":{},"_npmUser":{"name":"quartzjer","email":"jeremie@jabber.org"},"_id":"sqlite-fts@0.0.6","_engineSupported":true,"_npmVersion":"1.1.0-3","_nodeVersion":"v0.6.10","_defaultsLoaded":true,"dist":{"shasum":"c22d57c45368c9904b471bfcfc3b668e32120dfc","tarball":"https://registry.npmjs.org/sqlite-fts/-/sqlite-fts-0.0.6.tgz","integrity":"sha512-ScTKVCiDHLbmgrGC+tVExTCYIXQgyVaXb7Ux2Mry+GnOvewfn4yZh4zfE1zvw0FMxsooayRkTG+xvyDqfOM01A==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQDqA6jA26aRqEEJd27TDgZ6XS9HZPsTwT9R5S+pNfdxbwIhAOm7UZltGIQmeLvo6p4iUZinvtEGKWh2C3/+uxJaXlI6"}]},"readme":"# NAME\n\nnode-sqlite - Asynchronous SQLite3 driver for Node.js\n\nSQLite calls block, so to work around this, synchronous calls happen within\nNode's libeio thread-pool, in a similar manner to how POSIX calls are\ncurrently made.\n\n# SYNOPSIS\n\n## High-level Driver\n\n    var sys    = require('sys'),\n        sqlite = require('sqlite');\n\n    var db = new sqlite.Database();\n\n    // open the database for reading if file exists\n    // create new database file if not\n\n    db.open(\"aquateen.db\", function (error) {\n      if (error) {\n          console.log(\"Tonight. You.\"));\n          throw error;\n      }\n      db.execute\n        ( \"INSERT INTO aqua_teens (name) VALUES (?)\"\n        , ['meaty meaty moo']\n        , function (error, rows) {\n            if (error) throw error;\n            console.log(\"Aqua teen added.\");\n          }\n        );\n      var sql = 'SELECT name FROM dudes WHERE type = ? AND age > ?';\n\n      db.prepare(sql, function (error, statement) {\n        if (error) throw error;\n\n        // Fill in the placeholders\n        statement.bindArray(['milkshake', 30], function () {\n\n          statement.fetchAll(function (error, rows) {\n            // ...\n            statement.finalize(function (error) {\n              console.log(\"All done!\");\n            });\n          });\n        });\n      });\n    });\n\n# API\n\n## Database Objects\n\nTo create a new database object:\n    var sqlite = require('sqlite');\n\n    var db = sqlite.Database();\n\n### database.open(filename, function (error) {})\n\nOpen a database handle to the database at the specified filename. If the file\ndoes not exist the bindings will attempt to create it. The callback takes no\narguments.\n\nA filename of \":memory:\" may be used to create an in-memory database.\n\n### database.close(function (error) {})\n\nClose the database handle.\n\n### database.execute(sql[, bindings], function (error, rows) {})\n\nExecute a SQL query, `sql` with optional bindings `bindings` on the currently\nopened database. The callback will be executed once with all the rows returned\nfor the query. This is much faster than `database.query` since there are less roundtrips into the thread-pool.\n\n### database.query(sql, [bindings,] function (error, row) {})\n\nExecute a SQL query, `sql`, with optional bindings `bindings` on the currently\nopened database. The callback will be executed once per row returned, plus\nonce more with row set to undefined to indicate end of results.\n\n### database.executeScript(SQL, function (error) {});\n\n    db.executeScript\n      (   \"CREATE TABLE table1 (id, name);\"\n        + \"CREATE TABLE table2 (id, age);\"\n        + \"INSERT INTO table1 (1, 'Mister Shake');\"\n        + \"INSER INTO table2 (1, 34);\"\n      , function (error) {\n          if (error) throw error;\n          // ...\n        });\n\nExecute multiple semi-colon separated SQL statements. Statements must take no\nplaceholders. Each statement will be executed with a single step() and then\nreset. This is ideally suited to executing multiple DDL statements.\n\n### database.prepare(SQL, [options,] function (error, statement) {})\n\nCreate a prepared statement from an SQL string. Prepared statements can be\nused used to iterate over results and to avoid compiling SQL each time a query\nis performed.\n\nOptions:\n\n- lastInsertRowID: boolean, default false.\n    If true, when this statement is step()'d over, the context object (this) in\n    the callback will contain a lastInsertRowID member with the ID of the last\n    inserted row.\n\n- affectedRows: boolean, default false.\n    If true, when this statement is step()'d over, the context object (this) in\n    the callback will contain an affectedRows member with the number of\n    affected rows for the last step.\n\n## Statement Objects\n\n### statement.bindArray(array, function (error) {})\n\n    statement.bindArray([1, 'robots', 4.20], callback)\n\nBind array items to place-holder values (? or $foo) in statement.\n\n### statement.bindObject(object, function (error) {})\n\n    statement.bindObject({ $name: 'meatwad',\n                           $occupation: 'Former detective' }, callback)\n\nBind object properties to named place-holder values ($foo, $bar, $baz) in\nstatement.\n\n### statement.bind(position, value, function (error) {})\n\n    statement.bind(1, \"tango\", function (error) {})\n\nBind a value to a place-holder position. Because binding place-holders is done\nby position (not index), the first place-holder is at position 1, second at\nplace-holder position 2, etc.\n\n### statement.clearBindings()\n\nImmediately clear the bindings from the statement. There is no callback.\n\n### statement.step(function (error, row) {})\n\nFetch one row from a prepared statement and hand it off to a callback. If\nthere are no more rows to be fetched, row will be undefined. Rows are\nrepresented as objects with properties named after the respective columns.\n\n### statement.fetchAll(function (error, rows) {})\n\nFetch all rows in statement and pass them to the callback as an array of\nobjects, each object representing one row.\n\n### statement.reset()\n\nImmediately reset a statement object back to it's initial state, ready to be\nstep() or fetchAll()'d again.\n\n### statement.finalize(function (error) {})\n\nFree SQLite objects associated with this statement and mark it for garbage\ncollection.\n\n## Supported Types\n\nAt the moment, the supported types are TEXT, NUMBER, FLOAT and NULL.\n\n# BUILDING\n\nTo obtain and build the bindings:\n\n    git clone http://github.com/orlandov/node-sqlite.git\n    cd node-sqlite\n    node-waf configure build\n\n# TESTS\n\nRunning the unit tests could not be easier. Simply:\n\n    git submodule update --init\n    ./run-tests\n\n# SEE ALSO\n\n* http://sqlite.org/docs.html\n* http://github.com/grumdrig/node-sqlite/\n\n# AUTHORS\n\nOrlando Vazquez [ovazquez@gmail.com]\n\nRyan Dahl [ry@tinyclouds.org]\n\n# THANKS\n\nMany thanks to Eric Fredricksen for his synchronous driver on which this\ndriver was originally based.\n\n* http://github.com/grumdrig/node-sqlite/\n* http://grumdrig.com/node-sqlite/\n\n# LICENSE\n\nnode-sqlite is BSD licensed.\n\n(c) 2010 Orlando Vazquez\n","maintainers":[{"name":"quartzjer","email":"jeremie@jabber.org"}]},"0.0.7":{"name":"sqlite-fts","description":"SQLite3 bindings for Node with FTS4 enabled","version":"0.0.7","homepage":"http://github.com/quartzjer/node-sqlite-fts","author":{"name":"Jeremie Miller","email":"jeremie@jabber.org"},"contributors":[{"name":"Artem Kustikov"},{"name":"Eric Fredricksen"},{"name":"John Wright"},{"name":"Ryan Dahl"},{"name":"Orlando Vazquez","email":"ovazquez@gmail.com","url":"http://2wycked.net"}],"repository":{"type":"git","url":"git://github.com/quartzjer/node-sqlite-fts.git"},"main":"./sqlite-fts","engines":{"node":">=0.6.0"},"scripts":{"test":"./run-tests","preinstall":"node-waf configure build"},"licenses":[{"type":"BSD"}],"dependencies":{"extend":"1.0.0"},"devDependencies":{},"optionalDependencies":{},"_npmUser":{"name":"quartzjer","email":"jeremie@jabber.org"},"_id":"sqlite-fts@0.0.7","_engineSupported":true,"_npmVersion":"1.1.0-3","_nodeVersion":"v0.6.10","_defaultsLoaded":true,"dist":{"shasum":"eafa4acf805fcd6eaa690306447d7bd35f484697","tarball":"https://registry.npmjs.org/sqlite-fts/-/sqlite-fts-0.0.7.tgz","integrity":"sha512-rN0WccE8FRmWy477UqMMGrznMkoxVv1xQb9jAlOgIwkGfjWAiygTnw3NPoY2SIjAE9JJ0jiB+rtCZnJdAaCLXA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQDXerQB08xBXtceQcnFZsqiafh05U7izEGhhrOtG9p8XAIgWmpN/xRZISDKZF2gztrkO5LOjUHsj7dY9mJXMy5GHtQ="}]},"readme":"# NAME\n\nnode-sqlite - Asynchronous SQLite3 driver for Node.js\n\nSQLite calls block, so to work around this, synchronous calls happen within\nNode's libeio thread-pool, in a similar manner to how POSIX calls are\ncurrently made.\n\n# SYNOPSIS\n\n## High-level Driver\n\n    var sys    = require('sys'),\n        sqlite = require('sqlite');\n\n    var db = new sqlite.Database();\n\n    // open the database for reading if file exists\n    // create new database file if not\n\n    db.open(\"aquateen.db\", function (error) {\n      if (error) {\n          console.log(\"Tonight. You.\"));\n          throw error;\n      }\n      db.execute\n        ( \"INSERT INTO aqua_teens (name) VALUES (?)\"\n        , ['meaty meaty moo']\n        , function (error, rows) {\n            if (error) throw error;\n            console.log(\"Aqua teen added.\");\n          }\n        );\n      var sql = 'SELECT name FROM dudes WHERE type = ? AND age > ?';\n\n      db.prepare(sql, function (error, statement) {\n        if (error) throw error;\n\n        // Fill in the placeholders\n        statement.bindArray(['milkshake', 30], function () {\n\n          statement.fetchAll(function (error, rows) {\n            // ...\n            statement.finalize(function (error) {\n              console.log(\"All done!\");\n            });\n          });\n        });\n      });\n    });\n\n# API\n\n## Database Objects\n\nTo create a new database object:\n    var sqlite = require('sqlite');\n\n    var db = sqlite.Database();\n\n### database.open(filename, function (error) {})\n\nOpen a database handle to the database at the specified filename. If the file\ndoes not exist the bindings will attempt to create it. The callback takes no\narguments.\n\nA filename of \":memory:\" may be used to create an in-memory database.\n\n### database.close(function (error) {})\n\nClose the database handle.\n\n### database.execute(sql[, bindings], function (error, rows) {})\n\nExecute a SQL query, `sql` with optional bindings `bindings` on the currently\nopened database. The callback will be executed once with all the rows returned\nfor the query. This is much faster than `database.query` since there are less roundtrips into the thread-pool.\n\n### database.query(sql, [bindings,] function (error, row) {})\n\nExecute a SQL query, `sql`, with optional bindings `bindings` on the currently\nopened database. The callback will be executed once per row returned, plus\nonce more with row set to undefined to indicate end of results.\n\n### database.executeScript(SQL, function (error) {});\n\n    db.executeScript\n      (   \"CREATE TABLE table1 (id, name);\"\n        + \"CREATE TABLE table2 (id, age);\"\n        + \"INSERT INTO table1 (1, 'Mister Shake');\"\n        + \"INSER INTO table2 (1, 34);\"\n      , function (error) {\n          if (error) throw error;\n          // ...\n        });\n\nExecute multiple semi-colon separated SQL statements. Statements must take no\nplaceholders. Each statement will be executed with a single step() and then\nreset. This is ideally suited to executing multiple DDL statements.\n\n### database.prepare(SQL, [options,] function (error, statement) {})\n\nCreate a prepared statement from an SQL string. Prepared statements can be\nused used to iterate over results and to avoid compiling SQL each time a query\nis performed.\n\nOptions:\n\n- lastInsertRowID: boolean, default false.\n    If true, when this statement is step()'d over, the context object (this) in\n    the callback will contain a lastInsertRowID member with the ID of the last\n    inserted row.\n\n- affectedRows: boolean, default false.\n    If true, when this statement is step()'d over, the context object (this) in\n    the callback will contain an affectedRows member with the number of\n    affected rows for the last step.\n\n## Statement Objects\n\n### statement.bindArray(array, function (error) {})\n\n    statement.bindArray([1, 'robots', 4.20], callback)\n\nBind array items to place-holder values (? or $foo) in statement.\n\n### statement.bindObject(object, function (error) {})\n\n    statement.bindObject({ $name: 'meatwad',\n                           $occupation: 'Former detective' }, callback)\n\nBind object properties to named place-holder values ($foo, $bar, $baz) in\nstatement.\n\n### statement.bind(position, value, function (error) {})\n\n    statement.bind(1, \"tango\", function (error) {})\n\nBind a value to a place-holder position. Because binding place-holders is done\nby position (not index), the first place-holder is at position 1, second at\nplace-holder position 2, etc.\n\n### statement.clearBindings()\n\nImmediately clear the bindings from the statement. There is no callback.\n\n### statement.step(function (error, row) {})\n\nFetch one row from a prepared statement and hand it off to a callback. If\nthere are no more rows to be fetched, row will be undefined. Rows are\nrepresented as objects with properties named after the respective columns.\n\n### statement.fetchAll(function (error, rows) {})\n\nFetch all rows in statement and pass them to the callback as an array of\nobjects, each object representing one row.\n\n### statement.reset()\n\nImmediately reset a statement object back to it's initial state, ready to be\nstep() or fetchAll()'d again.\n\n### statement.finalize(function (error) {})\n\nFree SQLite objects associated with this statement and mark it for garbage\ncollection.\n\n## Supported Types\n\nAt the moment, the supported types are TEXT, NUMBER, FLOAT and NULL.\n\n# BUILDING\n\nTo obtain and build the bindings:\n\n    git clone http://github.com/orlandov/node-sqlite.git\n    cd node-sqlite\n    node-waf configure build\n\n# TESTS\n\nRunning the unit tests could not be easier. Simply:\n\n    git submodule update --init\n    ./run-tests\n\n# SEE ALSO\n\n* http://sqlite.org/docs.html\n* http://github.com/grumdrig/node-sqlite/\n\n# AUTHORS\n\nOrlando Vazquez [ovazquez@gmail.com]\n\nRyan Dahl [ry@tinyclouds.org]\n\n# THANKS\n\nMany thanks to Eric Fredricksen for his synchronous driver on which this\ndriver was originally based.\n\n* http://github.com/grumdrig/node-sqlite/\n* http://grumdrig.com/node-sqlite/\n\n# LICENSE\n\nnode-sqlite is BSD licensed.\n\n(c) 2010 Orlando Vazquez\n","maintainers":[{"name":"quartzjer","email":"jeremie@jabber.org"}]},"0.0.8":{"name":"sqlite-fts","description":"SQLite3 bindings for Node with FTS4 enabled","version":"0.0.8","homepage":"http://github.com/quartzjer/node-sqlite-fts","author":{"name":"Jeremie Miller","email":"jeremie@jabber.org"},"contributors":[{"name":"Artem Kustikov"},{"name":"Eric Fredricksen"},{"name":"John Wright"},{"name":"Ryan Dahl"},{"name":"Orlando Vazquez","email":"ovazquez@gmail.com","url":"http://2wycked.net"}],"repository":{"type":"git","url":"git://github.com/quartzjer/node-sqlite-fts.git"},"main":"./sqlite-fts","engines":{"node":">=0.6.0"},"scripts":{"test":"./run-tests","preinstall":"node-waf configure build"},"licenses":[{"type":"BSD"}],"dependencies":{"extend":"1.0.0"},"devDependencies":{},"optionalDependencies":{},"_npmUser":{"name":"quartzjer","email":"jeremie@jabber.org"},"_id":"sqlite-fts@0.0.8","_engineSupported":false,"_npmVersion":"1.0.106","_nodeVersion":"v0.4.10","_defaultsLoaded":true,"dist":{"shasum":"14348a29ca53db48a52495a0038d4b59585d4d2c","tarball":"https://registry.npmjs.org/sqlite-fts/-/sqlite-fts-0.0.8.tgz","integrity":"sha512-MU8vEQwdRH4ftr7LJSPsyqyx9OgcghkuRbn0WjfyN4HnXPpz2+X7D+yTXgKxqajBNCpy+SRYb469MdmzvtzW0A==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIFCK3yef1IZOavKY6n/bCl9zCRV6MNF2amWBKtHcXg8sAiA1t2lHm4L8x48os7IYy7YR+/EpxusqOkmGkteHctrz9A=="}]},"maintainers":[{"name":"quartzjer","email":"jeremie@jabber.org"}]},"0.0.9":{"name":"sqlite-fts","description":"SQLite3 bindings for Node with FTS4 enabled","version":"0.0.9","homepage":"http://github.com/quartzjer/node-sqlite-fts","author":{"name":"Jeremie Miller","email":"jeremie@jabber.org"},"contributors":[{"name":"Artem Kustikov"},{"name":"Eric Fredricksen"},{"name":"John Wright"},{"name":"Ryan Dahl"},{"name":"Orlando Vazquez","email":"ovazquez@gmail.com","url":"http://2wycked.net"}],"repository":{"type":"git","url":"git://github.com/quartzjer/node-sqlite-fts.git"},"main":"./sqlite-fts","engines":{"node":">=0.6.0"},"scripts":{"test":"./run-tests","preinstall":"node-waf configure build"},"licenses":[{"type":"BSD"}],"dependencies":{"extend":"1.0.0"},"devDependencies":{},"optionalDependencies":{},"_npmUser":{"name":"quartzjer","email":"jeremie@jabber.org"},"_id":"sqlite-fts@0.0.9","_engineSupported":true,"_npmVersion":"1.1.0-3","_nodeVersion":"v0.6.10","_defaultsLoaded":true,"dist":{"shasum":"9dd6f815afb3b03c4252a05cb1225220ded4d5ce","tarball":"https://registry.npmjs.org/sqlite-fts/-/sqlite-fts-0.0.9.tgz","integrity":"sha512-02XLc+voa51B49vyoaPLWpZoi1X/3+qYNPemEr9LplXZywQbZBtR7B9LtDBvftUvU6FHBAVML+jVylB/oTdlqw==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCcRAP0HNVHi7KgYzknaoyITPn89+tpHRy78nTptzdtOAIgIRClCVPkD3FUjucTvVxgpOA1lHAsF+9NYr81N7M7jag="}]},"readme":"# NAME\n\nnode-sqlite - Asynchronous SQLite3 driver for Node.js\n\nSQLite calls block, so to work around this, synchronous calls happen within\nNode's libeio thread-pool, in a similar manner to how POSIX calls are\ncurrently made.\n\n# SYNOPSIS\n\n## High-level Driver\n\n    var sys    = require('sys'),\n        sqlite = require('sqlite');\n\n    var db = new sqlite.Database();\n\n    // open the database for reading if file exists\n    // create new database file if not\n\n    db.open(\"aquateen.db\", function (error) {\n      if (error) {\n          console.log(\"Tonight. You.\"));\n          throw error;\n      }\n      db.execute\n        ( \"INSERT INTO aqua_teens (name) VALUES (?)\"\n        , ['meaty meaty moo']\n        , function (error, rows) {\n            if (error) throw error;\n            console.log(\"Aqua teen added.\");\n          }\n        );\n      var sql = 'SELECT name FROM dudes WHERE type = ? AND age > ?';\n\n      db.prepare(sql, function (error, statement) {\n        if (error) throw error;\n\n        // Fill in the placeholders\n        statement.bindArray(['milkshake', 30], function () {\n\n          statement.fetchAll(function (error, rows) {\n            // ...\n            statement.finalize(function (error) {\n              console.log(\"All done!\");\n            });\n          });\n        });\n      });\n    });\n\n# API\n\n## Database Objects\n\nTo create a new database object:\n    var sqlite = require('sqlite');\n\n    var db = sqlite.Database();\n\n### database.open(filename, function (error) {})\n\nOpen a database handle to the database at the specified filename. If the file\ndoes not exist the bindings will attempt to create it. The callback takes no\narguments.\n\nA filename of \":memory:\" may be used to create an in-memory database.\n\n### database.close(function (error) {})\n\nClose the database handle.\n\n### database.execute(sql[, bindings], function (error, rows) {})\n\nExecute a SQL query, `sql` with optional bindings `bindings` on the currently\nopened database. The callback will be executed once with all the rows returned\nfor the query. This is much faster than `database.query` since there are less roundtrips into the thread-pool.\n\n### database.query(sql, [bindings,] function (error, row) {})\n\nExecute a SQL query, `sql`, with optional bindings `bindings` on the currently\nopened database. The callback will be executed once per row returned, plus\nonce more with row set to undefined to indicate end of results.\n\n### database.executeScript(SQL, function (error) {});\n\n    db.executeScript\n      (   \"CREATE TABLE table1 (id, name);\"\n        + \"CREATE TABLE table2 (id, age);\"\n        + \"INSERT INTO table1 (1, 'Mister Shake');\"\n        + \"INSER INTO table2 (1, 34);\"\n      , function (error) {\n          if (error) throw error;\n          // ...\n        });\n\nExecute multiple semi-colon separated SQL statements. Statements must take no\nplaceholders. Each statement will be executed with a single step() and then\nreset. This is ideally suited to executing multiple DDL statements.\n\n### database.prepare(SQL, [options,] function (error, statement) {})\n\nCreate a prepared statement from an SQL string. Prepared statements can be\nused used to iterate over results and to avoid compiling SQL each time a query\nis performed.\n\nOptions:\n\n- lastInsertRowID: boolean, default false.\n    If true, when this statement is step()'d over, the context object (this) in\n    the callback will contain a lastInsertRowID member with the ID of the last\n    inserted row.\n\n- affectedRows: boolean, default false.\n    If true, when this statement is step()'d over, the context object (this) in\n    the callback will contain an affectedRows member with the number of\n    affected rows for the last step.\n\n## Statement Objects\n\n### statement.bindArray(array, function (error) {})\n\n    statement.bindArray([1, 'robots', 4.20], callback)\n\nBind array items to place-holder values (? or $foo) in statement.\n\n### statement.bindObject(object, function (error) {})\n\n    statement.bindObject({ $name: 'meatwad',\n                           $occupation: 'Former detective' }, callback)\n\nBind object properties to named place-holder values ($foo, $bar, $baz) in\nstatement.\n\n### statement.bind(position, value, function (error) {})\n\n    statement.bind(1, \"tango\", function (error) {})\n\nBind a value to a place-holder position. Because binding place-holders is done\nby position (not index), the first place-holder is at position 1, second at\nplace-holder position 2, etc.\n\n### statement.clearBindings()\n\nImmediately clear the bindings from the statement. There is no callback.\n\n### statement.step(function (error, row) {})\n\nFetch one row from a prepared statement and hand it off to a callback. If\nthere are no more rows to be fetched, row will be undefined. Rows are\nrepresented as objects with properties named after the respective columns.\n\n### statement.fetchAll(function (error, rows) {})\n\nFetch all rows in statement and pass them to the callback as an array of\nobjects, each object representing one row.\n\n### statement.reset()\n\nImmediately reset a statement object back to it's initial state, ready to be\nstep() or fetchAll()'d again.\n\n### statement.finalize(function (error) {})\n\nFree SQLite objects associated with this statement and mark it for garbage\ncollection.\n\n## Supported Types\n\nAt the moment, the supported types are TEXT, NUMBER, FLOAT and NULL.\n\n# BUILDING\n\nTo obtain and build the bindings:\n\n    git clone http://github.com/orlandov/node-sqlite.git\n    cd node-sqlite\n    node-waf configure build\n\n# TESTS\n\nRunning the unit tests could not be easier. Simply:\n\n    git submodule update --init\n    ./run-tests\n\n# SEE ALSO\n\n* http://sqlite.org/docs.html\n* http://github.com/grumdrig/node-sqlite/\n\n# AUTHORS\n\nOrlando Vazquez [ovazquez@gmail.com]\n\nRyan Dahl [ry@tinyclouds.org]\n\n# THANKS\n\nMany thanks to Eric Fredricksen for his synchronous driver on which this\ndriver was originally based.\n\n* http://github.com/grumdrig/node-sqlite/\n* http://grumdrig.com/node-sqlite/\n\n# LICENSE\n\nnode-sqlite is BSD licensed.\n\n(c) 2010 Orlando Vazquez\n","maintainers":[{"name":"quartzjer","email":"jeremie@jabber.org"}]}},"maintainers":[{"name":"quartzjer","email":"jeremie@jabber.org"}],"time":{"modified":"2022-06-26T23:16:39.933Z","created":"2011-12-03T14:09:34.571Z","0.0.1":"2011-12-03T14:09:35.097Z","0.0.2":"2011-12-20T17:15:55.125Z","0.0.3":"2012-01-05T17:46:58.057Z","0.0.4":"2012-01-19T02:52:53.241Z","0.0.5":"2012-02-03T23:29:53.560Z","0.0.6":"2012-02-04T23:07:43.418Z","0.0.7":"2012-02-06T16:54:37.230Z","0.0.8":"2012-02-07T21:01:11.981Z","0.0.9":"2012-03-16T21:03:20.723Z"},"author":{"name":"Jeremie Miller","email":"jeremie@jabber.org"},"repository":{"type":"git","url":"git://github.com/quartzjer/node-sqlite-fts.git"}}