Question 1

How do I connect to MySQL using Node.js with X DevAPI?

Accepted Answer

Install the @mysql/xdevapi package via npm with exact versioning, then use the X DevAPI's session.create() method. Refer to the official documentation for code examples on establishing connections and performing operations.

Question 2

MySQL Connector/Node.js vs mysql2: which one should I use?

Accepted Answer

Choose MySQL Connector/Node.js if you need MySQL 8's Document Store features, official Oracle support, or hybrid SQL/NoSQL access. Use mysql2 for basic SQL queries, older MySQL versions, or lighter dependency overhead.

Question 3

Can I use this with MySQL 5.7?

Accepted Answer

No, it only supports MySQL 8 and later, as it relies on features like the X DevAPI and Document Store that are not available in MySQL 5.7. You'll need a different driver for older versions.

Question 4

How to perform CRUD operations on JSON documents with this connector?

Accepted Answer

Use the X DevAPI's collection methods, such as add(), find(), modify(), and remove(), on MySQL collections. The documentation provides specific examples for NoSQL-style document handling.

Question 5

Is MySQL Connector/Node.js production ready?

Accepted Answer

Yes, it's designed for production use with comprehensive documentation and Oracle backing, but be cautious with version updates due to non-semantic versioning, and use lockfiles as advised.

Question 6

What are the licensing terms for MySQL Connector/Node.js?

Accepted Answer

It uses GPLv2 with a FOSS exception, allowing free use in open-source and commercial projects, but review the LICENSE file for details to ensure compliance with your project's needs.

MySQL Connector/Node.js

What is MySQL Connector/Node.js?

Overview

Use Cases

Best For

Related Projects

Found a gem we're missing?

Not Ideal For

Pros & Cons

Pros

Cons

Frequently Asked Questions