Getting Started With PostgreSQL and Sequelize in 4 Minutes

As a developer, I always look forward to finding articles that explain complex topics in an easy but short form.

I am trying to flex my powers to see how I can get you to understand this in less than 5 minutes, so I don’t become what I despise 😄.

In this article, I will cover the following:

• Object Relational Mapping
• What is sequelize?
• What is PostgreSQL?
• Creating and connecting to database
• Performing simple CRUD operation
• Final thoughts

Object Relational Mapping: This is a technique that lets us make queries and manipulate data from a relational database using an object-oriented paradigm. It means the code needed to operate the database has been encapsulated, so we do not have to use SQL anymore; look at that 😄.

Sequelize: It’s a promise-based (something that gives us a result in the future but could be fulfilled or rejected, just like people make or break promises in reality) ORM in NodeJs, which provides us with functionalities to manipulate SQL based databases.

PostgreSQL: This database is considered the most advanced relational database system. One of the reasons is that it offers more complex data types and allows objects to inherit properties.

I will show you how we can use these tools to create data and make simple queries.