JavaScript (Node.js) and Databases: A Practical Guide

This book is a practical guide to integrating Node.js with modern databases. You will learn how to design schemas, write efficient queries, and build reliable backend systems. The author systematically covers three key types of storage: relational (PostgreSQL), document-oriented (MongoDB), and caching (Redis).

The book is structured as a series of practical projects: from a simple note-taking application to a full-fledged booking system with transactional logic and caching. Each chapter contains ready-to-run code examples that you can modify.

What you will learn:

• Schema design and data normalization in PostgreSQL
• Writing complex SQL queries: JOIN, subqueries, window functions
• Working with ORMs (Sequelize, Prisma) and writing raw queries
• MongoDB: schemas, indexes, aggregations, and geospatial queries
• Redis: caching, task queues, Pub/Sub, and sessions
• Transactions, locks, and ACID in Node.js
• Migrations, backups, and database monitoring
• Performance optimization: profiling, indexes, connection pooling

Who this book is for:

• Beginner Node.js developers who want to master working with databases
• Backend developers transitioning from other languages to JavaScript
• Fullstack developers looking to deepen their knowledge of data storage
• IT course students and graduates preparing for real-world projects

The book does not require deep prior knowledge — just a basic understanding of JavaScript and Node.js. All concepts are explained from scratch, with a focus on practice. You will get ready-made patterns for working with PostgreSQL, MongoDB, and Redis that you can immediately apply to your projects.

At the end of the book, you will find a chapter on common mistakes and how to avoid them, as well as a checklist for choosing the right database for a specific task. This is an essential reference for any Node.js developer working with data.