Hello everybody, I was checking the free racing scripts and got a little confused because one of them saves the static data (checkpoint coords) in a local file (think it was JSON) and the other one had it all in MySQL.
I am a front-end developer and usually don’t bother with backend but I want to develop my own resource and I want to know if I would benefit from saving everything in the MySQL db.
JSON is easier to integrate and doesn’t require any DB calls (duh) so better for that side performance-wise, nothing too wrong with saving coordinates in a DB though. If it’s meant to be edited a lot by players then JSON is the better choice here, at least in my experience
Besides saving the checkpoints upon track creation and possibly editing by allowed players I guess there won’t be much data manipulation. Optimally there will be 100-200 tracks at maximum but I doubt I would have to load them concurrently. I was concerned with the possible db size when exporting:importing data.
JSON would be a better fit in this case most likely, unless you do some really optimized DB stuff
1 Like
JSON it is then, thank you!