MySQL integration

Introduction

In this topic you will learn how to integrate with Node.js using MYSQL database management tool. You will learn various ways to connect and interact with data residing in mysql using a nodejs program and script.

Found a mistake? Have a question or improvement idea? Let me know.

MySQL integration:

*MySQL integration

*Connect to MySQL

*Using a connection pool

*Query a connection object with parameters

*Query a connection object without parameters

*Run a number of queries with a single connection from a pool

*Export Connection Pool

*Return the query when an error occurs

Table Of Contents

0Getting started

2Web apps with Express

3Filesystem I/O

4Exporting and consuming modules

5Exporting and importing module in node.js

6Installing Node.js

7MySQL integration

10Event emitters

11Autoreload on changes

13Callback to promise

14Executing files or commands with child processes

16Exception handling

17Keep a node application constanly running

18Uninstalling Node.js

19nvm - Node Version Manager

20HTTP client and server

21Using streams

22Deploying Node.js applications in production

23Securing node.js application

24Mongoose library

27Socket.io communication

28Mongodb integration

29Handling POST requests in Node.js

30Simple REST based CRUD API

31Template frameworks

32Node.js architecture inner workings

34Node server without a framework

35Node.js with ES6

36Interacting with console

37Cassandra integration

38Creating APIs with Node.js

39Graceful shutdown

40Using IISNode to host Node.js web apps in IIS

42Node.js frameworks

44Using WebSockets with Node.js

46Parsing command-line arguments

47Client-server communication

48Node.js design fundamental

49Connect to Mongodb

50Performance challenges

51Send web notification

52Remote debugging in node.js

53MySQL connection pool

54Database MongoDB with Mongoose

55Good coding style

56RESTful API design best practices

57Deliver HTML or other file

60Blueburid promises

61Async / Await

62Koa Framework v2

63Unit testing frameworks

65Routing AJAX requests with Express.JS

66Sending a file stream to client

68Using browserify

70Passport integration

71Dependency injection

72Beginner guide

73Use cases for Node.js

75PostgreSQL integration

76How modules are loaded

78Synchronous vs. asynchronous

79Error managemtn

80Node.js v6 new features

82History of Node.js

84Asynchronous programming

85Stdin / stdout

89Loopback - REST based connector

90Running node.js as a service

94yarn package manager

96Node.js localization

97Deploying node.js applications without downtime

98express.js with angular.js

99Node.js routing

100Creating library that supports promises and error-first callbacks

101MSSQL integration

102Project structure

103Avoid callback hell

104Arduino communication

106Multi-threading

107Windows authentication

109Route-controller-service structure

110Push notifications

111Contributors