Sequelize Command Line and Migration

Sequelize ORM: Interacting with databases using Node

James Fielder Databases, Development Technologies, Programming Leave a Comment

Today, we are going to be going over a very useful tool called Sequelize. It is an Object Relational Mapper (ORM), which allows us to interact with relational databases using Node.js.

Sequelize supports many different databases, but in this blog, we will be using MySQL. We will go over how to set up a local MySQL instance and a Node.js server using Sequelize to communicate with it.

Along the way, we’ll learn basic Sequelize functionally, such as the command line tool and migrations, to understand how to work with the database…

Native MongoDB to Sequelize with PostgreSQL

Native MongoDB to Sequelize with PostgreSQL

John Boardman Databases, Heroku, MongoDB, PostrgreSQL Leave a Comment

Every long-term project will outlive at least some of the technologies it was originally built with. For example, a project I have been involved with recently ran into this situation. The app is hosted on Heroku, and over the years, the available MongoDB add-ons have changed and dwindled until now, there is only one.

Several migrations between MongoDB add-ons have already happened because of shutdowns. So, it was decided that rather than migrating to the last one still in existence, the project would switch to using PostgreSQL, which is supported directly by the Heroku team.

Web Development Business

Creating a SQL Database Project for Isolated Development

Rusty Divine .NET, Databases, Development Technologies, Tutorial 2 Comments

In this article you see how to create a database project that will let you quickly and consistently deploy a database to your local environment. This approach can help to solve some issues from team members interfering with each other’s work on a shared development database.

Then, in an upcoming article, we will show you how to take the next step to include this database project in your continuous integration process and deploy it to each environment up the chain to production so that you can eliminate the need for any direct interaction with database updates.

Is NoSQL The SQL Sequel?

Lou Mauget Databases, Development Technologies, Opinion 8 Comments

Attention: The following article was published over 12 years ago, and the information provided may be aged or outdated. Please keep that in mind as you read the post.“Can’t we all just get along?”  I assert that the explosion of so-called NoSQL database management systems (DBMS) is not displacing the well-known relational DBMS (RDBMS) that we love and admire. There …