C
C#big OOF

❔ 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! 🙂
B
BananaPie•414d ago
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...
BO
big OOF•414d ago
@BananaPie Sounds like a good idea! Im a little bit confused - do you mean that you push your database-changes? 🙂
B
BananaPie•414d ago
yes, correct something like EF Core to manage your migrations / database changes
A
Accord•413d ago
Looks like nothing has happened here. I will mark this as stale and this post will be archived until there is new activity.
Want results from more Discord servers?
Add your server
More Posts
❔ Book recommendation to learn c#/dotnetI've been programming in python for a little under two years. I am starting a new job in c#. Whats a❔ Use `this` inside method decoratorTried to follow https://stackoverflow.com/a/2966758 ```cs [AttributeUsage(AttributeTargets.Metho✅ How can I make VSCode auto add semicolons to statements on save?I'm coming from the world of Javascript and Typescript. There, you can just use Prettier to automati❔ Find common substring at start of every string in listI have a list of Windows path strings and I want to determine the common beginning shared by all of ❔ Code is completely skipping over an areaI'm writing a script for a game where if you don't press Spacebar within 4 seconds, the number of fa❔ Registering an extracted appx package```csharp public static void RegisterMinecraftAppxPackage(string appxPackagePath) { try { ✅ Exception Handling for NRE without modifying every call.I have a ReadData function which reads the memory of a process. If the process exits or crashes duri✅ please help idk what to do or what i didSeverity Code Description Project File Line Suppression State Error Project❔ Better user experience inputting commandsHow would I get input from a user, the fancy way? What I mean is that for example when a user types ❔ Return in the middle of a methodIs it ok? I think that it improves readability and performance, but a professor I know argues that i❔ Can't build a MSIX Package for a WPF app❔ Should photo urls be sent paginated to the frontend?So, any given property has a collection of photos in a photo album... they are saved as urls in the