@mysql/xdevapi

MySQL Connector/Node.js with X DevAPI

The Node.js Connector is an asynchronous promise-based client library for the X DevAPI (using the X Protocol) that was introduced in MySQL 5.7.12.

MySQL is an open-source relational database that is secure, high performing, and easy to use. The X DevAPI supports relational tables and JSON documents making it possible to use both tables and collections at the same time.

For general information about the X DevAPI, please refer to documentation on https://dev.mysql.com/doc/x-devapi-userguide/en/.

Requirements

This library requires Node.js 4.2.0 or later and MySQL 8.0.3 or later. You are able to use recent MySQL 5.7.x versions (with some limitations), however, MySQL 5.7 does not take advantage of the entire set of features provided by the connector.

Installation

This library is organized in a way that it can be installed into your project using Node.js's npm tool. Choose one of the following methods to get and install MySQL Connector/node.js:

• manually download the package from https://dev.mysql.com/downloads/connector/nodejs/ and import the library using npm:

$ npm install mysql-connector-nodejs-8.0.9.tar.gz`

• use the @mysql/xdevapi package from https://npmjs.com and install it:

$ npm install @mysql/xdevapi

Please refer to https://npmjs.com for more information on npm.

Getting Started

Here's a small example of how to leverage the library using MySQL as a document-store.

'use strict';

const mysqlx = require('@mysql/xdevapi');

mysqlx
    .getSession({
        dbPassword: '<passwd>',
        dbUser: 'root',
        host: 'localhost',
        port: 33060
    })
    .then(session => {
        console.log('A new session has been created.');

        return session
            .createSchema('mySchema')
            .then(schema => ({ schema, session }))
    })
    .then(ctx => {
        console.log('The schema has been created.');

        return ctx.schema
            .createCollection('myCollection')
            .then(collection => Object.assign(ctx, { collection }))
    })
    .then(ctx => {
        console.log('The collection has been created.')

        return Promise
            .all([
                ctx.collection
                    .add({ baz: { foo: 'bar' } }, { foo: { bar: 'baz' } })
                    .execute()
                    .then(() => {
                        console.log('The documents where added to the collection.');
                    }),
                ctx.collection
                    .find('baz.foo = "bar"')
                    .execute(row => {
                        console.log('A row has been found: %j', row);
                    })
                    .then(() => {
                        console.log('The collection find operation has finished.');
                    }),
                ctx.collection
                    .remove('foo.bar = "baz"')
                    .execute()
                    .then(() => {
                        console.log('The document has been removed from the collection.');
                    }),
                ctx.schema
                    .dropCollection('myCollection')
                    .then(() => {
                        console.log('The collection has been deleted.');
                    })
            ])
            .then(() => ctx)
    })
    .then(ctx => {
        return ctx.session
            .dropSchema('mySchema')
            .then(() => ctx);
    })
    .then(ctx => {
        console.log('The schema has been deleted.');

        return ctx.session.close();
    })
    .then(() => {
        console.log('The session has been closed.');
        process.exit(0);
    })
    .catch(err => {
        console.log(err.stack);
        process.exit(1);
    });

License

Copyright (c) 2015, 2018, Oracle and/or its affiliates. All rights reserved.

This is a release of MySQL Connector/Node.js, Oracle's Node.js driver for MySQL.

License information can be found in the LICENSE file.

This distribution may include materials developed by third parties. For license and attribution notices for these materials, please refer to the LICENSE file.

For more information on MySQL Connector/Node.js, visit http://dev.mysql.com/doc/dev/connector-nodejs/8.0/

For additional downloads and the source of MySQL Connector/Node.js, visit http://dev.mysql.com/downloads

MySQL Connector/Node.js is brought to you by the MySQL team at Oracle.