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?
I don’t fully understand the technical aspects, but I get the gist of what you’re saying. Overcomplicating code is something I’m sometimes guilty of. I will try to make the code as “flexible” as possible to allow for changes later down the line if needed. Also, I’ve never done anything in Lua besides making stuff in Roblox Studio 😅. You really know your stuff hus?
I’ve been doing this since 2001 and I’m a big fan of openresty.