Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Learning Hub

Free Learning

You're reading from Node Cookbook Actionable solutions for the full spectrum of Node.js 8 development

Product type Paperback

Published in Jul 2017

Publisher Packt

ISBN-13 9781785880087

Length 656 pages

Edition 3rd Edition

Languages

JavaScript

Tools

Node.js

Concepts

Server Side Web Development

Authors (4):

David Mark Clements

Peter Elger

Mathias Buus Madsen

Matteo Collina

View More author details

Table of Contents (12) Chapters

Preface

1. Debugging process* FREE CHAPTER

2. Writing Modules

3. Coordinating I/O

4. Using Streams

5. Wielding Web Protocols

6. Persisting to Databases

7. Working with Web Frameworks

8. Dealing with Security

9. Optimizing Performance

10. Building Microservice Systems

11. Deploying Node.js

Connecting and sending SQL to a MySQL server

The Structured Query Language (SQL) has been a standard since 1986, and it's the prevailing language for relational databases. MySQL is the most popular SQL relational database server around, often appearing in the prevalent Linux Apache MySQL PHP (LAMP) stack.

If a relational database was conceptually relevant to our goals in a new project, or we were migrating a MySQL backed project from another framework to Node, the mysql module would be particularly useful.

In this task, we will discover how to connect to a MySQL server with Node and execute SQL queries across the wire.

Getting ready

We'll need a MySQL server to connect to. By default, the mysql client module connects...

The rest of the chapter is locked

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at $19.99/month. Cancel anytime

Authors (4)

David Mark Clements

David Mark Clements is a principal architect with nearForm, specializing in Node, frontend web, and JavaScript performance. He assists multinationals and start-ups alike with architecture planning, creating and leading development teams, innovation projects, internal evangelism, training, and deep dive consultancy on all aspects of live systems (architecture, performance, infrastructure, and deployment). David is also an avid open source enthusiast, and regularly speaks at various JavaScript and web conferences. Node.js became a core component of his toolset (since version 0.4) due to its versatility, vast ecosystem, and the cognitive ease that comes with full-stack JavaScript. Being primarily self-taught, David Mark Clements has a potent curiosity that typically drives him to approach problems with a unique perspective.

See other products by David Mark Clements

Mathias Buus Madsen

Mathias Buus (@mafintosh) is a self-taught JavaScript hacker from Copenhagen. He works full-time on open source projects and has been working with Node.js since its 0.2 days. Mathias likes to work with P2P and distributed systems, and he is the author of more than 550 modules on npm, including some of the most popular ones for working with streams. In addition, he has spoken about mad science projects at various conferences around the world.

See other products by Mathias Buus Madsen

Elger

Peter Elger is the CTO at nearForm, a consultancy specializing in enterprise digital transformation using the Node.js platform.Formerly a physicist working on the JET nuclear fusion research project, Peter has worked across several industry verticals, including disaster recovery, telecommunications, and social media. Peter has been the cofounder and CTO of two companies prior to nearForm, and he holds degrees in theoretical physics and computer science. Based in Ireland, Peter spends his time consulting for clients, working on open source software, writing, and conference speaking.

See other products by Elger

Matteo Collina

Matteo Collina is the co-founder and CTO of Platformatic who has the goal of removing all friction from backend development. He is also a prolific open source author in the JavaScript ecosystem, and the modules he maintains are downloaded more than 17 billion times a year. Previously, he was the chief software architect at NearForm, the best professional services company in the JavaScript ecosystem. In 2014, he defended his Ph.D. thesis titled Application Platforms for the Internet of Things. Matteo is a member of the Node.js Technical Steering Committee, focusing on streams, diagnostics, and HTTP. He is also the author of the fast logger, Pino, and the Fastify web framework. Matteo is a renowned international speaker after more than 60 conferences, including OpenJS World, Node.js Interactive, NodeConf.eu, NodeSummit, JSConf.Asia, WebRebels, and JsDay, to name just a few. Since August 2023, he also serves as a community director on the OpenJS Foundation. In the summer, he loves sailing the Sirocco.

See other products by Matteo Collina