Proper way to create connection to db in Typeorm - Nodejs

Question

I'm newbie to typeorm and trying to create a connection to db. I read the typeorm's doc and found this code, it uses DataSource to create connection:

import "reflect-metadata"
import { DataSource } from "typeorm"
import { Photo } from "./entity/Photo"

const AppDataSource = new DataSource({
    type: "postgres",
    host: "localhost",
    port: 5432,
    username: "root",
    password: "admin",
    database: "test",
    entities: [Photo],
    synchronize: true,
    logging: false,
})

AppDataSource.initialize()
    .then(() => {
        // here you can start to work with your database
    })
    .catch((error) => console.log(error))

But when searching for some references in other sources, they use createConnection instead:

import { createConnection } from "typeorm"

createConnection({
  type: "mysql",
  host: "localhost",
  port: 3306,
  username: "root",
  password: "mysql",
  database: "mysql",
  entities: [
     __dirname + "/entity/*.ts"
  ],
  synchronize: true,
  logging: false
}).then(async connection => {
…
…
}).catch(error => console.log(error));

I'm a bit confused. What approach should I use for creating connection to db between those two above?

I am also facing the same confusion. Did you get any reference for this? — Sid
– Sid, Commented Jun 5, 2022 at 9:34

Troncoso · Accepted Answer · 2022-06-22 21:50:31Z

9

For the next person that comes across this issue, createConnection has been deprecated in favor of using new DataSource. See here:

https://typeorm.io/changelog#030httpsgithubcomtypeormtypeormpull8616-2022-03-17

answered Jun 22, 2022 at 21:50

Troncoso

2,4635 gold badges35 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Proper way to create connection to db in Typeorm - Nodejs

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related