A simple Node.js application demonstrating database migrations with PostgreSQL using node-pg-migrate.

• PostgreSQL database integration
• Database migrations using node-pg-migrate
• Environment-based configuration
• Simple todo management system

• Node.js (v14 or higher)
• PostgreSQL database server
• npm (Node Package Manager)

├── migrations/
│   └── 1698765432345_create-todos-table.js
├── .env.example
├── .env
├── index.js
├── package.json
└── README.md

1. Clone the repository
2. Install dependencies:

   npm install

3. Create a .env file based on .env.example:

   cp .env.example .env

4. Update the .env file with your PostgreSQL connection details:

   DATABASE_URL=postgres://username:password@localhost:5432/database_name
   

This project uses node-pg-migrate for managing database schema changes.

• Run all pending migrations:

  npm run migrate:up

• Revert the last migration:

  npm run migrate:down

1. 1698765432345_create-todos-table.js
   • Creates the initial todos table with:
     • id (Primary Key)
     • title (varchar)
     • completed (boolean)
     • created_at (timestamp)

Start the application:

npm start

The application will:

1. Connect to the PostgreSQL database
2. Display the current timestamp
3. List all todos in the database

• Never commit the .env file to version control
• Keep your database credentials secure
• The .env.example file should not contain actual credentials

• npm start - Run the application
• npm run migrate - Run database migrations
• npm run migrate:up - Apply pending migrations
• npm run migrate:down - Revert the last migration

• pg - PostgreSQL client for Node.js
• node-pg-migrate - Database migration tool
• dotenv - Environment variable management