{"_id":"mysql-native","_rev":"24-17fdf7d33a8d6f89fb1f94b7fbf957b4","name":"mysql-native","dist-tags":{"latest":"0.4.7"},"versions":{"0.4.0":{"name":"mysql-native","version":"0.4.0","main":"./lib/mysql-native","_id":"mysql-native@0.4.0","engines":{"node":"*"},"_nodeSupported":true,"_npmVersion":"0.2.7-2","_nodeVersion":"v0.3.1-pre","dist":{"tarball":"https://registry.npmjs.org/mysql-native/-/mysql-native-0.4.0.tgz","shasum":"bc951164d23037e3e4fe49ef1b7e29580a659022","integrity":"sha512-yEzjxZhqnbDWEEGRGMRa5VCJQ6Ywuei1aLc2nsTai9sUk6MDDYxiBQ3dpx98fl/2h0lhPn/o/mbmAoJBAb2YPQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQDbEtpvryE/8WMFxOLsbpx2wLo4bwtiQkzGhcIQAi1NfQIhAP0r/22W9DVBbFNR4trj9JB5mht+xWY7bblhXN9uk9b/"}]}},"0.4.1":{"name":"mysql-native","description":"MySql protocol client for Node.Js","version":"0.4.1","maintainers":[{"name":"Andrey Sidorov","email":"sidoarres@yandex.ru"}],"bugs":{"web":"http://github.com/sidorares/nodejs-mysql-native/issues"},"licenses":[{"type":"MIT"}],"repositories":[{"type":"git","url":"http://github.com/sidorares/nodejs-mysql-native"}],"main":"./lib/mysql-native","engines":{"node":">=0.2.0"},"_id":"mysql-native@0.4.1","_nodeSupported":true,"_npmVersion":"0.2.7-2","_nodeVersion":"v0.3.1-pre","dist":{"tarball":"https://registry.npmjs.org/mysql-native/-/mysql-native-0.4.1.tgz","shasum":"ecedcdd59c42d879bdc9d523f5f3934e38d40a98","integrity":"sha512-+8Zl+aLGNbmHpNZRuvyIqzTp4e+RHRfkY4JaqtGXZjuD+O+0cOsdIncVEh9Y/zF6BI9traErjhJZN5e1YVfGrA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIDv+yvYRJKSpICIS8/+7NjVPf9Tw/b38DCZ6HnRJ2/GEAiBx+7rTi4YkVuuR6e4OUpTgLibZkDZh6e7dxmOmA9ftaQ=="}]}},"0.4.2":{"name":"mysql-native","description":"MySql protocol client for Node.Js","version":"0.4.2","maintainers":[{"name":"Andrey Sidorov","email":"sidoarres@yandex.ru"}],"bugs":{"url":"http://github.com/sidorares/nodejs-mysql-native/issues"},"licenses":[{"type":"MIT"}],"repositories":[{"type":"git","url":"http://github.com/sidorares/nodejs-mysql-native"}],"main":"./lib/mysql-native","engines":{"node":">=0.2.0"},"_id":"mysql-native@0.4.2","_engineSupported":true,"_npmVersion":"0.3.15","_nodeVersion":"v0.5.0-pre","directories":{"lib":"./lib"},"files":[""],"_defaultsLoaded":true,"dist":{"shasum":"2c641ae7a038b5e01da55f5d10805bfbc82f5bdb","tarball":"https://registry.npmjs.org/mysql-native/-/mysql-native-0.4.2.tgz","integrity":"sha512-S3M4ftv1q+oQyK5OZ572KGWV41uw/WfoYXAYlMT4sohuMbB0aUqRiFROTwemn5eGlif5o3zrNE0hCLR0yK3ObQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCmJJ3cIjDiTJeliLygatOjJkpnOmWtTy4E5RJfNFO6JwIgYghHZvqrZwx0rWb795W9pz30HsIrTs+2gDo//BZ+uLM="}]}},"0.4.3":{"name":"mysql-native","description":"MySql protocol client for Node.Js","version":"0.4.3","maintainers":[{"name":"Andrey Sidorov","email":"sidoares@yandex.ru"}],"bugs":{"url":"http://github.com/sidorares/nodejs-mysql-native/issues"},"licenses":[{"type":"MIT"}],"repositories":[{"type":"git","url":"http://github.com/sidorares/nodejs-mysql-native"}],"main":"./lib/mysql-native","engines":{"node":">=0.2.0"},"_id":"mysql-native@0.4.3","contributors":[{"name":"https://github.com/sidorares/nodejs-mysql-native/contributors"}],"dependencies":{},"devDependencies":{},"_engineSupported":true,"_npmVersion":"1.0.10","_nodeVersion":"v0.4.9-pre","_defaultsLoaded":true,"dist":{"shasum":"6d3f0a6c93e4edc15e153b07d827e596b08a100c","tarball":"https://registry.npmjs.org/mysql-native/-/mysql-native-0.4.3.tgz","integrity":"sha512-MlpNfsNfN+aQgxL6hwBbmXuYZ/eGG5uGDru342qk2pZ0CkfzojCpzvP8PMgU0DWf6L7OQvGQ5nF5o2s6xGAPvA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIF3HcqrE24eAZEM9JfTMiuW3O0su966Ts/L+mO/PvRwNAiAkLNzdunxLLJ+UxMUTyKaIo3Rfx54+miVwrP3QvWvYdg=="}]},"scripts":{}},"0.4.4":{"name":"mysql-native","description":"MySql protocol client for Node.Js","keywords":["mysql","native","sql","database","client","pool"],"homepage":"http://github.com/sidorares/nodejs-mysql-native","version":"0.4.4","author":{"name":"Andrey Sidorov","email":"sidorares@yandex.ru"},"bugs":{"url":"http://github.com/sidorares/nodejs-mysql-native/issues"},"license":"MIT","repository":[{"type":"git","url":"http://github.com/sidorares/nodejs-mysql-native"}],"main":"./lib/mysql-native","engines":{"node":">=0.2.0"},"scripts":{"pretest":"NODE_ENV=test node test/setup_db","test":"node test/expresso-wrapper"},"_npmUser":{"name":"sidorares","email":"sidorares@yandex.ru"},"_id":"mysql-native@0.4.4","contributors":[{"name":"https://github.com/sidorares/nodejs-mysql-native/contributors"}],"dependencies":{},"devDependencies":{},"_engineSupported":true,"_npmVersion":"1.1.0-alpha-6","_nodeVersion":"v0.6.4","_defaultsLoaded":true,"dist":{"shasum":"62e2fe646b0424c2bf8f0149e4602c76274f8752","tarball":"https://registry.npmjs.org/mysql-native/-/mysql-native-0.4.4.tgz","integrity":"sha512-r04GXu4YMOPfP+egVC3lNjLIzAuDC3u/taO/8J8jAj/pu6ynAde0dVhJz9AB3XV8E8EvGfWp80QCYV7UVFlekg==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQDuGHyhG1s+xR6rSh9KYPPAYsQ/F1p3ly6RURTUCqrofAIgP5QU96BX8FNSUWtrIGO6ZEJC1V5ZsTGLwzcrIboDLLA="}]},"maintainers":[{"name":"sidorares","email":"sidorares@yandex.ru"}]},"0.4.5":{"name":"mysql-native","description":"MySql protocol client for Node.Js","keywords":["mysql","native","sql","database","client","pool"],"homepage":"http://github.com/sidorares/nodejs-mysql-native","version":"0.4.5","author":{"name":"Andrey Sidorov","email":"sidorares@yandex.ru"},"bugs":{"url":"http://github.com/sidorares/nodejs-mysql-native/issues"},"license":"MIT","repository":[{"type":"git","url":"http://github.com/sidorares/nodejs-mysql-native"}],"main":"./lib/mysql-native","engines":{"node":">=0.6.0"},"scripts":{"pretest":"NODE_ENV=test node test/setup_db","test":"node test/expresso-wrapper"},"_npmUser":{"name":"sidorares","email":"sidorares@yandex.ru"},"_id":"mysql-native@0.4.5","contributors":[{"name":"https://github.com/sidorares/nodejs-mysql-native/contributors"}],"dependencies":{},"devDependencies":{},"optionalDependencies":{},"_engineSupported":true,"_npmVersion":"1.1.16","_nodeVersion":"v0.8.1-pre","_defaultsLoaded":true,"dist":{"shasum":"bc35108d4d766b0850b2614ea5063cf95adadee2","tarball":"https://registry.npmjs.org/mysql-native/-/mysql-native-0.4.5.tgz","integrity":"sha512-m48QdroB51sRCBU5kqjYmE4kZPZ8yYFET/urYyRpfZEX60ENu4ssaNJ79huNj2CLYQNzA5YAD9cpjTYJ53KVLA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCICZAnWBJLSpMF0QmanxcNt0qL7TCcXf1jS0Qyoai9szuAiAZ9Pqxa+zw6PEHEDHYJwdlfBFh9+O4c7fEoy1kUmfAMg=="}]},"maintainers":[{"name":"sidorares","email":"sidorares@yandex.ru"}]},"0.4.6":{"name":"mysql-native","description":"MySql protocol client for Node.Js","keywords":["mysql","native","sql","database","client","pool"],"homepage":"http://github.com/sidorares/nodejs-mysql-native","version":"0.4.6","author":{"name":"Andrey Sidorov","email":"sidorares@yandex.ru"},"bugs":{"url":"http://github.com/sidorares/nodejs-mysql-native/issues"},"license":"MIT","repository":[{"type":"git","url":"http://github.com/sidorares/nodejs-mysql-native"}],"main":"./lib/mysql-native","engines":{"node":">=0.6.0"},"scripts":{"pretest":"NODE_ENV=test node test/setup_db","test":"node test/expresso-wrapper"},"_npmUser":{"name":"sidorares","email":"sidorares@yandex.ru"},"_id":"mysql-native@0.4.6","contributors":[{"name":"https://github.com/sidorares/nodejs-mysql-native/contributors"}],"dependencies":{},"devDependencies":{},"optionalDependencies":{},"_engineSupported":true,"_npmVersion":"1.1.16","_nodeVersion":"v0.6.20","_defaultsLoaded":true,"dist":{"shasum":"d5fcc471818b71b191955dfdf9c24a26c00a5a61","tarball":"https://registry.npmjs.org/mysql-native/-/mysql-native-0.4.6.tgz","integrity":"sha512-hNJH2kKpICadJHdY288AmiJLCd0/F+HW2IwHlrA0GRe7/44AALZoxoBky3jM5ddFSw4rQfIY1XJ09Ia13rsl1w==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIFSEYxjMB7ZFW0frMiyPrjk1KJFp0vf9SkJr+95jW27DAiEA215Ye4Eb1U3u/c++Av7Dm0Uzk5HtXkNaWxBx+fi9s5o="}]},"maintainers":[{"name":"sidorares","email":"sidorares@yandex.ru"}]},"0.4.7":{"name":"mysql-native","description":"MySql protocol client for Node.Js","keywords":["mysql","native","sql","database","client","pool"],"homepage":"http://github.com/sidorares/nodejs-mysql-native","version":"0.4.7","author":{"name":"Andrey Sidorov","email":"sidorares@yandex.ru"},"bugs":{"url":"http://github.com/sidorares/nodejs-mysql-native/issues"},"license":"MIT","repository":[{"type":"git","url":"http://github.com/sidorares/nodejs-mysql-native"}],"main":"./lib/mysql-native","engines":{"node":">=0.6.0"},"scripts":{"pretest":"NODE_ENV=test node test/setup_db","test":"node test/expresso-wrapper"},"_npmUser":{"name":"sidorares","email":"sidorares@yandex.ru"},"_id":"mysql-native@0.4.7","contributors":[{"name":"https://github.com/sidorares/nodejs-mysql-native/contributors"}],"dependencies":{},"devDependencies":{},"optionalDependencies":{},"_engineSupported":true,"_npmVersion":"1.1.16","_nodeVersion":"v0.6.20","_defaultsLoaded":true,"dist":{"shasum":"7c0381c5526a913af78a6a0c0ce0c25a48b7b76d","tarball":"https://registry.npmjs.org/mysql-native/-/mysql-native-0.4.7.tgz","integrity":"sha512-xoLWVfAKXBnx0Hdk8eEMi0q3Kk05VVjV8cD4P/POj23vK0yovsVR7Jx5BnucUwmiuJx6mYM1Ihco33oQ5+eVsw==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIGyULUpEOD8NXhqKhxUZCQu8wmzAS4hQrw1WBMi+NsHbAiEA675mal2xm1suVvYYcuGXn8XiTMv77RiQR/flPbtD6eg="}]},"maintainers":[{"name":"sidorares","email":"sidorares@yandex.ru"}]}},"maintainers":[{"name":"sidorares","email":"sidorares@yandex.ru"}],"description":"MySql protocol client for Node.Js","time":{"modified":"2022-06-20T18:13:49.605Z","created":"2011-03-21T13:54:21.144Z","0.4.0":"2011-03-21T13:54:21.144Z","0.4.1":"2011-03-21T13:54:21.144Z","0.4.2":"2011-03-21T13:54:21.144Z","0.4.3":"2011-06-10T15:13:17.807Z","0.4.4":"2011-12-22T02:48:58.027Z","0.4.5":"2012-06-29T00:36:15.383Z","0.4.6":"2012-08-17T13:58:51.381Z","0.4.7":"2012-08-17T23:24:14.789Z"},"author":{"name":"Andrey Sidorov","email":"sidorares@yandex.ru"},"repository":[{"type":"git","url":"http://github.com/sidorares/nodejs-mysql-native"}],"readme":"# About\nMysql client module for node.js, written in JavaScript. No other mysql runtime required.\n\n[![Build Status](https://secure.travis-ci.org/sidorares/nodejs-mysql-native.png)](http://travis-ci.org/sidorares/nodejs-mysql-native)\n\n# Install\n`npm install mysql-native`\n\n# Community\nCheck out the google group http://groups.google.com/group/node-mysql-native for questions/answers from users of the driver.\n\n\n# Example\n<pre>var db = require(\"mysql-native\").createTCPClient(); // localhost:3306 by default\ndb.auto_prepare = true;\nfunction dump_rows(cmd)\n{\n   cmd.addListener('row', function(r) { console.dir(r); } );\n}\n\ndb.auth(\"test\", \"testuser\", \"testpass\");\ndump_rows(db.query(\"select 1+1,2,3,'4',length('hello')\"));\ndump_rows(db.execute(\"select 1+1,2,3,'4',length(?)\", [\"hello\"]));\ndb.close();</pre>\n\noutput is:\nrow: [ 2, 2, 3, \"4\", 5]\nrow: [ 2, 2, 3, \"4\", 5]\n\n# Highlights\n\n* commands are pipelined\n* types are converted mysql<->javascript according to field type\n* prepared statements are cached and auto-prepared\n* row packet ( query ) and binary row packet ( execute ) handled transparently equal\n\n#API\n\n## Module Functions\n* createClient(socket) -  create client from duplex stream (TODO: add default path to local server socket)\n* createTCPClient(host, port) - create tcp client, default host 127.0.0.1, port 3306\n* createUNIXClient(path) - connect to unix domain socket, default is /var/run/mysqld/mysqld.sock\n\n## Client Functions\nAll commands fire 'end'() event at the end of command executing.\n\n* `auth(db, user, pass)` - perform mysql connection handshake. Should be always a first command (TODO: add default user/pass if missing?).\nEvents:\n    'authorized'(serverStatus) event. \n\n* `query(sql)` - simple query.\nEvents:\n    'field'(field) - one for each field description\n    'fields_eof'() - after last field\n    'row'(rows) - array of field values, fired for each row in result set\n\n* `client.prepre(sql)` - prepare a statement and store result in client.pscache\nEvents:\n    'prepared'(preparedStatement)\n    'parameter'(field) - input parameter description\n\n* `execute(sql, parameters)` - parameters is an array of values. Known types are sent in appropriate mysql binary type (TODO: currently this is not true, type is always string and input converted using param.toString() )\nEvents:\n   same as with query()\n   \n* `client.close` - create and enqueue corresponding command\n* `client.execute` also adds prepare command if there is no cached statement and client.auto_prepare set to true (TODO: add better api than client.auto_prepare flag)\n* `client.terminate` - close conection immediately\n\n# TODO\n\n* buffers \n\n# LINKS\n\nMySql protocol documentation:\n \n* <http://forge.mysql.com/wiki/MySQL_Internals_ClientServer_Protocol>\n\nOther node.js mysql clients:\n\n* <http://github.com/felixge/node-mysql>\n* <http://github.com/Sannis/node-mysql-libmysqlclient>\n* <http://github.com/Guille/node.dbslayer.js>\n","readmeFilename":""}