In an update for my blogging platform, I needed to add a thumbnail image column to make the articles more visually appealing. This update accompanied a shift from displaying all articles on a single page to showing each one on its own page, improving navigation as the number of articles grows.
The thumbnail column stores a string representing a link to an image. This approach keeps the database lightweight and separates concerns by handling image storage elsewhere.
Adding the New Column to the Model
To begin, I updated the BlogPosts model to include the thumbnail column. Setting allowNull: true ensured that adding a thumbnail was optional and avoided issues with older posts that didn’t have a thumbnail yet:
thumbnail: { type: DataTypes.STRING, allowNull: true, // Optional for older posts },
However, this change to the model alone wasn’t enough. The Postgres database didn’t recognize the new column, and I encountered the error:
error: the column "thumbnail" doesn't exist
This happens because Sequelize models define how the application interacts with the database, but they don’t automatically modify the database schema. To resolve this, I needed to use a Sequelize migration.
Preparing Sequelize for Migrations
Before creating the migration, I ensured the Sequelize CLI was initialized in the project. Before running the following command, which will create a config/ folder and related setup, be sure to install it first by entering npm install sequelize-cli
npx sequelize-cli init
Inside the config/ folder, I opted to use a config.js file instead of config.json. This allowed me to use environment variables with dotenv for configuration:
require('dotenv').config(); module.exports = { development: { username: process.env.DB_USER, password: process.env.DB_PASSWORD, database: process.env.DB_NAME, host: process.env.DB_HOST, dialect: "postgres", }, production: { username: process.env.DB_USER, password: process.env.DB_PASSWORD, database: process.env.DB_NAME, host: process.env.DB_HOST, dialect: "postgres", }, };
I then removed the config.json file to avoid conflicts.
Generating the MIgration File
Next, I created the migration file for adding the thumbnail column using the following command:
npx sequelize-cli migration:generate --name add-thumbnail-to-blogposts
This created a new file in the migrations/ folder, named something like:
20241206232526-add-thumbnail-to-blogposts.js
I modified this file to add the new column:
module.exports = { up: async (queryInterface, Sequelize) => { await queryInterface.addColumn('blogposts', 'thumbnail', { type: Sequelize.STRING, allowNull: true, }); }, down: async (queryInterface) => { await queryInterface.removeColumn('blogposts', 'thumbnail'); }, };
Applying the Migration
To update the development database, I ran the following command:
npx sequelize-cli db:migrate
This successfully added the thumbnail column to the blogposts table, enabling me to store image links for each article.
Applying the Migration in Production
For the deployed version of the database, I followed these steps:
Backup the Production Database: Before making changes, I downloaded a backup to safeguard against misconfigurations. Copy the Migration Files: I ensured the updated config.js file and add-thumbnail-to-blogposts.js migration file were present in the server repository. Set Environment Variables: I verified that the production environment variables required by dotenv were configured correctly. These were set in the Setup Node.js App section of cPanel. Run the Migration: I navigated to the backend app directory in the production terminal and ran:
npx sequelize-cli db:migrate --env production
This successfully added the thumbnail column to the production Postgres database.
Conclusion
Adding the thumbnail column made it possible to display images for each blog article, enhancing the platform's visual appeal and usability. These steps provide a structured and repeatable approach to adding new columns to the database using Sequelize migrations, which is critical for maintaining synchronization between the models and database.
The above is the detailed content of Steps to Add a New Column with Sequelize Migrations. For more information, please follow other related articles on the PHP Chinese website!

JavaScript is widely used in websites, mobile applications, desktop applications and server-side programming. 1) In website development, JavaScript operates DOM together with HTML and CSS to achieve dynamic effects and supports frameworks such as jQuery and React. 2) Through ReactNative and Ionic, JavaScript is used to develop cross-platform mobile applications. 3) The Electron framework enables JavaScript to build desktop applications. 4) Node.js allows JavaScript to run on the server side and supports high concurrent requests.

Python is more suitable for data science and automation, while JavaScript is more suitable for front-end and full-stack development. 1. Python performs well in data science and machine learning, using libraries such as NumPy and Pandas for data processing and modeling. 2. Python is concise and efficient in automation and scripting. 3. JavaScript is indispensable in front-end development and is used to build dynamic web pages and single-page applications. 4. JavaScript plays a role in back-end development through Node.js and supports full-stack development.

C and C play a vital role in the JavaScript engine, mainly used to implement interpreters and JIT compilers. 1) C is used to parse JavaScript source code and generate an abstract syntax tree. 2) C is responsible for generating and executing bytecode. 3) C implements the JIT compiler, optimizes and compiles hot-spot code at runtime, and significantly improves the execution efficiency of JavaScript.

JavaScript's application in the real world includes front-end and back-end development. 1) Display front-end applications by building a TODO list application, involving DOM operations and event processing. 2) Build RESTfulAPI through Node.js and Express to demonstrate back-end applications.

The main uses of JavaScript in web development include client interaction, form verification and asynchronous communication. 1) Dynamic content update and user interaction through DOM operations; 2) Client verification is carried out before the user submits data to improve the user experience; 3) Refreshless communication with the server is achieved through AJAX technology.

Understanding how JavaScript engine works internally is important to developers because it helps write more efficient code and understand performance bottlenecks and optimization strategies. 1) The engine's workflow includes three stages: parsing, compiling and execution; 2) During the execution process, the engine will perform dynamic optimization, such as inline cache and hidden classes; 3) Best practices include avoiding global variables, optimizing loops, using const and lets, and avoiding excessive use of closures.

Python is more suitable for beginners, with a smooth learning curve and concise syntax; JavaScript is suitable for front-end development, with a steep learning curve and flexible syntax. 1. Python syntax is intuitive and suitable for data science and back-end development. 2. JavaScript is flexible and widely used in front-end and server-side programming.

Python and JavaScript have their own advantages and disadvantages in terms of community, libraries and resources. 1) The Python community is friendly and suitable for beginners, but the front-end development resources are not as rich as JavaScript. 2) Python is powerful in data science and machine learning libraries, while JavaScript is better in front-end development libraries and frameworks. 3) Both have rich learning resources, but Python is suitable for starting with official documents, while JavaScript is better with MDNWebDocs. The choice should be based on project needs and personal interests.


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

PhpStorm Mac version
The latest (2018.2.1) professional PHP integrated development tool

ZendStudio 13.5.1 Mac
Powerful PHP integrated development environment

WebStorm Mac version
Useful JavaScript development tools

Safe Exam Browser
Safe Exam Browser is a secure browser environment for taking online exams securely. This software turns any computer into a secure workstation. It controls access to any utility and prevents students from using unauthorized resources.

Notepad++7.3.1
Easy-to-use and free code editor