Its language is designed to perform CRUD (Create, Read, Update, Delete) operations on a database, it scales vertically and can perform complex queries across multiple tables of data. Postgres itself is an “object-relational database system that uses and extends the SQL language,” according to the official website. I quickly realized when landing my first engineering gig that it’s imperative to command knowledge of relational DBs (databases). And I can attest I’ve learned a ton by using MongoDB with Node.js - seeing data flowing and testing endpoints with Insomnia. Those of us who have only dabbled with the back-end, may have done a few tutorials using a non-relational database like MongoDB. Once we have data flowing properly, you can expand on this app’s build however you’d like - adding more routes or developing the front-end. 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.
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. If you’ve landed here, hopefully you’re looking for help getting data flowing from a Node.jsand Express web application, to a PostgreSQL database with Sequelize as the O.R.M.
0 kommentar(er)
