Sorry if I wrote the title wrong, but we are creating a core and our own inventory system. Should we put inventory tables in SQL? (item names, weight, etc) or should we keep them strictly in code?
No idea what you mean, SQL is code as well as Lua, JS and whatever. Can you explain what you mean?
Keeping the inventory data in sql is nice for when you have a large amount of players. It generally scales better and allows you to write queries to pick apart the data you need. I’m going to assume if you keep it strictly in code your serializing your data and just doing read/writes to access the data, which might work for a while but if you plan to do something long term like creating your own core like you said, it might be in your best interest to use sql.