Investigate: technology stack for database (PostgresQL on AWS RDS)

[allishultes]

a few things to look into, and make some notes on

• how to do local development vs production development with AWS RDS
• Shall we use an ORM and if so which one? or should we just write SQL queries? (pros and cons/common approaches )
• What is a common setup for AWS RDS PostgresQL with express? using the AWS node SDK?
  • are there any example or previous projects we can have a look at?
• How to do database migrations, to create and initialise the schema.
• How to do database migrations to change the schema of the database, in node, AWS RDS, PostgresQL, SQL.

---

Stretch goal

• what are best practices to seed a test database with dummy data?

[allishultes]

Notes:

• Spoke with Tamsin about Vasey — she said it's still a good idea to have a test and live database so that we can test connections to the database, etc before going into production. But we should have one running locally for testing queries, building tables etc. Vasey wrapped its mysql database in a Docker container — Tamsin said it was easy to just download the image from there: https://github.com/bbc/newslabs-vasey-server

[pietrop]

Also worth consulting the security ADR the overall architecture might be out of date, but the security measure still stand.