Packt+ | Advance your knowledge in tech

0

All Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Free Learning

Node Cookbook

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):

Matteo Collina

David Mark Clements

Peter Elger

Mathias Buus Madsen

View More author details

Table of Contents (20) Chapters

Title Page

Credits

Foreword

About the Authors

About the Reviewers

www.PacktPub.com

Customer Feedback

About nearForm

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 for relational databases. MySQL is most popular SQL relational database server around, often appearing in the prevalent Linux Apache MySQL PHP (LAMP) stack.

If a relational database conceptually to our goals in a project, or we 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 to localhost, so we'll have MySQL running locally.

On Linux, we can see if MySQL is already installed with the following command:

$ whereis mysql

On macOS, we can use this:

$ type -a mysql

On Windows, we can use the GUI and check the package manager via the control panel.

We can see if the MySQL server is running...

The rest of the chapter is locked

Register for a free Packt account to unlock a world of extra content!

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 $15.99/month. Cancel anytime

Authors (4)

David Mark Clements

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

Matteo Collina

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

Elger

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

Mathias Buus Madsen

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

Other recommended products

Related to this chapter

The fourth edition of Node Cookbook covers the latest features and libraries of Node.js 14. With this recipe-based guide, you'll learn how to handle files, build simple web applications, and build your own modules using Node.js. You'll also be able to diagnose problems in your apps, handle security concerns, and deploy your apps to the cloud.

Nov 2020 17h 4m

Server Side development with Node.js and Koa.js Quick Start Guide

Server Side development with Node.js and Koa.js Quick Start Guide

Every developer wants to build modular and scalable web applications. Modern versions of the JavaScript language have made this possible in Node.js, and Koa is a Node.js framework that makes it easy. This book is the ideal introduction for JavaScript developers who want to create scalable serverside applications using Node.js and Koa.js.

Nov 2018 4h 24m

RESTful Web API Design with Node.js 10

RESTful Web API Design with Node.js 10

RESTful services have become the standard data feed providers for social services, news feeds, and mobiles. If you want to build fast REST APIs and want to deliver a large amount of data to millions of users, you'll find this book extremely useful. This book will teach you to create scalable RESTful applications based on the Node.js platform.

Apr 2018 5h 56m

Mastering Node.js

Mastering Node.js

Node.js with its strong features and ability to write server as well as client side code with JavaScript has become a popular choice amongst developers for building powerful web applications. This book is a deep dive into showing facets of Node which are helpful for creating highly concurrent and scalable real time applications.

Dec 2017 16h 36m

Web Development with MongoDB and Node

Web Development with MongoDB and Node

Node.js builds fast, scalable network applications while MongoDB is the perfect fit as a high-performance, open source NoSQL database solution. The combination of these two technologies offers high performance and scalability to build fast, scalable network applications. Together they provide the power to manage any form of data, as well as speed of delivery. This book will help you to get these two technologies working together to build web applications quickly and easily, with effortless deployment to the cloud. You will also learn about angular 4, which consumes pure JSON APIs from a hapi server.

Sep 2017 11h 0m

Node.js Web Development

Node.js Web Development

Node.js is a server-side JavaScript platform using an event-driven, non-blocking I/O model allowing users to build fast and scalable data-intensive applications running in real time. JavaScript is no longer just for browsers and this exciting introduction to Node.js will show you how to build data-intensive applications that run in real time. By the end of the book, you will develop a striking and robust web application using the latest features that Node.js has to offer.

May 2018 16h 24m

Node.js Design Patterns

Node.js Design Patterns

In this book, we will show you how to implement a series of best practices and design patterns to help you create efficient and robust Node.js applications with ease. We start by teaching you how to master the basics of Node.js development, such as its module systems and its event-driven asynchronous programming style. Next, you will learn how creational, structural, and behavioral design patterns can help you create modular and extensible software. Finally, we'll show you how Node.js applications can be distributed and scaled to create complex software architectures.

Jul 2020 22h 8m

Personalised recommendations for you

Based on your interests and search pattern

Modern Full-Stack React Projects

Modern Full-Stack React Projects

Full-Stack React Projects is a complete guide to learning full-stack web development, understanding the creation and integration of backend systems, and advancing your career as a frontend developer.

Jun 2024 16h 52m

Mastering Node.js Web Development

Mastering Node.js Web Development

Explore Node.js with practical examples that will teach you how to utilize open-source packages for real-world solutions. Gain the skills to develop and deploy server-side applications that enhance your client-side projects.

Jun 2024 25h 56m

Reactive Patterns with RxJS and Angular Signals

Reactive Patterns with RxJS and Angular Signals

This RxJS book will help you understand the core concepts of RxJS and provide practical patterns to make your code more reactive and declarative. You'll also understand Angular Signals, which provide another way to improve code reactivity.

Jul 2024 8h 28m

API Testing and Development with Postman

API Testing and Development with Postman

Whether you are a tester or a developer working with APIs, you'll be able to put your knowledge to work with this practical guide to using Postman. The book provides a hands-on approach to implementing and learning the associated methodologies that will have you up-and-running and productive in no time.

Jun 2024 11h 56m

FastAPI Cookbook

FastAPI Cookbook

This book helps you unlock the power of FastAPI to build high-performing web apps and APIs by taking you through the basics like routing and data validation through to advanced topics, such as custom middleware and WebSockets.

Aug 2024 11h 56m

Mastering Spring Boot 3.0

Mastering Spring Boot 3.0

This hands-on guide empowers you to develop scalable and efficient applications. You'll also learn microservices patterns, reactive programming, and security measures for building robust backend systems.

Jun 2024 8h 32m

Vue.js 3 for Beginners

Vue.js 3 for Beginners

Learning a new language by following video tutorials, blog posts, and documentation is a tiresome activity. This book will take you on an exciting journey of becoming a proficient Vue.js developer through a practical, step-by-step approach.

Sep 2024 10h 4m

Nuxt 3 Projects

Nuxt 3 Projects

This book is a comprehensive guide to Nuxt.js, which takes you from the basics to advanced topics. Uniquely, this book emphasizes practical, project-based learning, tackling real-world problems.

Jun 2024 7h 40m

Mastering Flask Web and API Development

Mastering Flask Web and API Development

The book is an introduction to Flask that will showcase its baseline, core, and advanced integration features to enable you to solve enterprise-related problems and issues in both web and API development.

Aug 2024 16h 28m

Full-Stack Web Development with TypeScript 5

Full-Stack Web Development with TypeScript 5

The book emphasizes best practices, debugging, performance optimization, and scalable code structure, helping you develop practical skills in frontend and backend development, database integration, and AI integration.