Matched title to contents. Clarified grammar. Removed topic of "standard" or "accepted" solutions, as popular choices aren't necessarily the right choices.

Source Link

edited Jun 17, 2014 at 8:04

Anko

13.5k
10
56
82

Storing How should I store grid-based character storage informationinventories in the database?

Is there a standard way or the best way to store storage/inventory data in the database?

The one I used to do is encode the whole inventory data into binary but I'm thinking of doing something different now.

The inventory has a 8x8 slots. 64 total spacesslots in an 8×8 grid. ItemsLarge items like weapons fillsfill up 6 to 8 vertically rectangular slots in a vertical rectangle, while potions fills uptake 1 slot.

How would you store this data in thea database?

Tweeted twitter.com/#!/StackGameDev/status/478804580201816064

occurred Jun 17, 2014 at 7:41

Source Link

asked Jun 16, 2014 at 3:25

majidarif

241
3
15

Storing character storage information

Is there a standard way or the best way to store storage/inventory data in the database?

The one I used to do is encode the whole inventory data into binary but I'm thinking of doing something different now.

The inventory has a 8x8 slots. 64 total spaces. Items like weapons fills up 6 to 8 vertically rectangular slots while potions fills up 1 slot.

How would you store this data in the database?

Stack Exchange Network

Return to Question

Storing How should I store grid-based character storage informationinventories in the database?

Storing character storage information

How should I store grid-based character inventories in the database?

Storing character storage information