Book Image

Node Web Development - Second Edition

By : David Herron
Book Image

Node Web Development - Second Edition

By: David Herron

Overview of this book

Table of Contents (17 chapters)
Node Web Development Second Edition
Credits
About the Author
Acknowledgement
About the Reviewers
www.PacktPub.com
Preface
Index

Storing notes the ORM way with the Sequelize module


There are other popular SQL databases and for each there is a module of the sort we just saw with SQLite3. These modules put the programmer close to the SQL, which can be good in the same way that driving a stick shift car is fun. Other modules provide a higher level interface and even offer the ability to use the data model with several databases.

ORM stands for Object-Relation Mapping, and is a methodology to map high level objects onto database tables.

The Sequelize module (http://www.sequelizejs.com/) can connect with SQLite3, MySQL, and PostgreSQL. It provides an ORM approach to these three SQL databases.

A prerequisite is to have access to a suitable database server. Most web hosting providers offer MySQL or PostgreSQL as part of the service.

Schema setup and model code

In Sequelize the schema is defined in JavaScript code you write in your module. This means schema setup is not a separate step, written in SQL, like it was with SQLite3...