What ORM tools have you used in your projects?

In my Node.js projects, I actively used Sequelize and TypeORM.

Sequelize is a proven ORM that supports many databases (PostgreSQL, MySQL, SQLite, SQL Server). It is well-suited for projects where TypeScript is not used or when a more traditional approach to database work is required.

Example of using Sequelize with PostgreSQL:

// Defining the User model
const User = sequelize.define('User', {
  firstName: {
    type: DataTypes.STRING,
    allowNull: false
  },
  lastName: {
    type: DataTypes.STRING
  }
}, {
  // Other model options
});

// Creating a record
async function createUser() {
  const jane = await User.create({ firstName: "Jane", lastName: "Doe" });
  console.log("Jane's auto-generated ID:", jane.id);
}

TypeORM is a more modern ORM written in TypeScript, actively using decorators. It supports many databases and offers a flexible approach to working with entities and relations. TypeORM integrates well with TypeScript projects, providing strong typing.

Example of using TypeORM with PostgreSQL:

// Defining the User entity
import { Entity, PrimaryGeneratedColumn, Column } from "typeorm";

@Entity()
export class User {
  @PrimaryGeneratedColumn()
  id: number;

  @Column()
  firstName: string;

  @Column()
  lastName: string;
}

// Creating a record
import { AppDataSource } from "./data-source";

async function createUser() {
  await AppDataSource.initialize();
  const userRepository = AppDataSource.getRepository(User);

  const jane = new User();
  jane.firstName = "Jane";
  jane.lastName = "Doe";

  await userRepository.save(jane);
  console.log("Jane's auto-generated ID:", jane.id);

  await AppDataSource.destroy();
}

The choice between these ORMs depends on the project stack, typing requirements, and team preferences. Both ORMs have proven to be reliable and functional tools for working with databases in Node.js.