While my goal is to help you configure Sequelize with Postgres, in the process we will be building a RESTful API. This confused me at first, but it’s just industry semantics - although PostgreSQL is the official name. 💡 Postgres and PostgreSQL are the same thing. You also need to have Node.js and PostgreSQL installed on your machine. To have the most success using this guide you should have a general command of JavaScript. Postico 🔍 (or any DB viewer for Postgres).Postgres 🗄 (I’m using Postgres.app for mac).This way you have a high-level sense of what tools you should be knowledgeable of, and what you can expect to extract from this guide. ‍ “Sequelize is a promise-based Node.js ORM for Postgres, MySQL, MariaDB, SQLite and Microsoft SQL Server.” - īefore we get moving, let me lay out the tools we’ll be using. Sequelize allows us to interact with a Postgres database using JavaScript instead of SQL. The simplest way to think of Object Relational Mapping is as a process for accessing a relational database - Postgres in our instance - from an object-oriented language like JavaScript. This guide will assist you with setting up a Node.js project, and installing Sequelize to allow for object relational database mapping between a Postgres database. _urlIf you’ve landed here, hopefully you’re looking for help getting data flowing from a Node.js and Express web application, to a PostgreSQL database with Sequelize as the O.R.M.

Postgres app or postgres