How data storage and manipulation works in ARPG's like diablo and torchlight ? Is handmade hero is going to be an item heavy game? How to implement large databases for games I'm thinking of using SQLite or is it a bad idea?
All comments appreciate and doesn't handmade hero have a chat.
Some MMORPG's run some kind of SQL on server. Some have custom designed ones.
The thing is - they don't run just one instance. They have large infrastructure with distributed databases, replication and other stuff to balance load.
You can easily start with SQLite. For single player RPG that will be fine. But if you want to go MMRPG route then just using one SQL instance won't work at the end. You need to figure out what kind of load your databases need to expect and design your systems to handle that load. That includes hardware specs. So its not really a question about which database to use, its usually a question about how to use it and how to manage the data.
It doesn't matter how you link. It will work in same way where you link statically or dynamically. Link in whatever way it is easier to use or deploy for you.
About which callback are you talking about? SQLite has many different callbacks. But none is actually required to use it. Read up the documentation, sqlite has very good docs: https://www.sqlite.org/docs.html