node-mysql

This library is obsolete.

please check https://github.com/felixge/node-mysql

node-mysql is pure Javascript MySQL network driver for node.js

Want to help

It's for testing stage. Now It can use for this driver developer only.

I have a lot of tasks to make stable driver. I want your help.

Tests

I need your help in testing this driver. It will be great if you use it for testing or prototyping. It's testing stage, It's not for real project If you find bugs, strange thing and unknown things, please send them to @masuidrive_en or github issues If you write test code (test folder), It's awesome!!

Documentation

Sorry, This driver's documentation is less. My English skill is horrible. :-(

This drivers is came from Ruby's mysql driver. Almost API is same as mysql.rb. maybe this document is useful reference.

Pool mananager

Currently, this driver supported single connection only. We need multi mysql driver pool manager for multi connections. And connection pool require transaction support.

Example

var sys = require('sys');
var mysql = require('./lib/mysql');

/*
> mysql -u root
CREATE DATABASE nodejs_mysql;
GRANT ALL ON nodejs_mysql.* TO nodejs_mysql@localhost IDENTIFIED BY "nodejs_mysql";
*/
var conn = new mysql.Connection('localhost','nodejs_mysql', 'nodejs_mysql', 'nodejs_mysql');
conn.connect();
conn.query("CREATE TEMPORARY TABLE test1(intval INTEGER, strval TEXT, timestampval TIMESTAMP, boolval BOOLEAN);");
conn.query("INSERT INTO test1 VALUES(1,'a',now(),true);");
conn.query("SELECT * FROM test1;",
    function(result) {
        for(var i=0; i<result.records.length; ++i) {
            sys.puts("Result: "+sys.inspect(result.toHash(result.records[i])));
        };
    },
    function(error) {
        sys.puts("Error: "+sys.inspect(error));
    });

And see exmaples folder.

Requirements

• node.js >= 0.1.92

Optional:

• node-crypt for faster authenticate.

License

MIT License. See LICENSE file.

Who?

Code by Yuichiro MASUI(masuidrive) and awesome contributers. please see AUTHORS

• masui@masuidrive.jp
• http://blog.masuidrive.jp/ (English)
• http://twitter.com/masuidrive_en (English)
• http://blog.masuidrive.jp/ (Japanese)
• http://twitter.com/masuidrive (Japanese)

Related licenses

MySQL protocol encode/decode from tmtm's ruby-mysql.

• http://github.com/tmtm/ruby-mysql
• Copyright: Copyright (c) 2009-2010 TOMITA Masahiro
• License: Ruby's

Promise library

• http://nodejs.org/
• Copyright 2009, 2010 Ryan Lienhart Dahl. All rights reserved.
• License: MIT

SHA1 library from Takanori Ishikawa.

• http://www.metareal.org/
• Copyright (c) 2008 Takanori Ishikawa takanori.ishikawa@gmail.com
• License: MIT

pack/unpack from php.js

• http://phpjs.org/functions/pack:880
• Author: Tim de Koning (http://www.kingsquare.nl)
• License: BSD