I’m trying to make my first API with an accompanying website, and I’m using tutorials. I decided the MERN stack was the way to go, since it seemed popular and easy.
I have some experience with SQL itself, but have never connected a database to an actual application.
So I got to the point of making my database in mongoDB when I saw some stuff about how mySQL is more secure than noSQL, and how noSQL has some disadvantages.
The api/website I’m making is just a pet project, but if it ever does become popular, would I have to move my databases? Or is this a “cross that bridge if/when I get there” situation?
Alternatively can I have the same database in multiple places at once? As in, bot mySQL and noSQL?
It is a “cross that bridge if/when I get there” situation.
Second the “Jump off that bridge when we get to it” sentiment.
Also IMHO: Don’t worry about it a whole lot. If it’s required you can “fix” a whole lot with just brute forcing better hardware and smaller performance tweaks. And if it really requires a major change, the short term fixes can buy the time to develop larger changes.
But as a pet project, just to get more experience and learn stuff. Sure go ahead, connect it to two databases with wildly different architectures. Why not do three? For learning stuff, doing something really weird often teaches a lot, even if the end result might not be very useful.
Well, then I guess I’ll worry about it if it becomes an issue.