Handmade Hero » Forums » Code » Data in Games
msmshazan
Shazan Shums
162 posts

Some day I will make quality software.
Programming FTW.

#10154 Data in Games
8 months, 3 weeks ago

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.

Just being curious on programming....
mmozeiko
Mārtiņš Možeiko
1477 posts
1 project
#10156 Data in Games
8 months, 3 weeks ago

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.
msmshazan
Shazan Shums
162 posts

Some day I will make quality software.
Programming FTW.

#10198 Data in Games
8 months, 3 weeks ago Edited by Shazan Shums on Jan. 3, 2017, 9:04 a.m.

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.

Just being curious on programming....
mmozeiko
Mārtiņš Možeiko
1477 posts
1 project
#10200 Data in Games
8 months, 3 weeks ago Edited by Mārtiņš Možeiko on Jan. 3, 2017, 9:55 a.m.

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
msmshazan
Shazan Shums
162 posts

Some day I will make quality software.
Programming FTW.

#10202 Data in Games
8 months, 3 weeks ago

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.

Just being curious on programming....
strangezak
Zakary Strange
44 posts
3 projects

A C++ Programmer working on Squad professionally, and Proportion during my free time.

#10204 Data in Games
8 months, 3 weeks ago

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

An angry programmer.
FelixK15
Felix Klinge
6 posts

Software Developer at Deck13 Interactive. Currently working on "The Surge". In the past I worked on "Anno2205" and "Lords of the Fallen".

#10211 Data in Games
8 months, 3 weeks ago Edited by Felix Klinge on Jan. 3, 2017, 10:20 p.m.

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.