❔ Dev/prod databse
Hello,
Me and a friend wants to create a webb-app project with a react frontend and C# backend.
The idea was to use AWS RDS with mySQL for the final product.
To my question - what are the pros and cons/best practise of:
Set up and use a RDS(public so we both can acess it from our local) database from the start.
VS
We both use local mySQL for development and configure a "private" RDS at a later stage when the app is deployed on AWS?
Whats the most common way to approach this?
Thanks in advance! 🙂
4 Replies
Not sure how other do it, I'd have 3 databases / environments
Production (AWS)
Development (AWS)
Local (Localhost)
The reason is that if you guys are trying to modify the database at the same time, it could break things. The workflow should be you do your database migrations (add, remove columns, etc.) locally then git push / merge and deploy the changes to development. And if everything looks good then push the migrations to production.
But if it is just a fun / side project AND only one of you will work on the backend and the database, then do it all on AWS, who cares.
But if you think it might go live one day, then you should have some kind of workflow going. Also you can go crazy with test data on local without affecting anyone.
Also security best practices: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_BestPractices.Security.html
Security best practices for Amazon RDS - Amazon Relational Database...
Use AWS Identity and Access Management (IAM) accounts to control access to Amazon RDS API operations, especially operations that create, modify, or delete Amazon RDS resources. Such resources include DB instances , security groups, and parameter groups. Also use IAM to control actions that perform common administrative actions such as backing up...
@BananaPie Sounds like a good idea! Im a little bit confused - do you mean that you push your database-changes? 🙂
yes, correct
something like EF Core to manage your migrations / database changes
Looks like nothing has happened here. I will mark this as stale and this post will be archived until there is new activity.