blocks|key|1125267|text|您还可以尝试一种称为Node.js+DB的较新的工作，它的目标是为几个数据库引擎提供一个通用框架。它是用C%2B%2B构建的，所以性能是有保证的。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1125268|具体地说，您可以为Node.js+MySQL+support使用它的db-mysql驱动程序。|1125269|entityMap|0|LINK|mutability|MUTABLE|url|http://nodejsdb.org/|1|http://nodejsdb.org/db-mysql^0|A|A|0|0|9|L|1|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@$A|Q|B|R|1|S]]|C|$]]|$1|D|3|E|5|6|7|T|8|@]|9|@$A|U|B|V|1|W]]|C|$]]|$1|F|3|-4|5|6|7|X|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]|N|$5|I|J|K|C|$L|O]]]]

You can also try out a newer effort known as <a href="http://nodejsdb.org/" rel="noreferrer">Node.js DB</a> that aims to provide a common framework for several database engines. It is built with C++ so performance is guaranteed.

Specifically you could use its db-mysql driver for <a href="http://nodejsdb.org/db-mysql" rel="noreferrer">Node.js MySQL support</a>.

blocks|key|1125150|text|看看https://github.com/Sannis/node-mysql-libmysqlclient就知道了。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1125151|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/Sannis/node-mysql-libmysqlclient^0|2|1F|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

Just look at <a href="https://github.com/Sannis/node-mysql-libmysqlclient" rel="noreferrer">https://github.com/Sannis/node-mysql-libmysqlclient</a>.

blocks|key|910199|text|如果您需要用于MySQL的ORM，您可能需要查看http://sequelizejs.com+:)|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|910200|entityMap|0|LINK|mutability|MUTABLE|url|http://sequelizejs.com/^0|O|M|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

If you need an ORM for MySQL you might want to check out <a href="http://sequelizejs.com" rel="noreferrer">http://sequelizejs.com</a> :)

blocks|key|1125290|text|为了使用node.js连接到MySQL，我使用node-odbc取得了很大的成功|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1125291|它也可以完美地连接到其他数据库，比如IBM的DB2，而且速度之快令人惊讶。|1125292|This+page对于在linux上配置ODBC特别有用。|1125293|使用yum+install+mysql-connector-odbc安装后，我的/etc/odbc.ini文件如下所示：|style|CODE|1125294|[MYSQL]
Description+=+MySQL+ODBC+Driver
Driver++++++=+/usr/lib64/libmyodbc3.so|code-block|syntax|javascript|1125295|我省略了服务器、用户、数据库、端口、密码等内容，这样我就可以从我的连接字符串中设置这些内容(我需要连接到多个数据库)。|1125296|保存/etc/odbc.ini之后，将使用以下命令进行安装：odbcinst+-i+-s+-l+-f+/etc/odbc.ini|1125297|下面是一个用于测试的代码示例：|1125298|++++var+odbc+=+require("odbc");
++++var+db+=+new+odbc.Database();
++++var+conn+=+"dsn=mysql;server=localhost;user=root;database=mydb;port=3306;password=mypwd;command+timeout=30000;";
++++db.open(conn,+function(err)+{
++++++++if(err)+throw+err;
++++++++var+params+=+['jiy@stackoverflow.com'];
++++++++var+qry+=+"select+*+users+where+email+=+?";
++++++++db.query(qry,+params,+function(err,+rows,+def)+{
++++++++++++if(err)+console.log(err);
++++++++++++console.log(rows);
++++++++});
++++});|1125299|或者，如果您想使用coffeescript：|1125300|++++odbc+=+require+"odbc"
++++db+=+new+odbc.Database()
++++conn+=+"dsn=mysql;server=localhost;user=root;database=mydb;port=3306;password=mypwd;command+timeout=30000;"

++++db.open+conn,+(err)+->
++++++++throw+err+if+err

++++++++qry+=+"select+*+from+users+where+email+=+?"

