Sequelize Command Line and Migration

Sequelize ORM: Interacting with databases using Node

James Fielder Articles, Databases, Development Technologies & Tools, 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…

Parameterizing Queries in SQL

Parameterizing Queries for SQL Server

Clayton Neff Articles, Databases, Programming, SQL, SQL Server 2 Comments

This is just a short article (more of a blog-ette than a full blog) about some things we as developers need to consider when sending queries to Microsoft’s SQL Server. While some of this information may also be true for other flavors of database servers, these things are known to be true for SQL Server.

Native MongoDB to Sequelize with PostgreSQL

Native MongoDB to Sequelize with PostgreSQL

John Boardman Articles, Databases, Heroku, MongoDB, PostgreSQL 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, Articles, Databases, Development Technologies & Tools, SQL, 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 Articles, Databases, Development Technologies & Tools, Opinion, SQL 8 Comments

Attention: The following article was published over 13 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 …