Connecting to Aurora Serverless V1 via typeorm

0

I'm currently connecting to an Aurora Serverless V1 postgres database using typeorm via Data API. I've been experiencing issues due to the hard limits on the quotas for Data API. Is there another way to connect to an Aurora Serverless V1 database via typeorm so that Data API does not have to be used?

已提問 1 年前檢視次數 490 次
1 個回答
0

You can connect to an Aurora Serverless V1 database using TypeORM without using the Data API.

configure the TypeORM connection in your project. Create an ormconfig.json file

{
  "type": "postgres",
  "host": "your_aurora_serverless_host",
  "port": 5432,
  "username": "your_username",
  "password": "your_password",
  "database": "your_database_name",
  "synchronize": true,
  "logging": false,
  "entities": [
    "src/entity/**/*.ts"
  ],
  "migrations": [
    "src/migration/**/*.ts"
  ],
  "subscribers": [
    "src/subscriber/**/*.ts"
  ],
  "cli": {
    "entitiesDir": "src/entity",
    "migrationsDir": "src/migration",
    "subscribersDir": "src/subscriber"
  }
}

Connect to the Aurora Serverless database using TypeORM in your code

import { createConnection } from 'typeorm';

async function main() {
  try {
    const connection = await createConnection();
    console.log('Connected to the Aurora Serverless database');
  } catch (error) {
    console.error('Error connecting to the Aurora Serverless database:', error);
  }
}

main();
profile picture
專家
已回答 1 年前
  • Thanks for the detailed answer.

    I'm using typeorm version 0.3.10, where createConnection is deprecated and the way to connect to a database is by creating a DataSource object and initialising it to create the connection. Unfortunately, typeorm timesout trying to connect to aurora serverless V1 in the way you specified.

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南