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.

Here are some info from RPG games that use SQL databases:
MSSQL for Eve Online http://highscalability.com/eve-online-architecture & https://web.archive.org/web/20100...-evolved-eve-onlines-server-model
MSSQL for GuildWars http://www.dbms2.com/2007/06/09/t...atabase-technology-of-guild-wars/
Oracle for WoW https://news.ycombinator.com/item?id=8153781 & http://augustl.com/blog/2014/that_wow_server_blade/

Handmade Hero has a chat. It's on IRC - https://handmade.network/blogs/p/1138 Join the #dev or #hero channel.

I have added sqlite3 using static linking to my project should I link dynamically or compile the source in the project itself.

And what does the callback in sqlite does i'm so confused.

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

Thanks Mr.Martins for the info guess I don't need callbacks anyway.

Do you know any good library for GUI I prefer a c api because c++ libraries are too hard to setup anyways.

I am currently using nuklear .
Any suggestion would be helpful.

Nuklear, and dear IMGUI are the only ones i know of.

There's also an IMGUI library from Nvidia.
You can find the repo here.

I guess it is not supported anymore as the last update was in 2008.
Just listing it as an alternative.

--

Most people I know however use either imgui for small projects,
or Qt / WxWidgets for larger projects.