Book Image

Supercharging Node.js Applications with Sequelize

By : Daniel Durante
4 (1)
Book Image

Supercharging Node.js Applications with Sequelize

4 (1)
By: Daniel Durante

Overview of this book

Continuous changes in business requirements can make it difficult for programmers to organize business logic into database models, which turns out to be an expensive operation as changes to the database may result in errors and incongruity within applications. Supercharging Node.js Applications with Sequelize helps you get to grips with Sequelize, a reliable ORM that enables you to alleviate these issues in your database and applications. With Sequelize, you'll no longer need to store information in flat files or memory. This book takes a hands-on approach to implementation and associated methodologies for your database that will have you up and running in no time. You'll learn how to configure Sequelize for your Node.js application properly, develop a better sense of understanding of how this ORM works, and find out how to manage your database from Node.js using Sequelize. Finally, you'll be able to use Sequelize as the database driver for building your application from scratch. By the end of this Node.js book, you'll be able to configure, build, store, retrieve, validate, and associate your data from a database to a Node.js application.

Related Content you might be interested in

Current Title:

Small book image
Supercharging Node.js Applications with Sequelize
Daniel Durante
Oct, 2022 | 266 pages
Small book image
Server Side development with Node.js and Koa.js Quick Start Guide
Olayinka Omole
Nov, 2018 | 132 pages
Small book image
Creating Interfaces with Bulma
Dave Berning | Jeremy Thomas | Oleksii Potiekhin | Aslam Shah | Mikko Lauhakari
Nov, 2019 | 194 pages
Small book image
Full-Stack Web Development with GraphQL and React
Sebastian Grebe
Feb, 2022 | 472 pages
Table of Contents (16 chapters)
Preface
Preface
Who this book is for
What this book covers
To get the most out of this book
Download the example code files
Download the color images
Conventions used
Get in touch
Share Your Thoughts
Download a free PDF copy of this book
1
Part 1 – Installation, Configuration, and the Basics
Part 1 – Installation, Configuration, and the Basics
Free Chapter
2
Chapter 1: Introduction to Sequelize and ORM in Node.js
Chapter 1: Introduction to Sequelize and ORM in Node.js
Technical requirements
Introducing Sequelize
Advantages of using Sequelize over other alternatives
Installing the necessary applications, frameworks, and tools to help get you started
Configuring Sequelize within an Express application
Summary
3
Chapter 2: Defining and Using Sequelize Models
Chapter 2: Defining and Using Sequelize Models
Technical requirements
Defining models for a database
Exploring the various Sequelize data types and when to use them
Migrating schematic changes and data from Sequelize to the database
Manipulating and querying data using Sequelize
Advanced Sequelize options for defining models
Summary
4
Part 2 – Validating, Customizing, and Associating Your Data
Part 2 – Validating, Customizing, and Associating Your Data
5
Chapter 3: Validating Models
Chapter 3: Validating Models
Technical requirements
Using validations as constraints
Creating custom validation methods
Executing validations while performing asynchronous operations
Handling validation errors
Summary
6
Chapter 4: Associating Models
Chapter 4: Associating Models
Technical requirements
Association methods
Relationship patterns
Querying associations with eager loading and lazy loading
Using advanced association options
Applying associations to Avalon Airlines
Summary
7
Chapter 5: Adding Hooks and Lifecycle Events to Your Models
Chapter 5: Adding Hooks and Lifecycle Events to Your Models
Technical requirements
Order of operations for lifecycle events
Defining, removing, and executing lifecycle events
Using lifecycle events with associations and transactions
Putting it all together
Summary
References
8
Chapter 6: Implementing Transactions with Sequelize
Chapter 6: Implementing Transactions with Sequelize
Technical requirements
Managed and unmanaged transactions
Running transactions concurrently
Isolation levels and advanced configuration
Putting it all together
Summary
9
Chapter 7: Handling Customized, JSON, and Blob Data Types
Chapter 7: Handling Customized, JSON, and Blob Data Types
Technical requirements
Querying JSON and JSONB data
Using the BLOB column type
Creating custom data types
Putting it all together
Summary
10
Part 3 – Advanced Queries, Using Adapters, and Logging Queries
Part 3 – Advanced Queries, Using Adapters, and Logging Queries
11
Chapter 8: Logging and Monitoring Your Application
Chapter 8: Logging and Monitoring Your Application
Technical requirements
Configuring logging with all of the available interfaces
Integrating third-party logging applications such as Pino or Bunyan
Collecting metrics and statistics for Sequelize with OpenTelemetry
Summary
12
Chapter 9: Using and Creating Adapters
Chapter 9: Using and Creating Adapters
Technical requirements
Installing, configuring, and integrating AdminJS with Sequelize
Integrating Sequelize with GraphQL
Creating our own adapter
Summary
13
Chapter 10: Deploying a Sequelize Application
Chapter 10: Deploying a Sequelize Application
Technical requirements
Refactoring and adding flight schedule routes
Integrating Express’ static middleware and securing the admin interface
Creating a page to list and book flights
Deploying the application
Summary
14
Index
Index
Why subscribe?
15
Other Books You May Enjoy
Other Books You May Enjoy
Packt is searching for authors like you
Share Your Thoughts
Download a free PDF copy of this book

Introduction to Sequelize and ORM in Node.js

Managing database drivers, managing schematics, maintaining a business’ workflow, and validating data can be daunting for any programmer. Along with perpetually changing business requirements, organizing the business logic into database models can be cumbersome. This usually entails the programmer finding all applicable references and updating queries manually. This could be an expensive operation for both the project and the programmer; without proper testing, the modifications could result in errors within the application or erroneous logic, leaving the programmer, the business, and the customer in a state of confusion.

This book will help guide you through the process of installing, building, maintaining, upgrading, extending, querying, and applying database schematics using an object-relational mapping (ORM) framework in a Node.js application using the Node.js runtime environment. The book can be read from start to finish in a sequential manner, or if you are more experienced, you can read the chapters that interest you directly. Each chapter complements the previous chapter since we will be creating an entire application from scratch. However, more experienced programmers can skip between chapters with the understanding that there may be “gaps” within their data model and what is shown within the chapter. The concepts and methodologies taught in each chapter, regardless of your data’s structure, will still be applicable.

The goal of this chapter is to help you become familiar with what Sequelize is and which capabilities are offered to you from using Sequelize. We will go over the necessary prerequisite steps for installing applicable libraries, frameworks, runtime engines, and database management systems (DBMS). By the end of this chapter, you will have acquired the knowledge and skillset of installing, configuring, and running an application, under the Node.js runtime with Sequelize, from scratch.

The first chapter of this book will cover the following topics:

  • Introducing Sequelize
  • Advantages of using Sequelize over other alternatives
  • Installing the necessary applications, frameworks, and tools to help get you started
  • Configuring Sequelize within an Express application
Previous Section
End of Section 1
Next Section