Hey.I have a question about the usage of SQL related DB with your node apps. So far I've always worked with MongoDB. Recently however, I started a project with MySQL and I've found a bunch of issues while trying to refactor and heavily modify the tables. In the end I had to simply delete the DB and recreate a new one with the structure I wanted.This comes probably from my inexperience with SQL related DBs so I've wanted to ask to anyone using them in production how they handle structure modification? In MongoDD it's not an issue whatsoever, but MySQL gets mad when I try to move/delete a column or heavily restructure the DB. How is this done properly? Thanks.
Submitted March 16, 2019 at 08:39PM by NovelLurker0_0
No comments:
Post a Comment