++++++++db.query+sql,+["jiy@stackoverflow.com"],+(err,+rows,+def)+->
++++++++++++if+err?+then+console.log+err+else
++++++++++++console.log+rows|1125301|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/w1nk/node-odbc|1|http://www.webaj.com/how-setup-mysql-dsn-datasbase-source-centos-myodbc-and-unixodbc-command-line.htm^0|N|9|0|0|0|0|9|1|0|2|W|0|0|0|U|Y|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1C|8|@]|9|@$A|1D|B|1E|1|1F]]|C|$]]|$1|D|3|E|5|6|7|1G|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|1H|8|@]|9|@$A|1I|B|1J|1|1K]]|C|$]]|$1|H|3|I|5|6|7|1L|8|@$A|1M|B|1N|J|K]]|9|@]|C|$]]|$1|L|3|M|5|N|7|1O|8|@]|9|@]|C|$O|P]]|$1|Q|3|R|5|6|7|1P|8|@]|9|@]|C|$]]|$1|S|3|T|5|6|7|1Q|8|@$A|1R|B|1S|J|K]]|9|@]|C|$]]|$1|U|3|V|5|6|7|1T|8|@]|9|@]|C|$]]|$1|W|3|X|5|N|7|1U|8|@]|9|@]|C|$O|P]]|$1|Y|3|Z|5|6|7|1V|8|@]|9|@]|C|$]]|$1|10|3|11|5|N|7|1W|8|@]|9|@]|C|$O|P]]|$1|12|3|-4|5|6|7|1X|8|@]|9|@]|C|$]]]|13|$14|$5|15|16|17|C|$18|19]]|1A|$5|15|16|17|C|$18|1B]]]]

For connecting to MySQL with node.js, I've had great success using <a href="https://github.com/w1nk/node-odbc" rel="nofollow">node-odbc</a>

It's also worked flawlessly for connecting to other databases such as IBM's DB2, and it's been surprisingly fast.

<a href="http://www.webaj.com/how-setup-mysql-dsn-datasbase-source-centos-myodbc-and-unixodbc-command-line.htm" rel="nofollow">This page</a> is particularly useful for configuring ODBC on linux.

After installing with <code>yum install mysql-connector-odbc</code>, my /etc/odbc.ini file looks like this:

<pre><code>[MYSQL]
Description = MySQL ODBC Driver
Driver = /usr/lib64/libmyodbc3.so
</code></pre>

I left out stuff such as server, user, database, port, password etc. so that I can set these from my connection string (I need to connect to multiple databases).

After saving /etc/odbc.ini, it's installed with this command: <code>odbcinst -i -s -l -f /etc/odbc.ini</code>

And here's a code sample for testing it out:

<pre><code> var odbc = require("odbc");
 var db = new odbc.Database();
 var conn = "dsn=mysql;server=localhost;user=root;database=mydb;port=3306;password=mypwd;command timeout=30000;";
 db.open(conn, function(err) {
 if(err) throw err;
 var params = ['jiy@stackoverflow.com'];
 var qry = "select * users where email = ?";
 db.query(qry, params, function(err, rows, def) {
 if(err) console.log(err);
 console.log(rows);
 });
 });
</code></pre>

Or if you wanted to use coffeescript:

<pre><code> odbc = require "odbc"
 db = new odbc.Database()
 conn = "dsn=mysql;server=localhost;user=root;database=mydb;port=3306;password=mypwd;command timeout=30000;"

 db.open conn, (err) -&gt;
 throw err if err

 qry = "select * from users where email = ?"

 db.query sql, ["jiy@stackoverflow.com"], (err, rows, def) -&gt;
 if err? then console.log err else
 console.log rows
</code></pre>

Is there a Node.JS Driver for MySQL that is commonly used other than <a href="https://github.com/felixge/node-mysql" rel="noreferrer">node-mysql?</a>

(It seems like there is not much activity with node.js database drivers. Is there a reason for this or is it just because Node.JS is so young?)

What MySQL drivers are available for node.js?

数据库

服务器

MySQL

除了之外，是否还有用于MySQL的Node.JS驱动程序(似乎node.js数据库驱动程序没有太多活动。这是有原因的，还是仅仅是因为Node.JS太年轻了？)

问哪些MySQL驱动程序可用于node.js？
EN

回答 4

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问哪些MySQL驱动程序可用于node.js？EN

回答 4

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问哪些MySQL驱动程序可用于node.js？
EN