How do I connect a TypeScript Express app to a database?

How do I connect a TypeScript Express app to a database?

You can connect a TypeScript Express app to a database using an ORM like TypeORM or Sequelize. Which database are you using?

I'm using PostgreSQL. Can you show me a basic setup?

Sure! First, install TypeORM and the PostgreSQL driver with npm. Then, create a connection like this:

import { createConnection } from 'typeorm';

createConnection({
  type: 'postgres',
  host: 'localhost',
  port: 5432,
  username: 'yourUsername',
  password: 'yourPassword',
  database: 'yourDatabase',
  entities: [YourEntity],
  synchronize: true,
}).then(connection => {
  console.log('Connected to the database!');
}).catch(error => console.log(error));

What are entities in TypeORM?

Entities in TypeORM are classes that represent database tables. Each instance of an entity corresponds to a row in the table.