Thread: Best Database Software for RSPS/Runescape?

Page 5 of 5 FirstFirst ... 345
Results 41 to 42 of 42
  1. #41  
    Respected Member

    Join Date
    Jan 2009
    Posts
    5,682
    Thanks given
    1,093
    Thanks received
    3,494
    Discord
    View profile
    Rep Power
    5000
    For example the equipment table, do you have a new row per equipment slot or are you storing the whole array in a column? I don't see why you cannot have a column within the players table instead of a table dedicated just to the equipment.

    IE:

    Equipment -> Key, Value, Key, Value
    Reply With Quote  
     

  2. #42  
    Programmer, Contributor, RM and Veteran




    Join Date
    Mar 2007
    Posts
    5,074
    Thanks given
    2,625
    Thanks received
    3,578
    Discord
    View profile
    Rep Power
    5000
    Quote Originally Posted by Psyduck View Post
    For example the equipment table, do you have a new row per equipment slot or are you storing the whole array in a column? I don't see why you cannot have a column within the players table instead of a table dedicated just to the equipment.

    IE:

    Equipment -> Key, Value, Key, Value
    Each slot has an individual row - that is how you are supposed to use a relational database . Having lots of columns in your player table will be a maintenance nightmare!
    .
    Reply With Quote  
     

Page 5 of 5 FirstFirst ... 345

Thread Information
Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


User Tag List

Posting Permissions
  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •