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?

preguntada hace un año490 visualizaciones
1 Respuesta
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
EXPERTO
respondido hace un año
  • 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.

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas