node-mysql

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

Current status

It isn't for application development and production yet.

Now It can use for this driver developer only :-p

I'll work for more tests and documents.

Plan

I'll release to developer at middle March 2010.

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();
conn.connect('localhost','nodejs_mysql', 'nodejs_mysql', 'nodejs_mysql');
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));
    });

Requirements

• node.js > 0.1.29 (Supported 0.1.30)

Optional:

• node-crypt for faster authenticate.

License

MIT License. See LICENSE file.

Who?

Code by Yuichiro MASUI a.k.a. masuidrive

• masui@masuidrive.jp
• http://blog.masuidrive.jp/

Included files

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