Why TypeORM?

Working with databases in JavaScript applications often feels like a juggling act—writing SQL, handling migrations, maintaining schemas, and ensuring type safety. TypeORM solves many of these challenges by providing:

• TypeScript support: leverage static typing for fewer runtime errors.
• Entity-based modeling: Work with database records as objects.
• Built-in migrations: Version control for your database schema.
• Multiple database support: Works with PostgreSQL, MySQL, SQLite, and more.

Getting Started with TypeORM

To set up TypeORM, you’ll need a Node.js project. First, install the package:

npm install typeorm reflect-metadata pg

(Replace pg with the database driver you need, such as mysql2 or sqlite3.)

Then, configure TypeORM by creating a data-source.ts file:

import { DataSource } from "typeorm";

export const AppDataSource = new DataSource({
  type: "postgres",
  host: "localhost",
  port: 5432,
  username: "youruser",
  password: "yourpassword",
  database: "yourdatabase",
  entities: ["src/entity/**/*.ts"],
  synchronize: true,
  logging: true,
});

Defining Entities

Entities in TypeORM are classes that map to database tables. Here’s a simple User entity:

import { Entity, PrimaryGeneratedColumn, Column } from "typeorm";

@Entity()
export class User {
  @PrimaryGeneratedColumn()
  id: number;  @Column()
  name: string;  @Column()
  email: string;
}

This approach allows you to work with User objects in your code without writing raw SQL.

Querying the Database

TypeORM provides a repository API to interact with the database:

const userRepository = AppDataSource.getRepository(User);
const newUser = userRepository.create({ name: "John Doe", email: "john@example.com" });
await userRepository.save(newUser);

const users = await userRepository.find();
console.log(users);

Handling Migrations

Unlike, synchronize: true which automatically updates the database schema (not recommended for production), migrations provide version control:

npm run typeorm migration:generate -- -n CreateUsers
npm run typeorm migration:run

This ensures changes are tracked and reversible.

Wrapping Up

TypeORM is an excellent choice for JavaScript and TypeScript developers who want an efficient way to manage databases. It streamlines schema definition, queries, and migrations while keeping everything type-safe and maintainable. If you’re working on a backend project with Node.js, it’s worth considering TypeORM for a structured and scalable database solution.