Page 5 of 5 FirstFirst 12345
Results 41 to 43 of 43
  1. #41
    Senior Member Mirviriam's Avatar
    Join Date
    Apr 2008
    Location
    Where the moon cuts the wind.
    Posts
    259
    Downloads
    4
    Uploads
    0
    I'm doing a quick and dirty ruby on rails project to test some things for another project.

    The question I had here on how to implement multiple campaign's into the same database comes up again.

    I'm pondering a separate campaign cross connect table (pivot) for every table or faster method, stick the campaign_id into already existing cross connect tables.

    Example: Of the 2nd method (not the names I'd use or full listing of fields)

    Table #1: campaign_id, campaign_name
    x_table_1_2: campaign_id, person_id, isDM? //every participating in campaign & unlimited # of dms
    Table #2: person_id, person_name, username, password_hash, etc
    Table #3: province_id, province_name, province_owner_domain_id, etc
    x_table_3_4: province_id, domain_id, campaign_id // because if multiple campaigns we could have identical pairings of the first two ids
    Table #4: domain_id, domain_name, treasury_gold, treasury_rp, etc
    x_table_2_4: domain_id, person_id, campaign_id // multiple regents of domain & campaign allowance
    x_table_4_5: domain_id, holding_id, campaign_id // because if multiple campaigns we could have identical pairings of the domain & holding id
    Table #5: holding_id, holding_name, holding_level, etc

    I like the idea of doing it fast ... but I also like the idea of better normalization (campaign_id mapping to all other table's by their id in it's own cross or pivot table).

    What do you guys think?

    More normalized version would be the same as above, but remove campaign_id from x_table and have a second x_table_camaign (which holds campaign_id & id of whatever type it connects too)
    Last edited by Mirviriam; 11-12-2015 at 05:08 PM.
    Legacy of Kings: Member

  2. #42
    Special Guest (Donor)
    Join Date
    Nov 2001
    Location
    Spain
    Posts
    532
    Downloads
    11
    Uploads
    0
    Why not using just a single campaign per DB to avoid the extra where and column?

  3. #43
    Senior Member Mirviriam's Avatar
    Join Date
    Apr 2008
    Location
    Where the moon cuts the wind.
    Posts
    259
    Downloads
    4
    Uploads
    0
    Because none of the current companies (which were big enough to get noticed by me) that run web board games do, due to many database transactional costs. SQL servers can handle thousands of databases on their cluster, but a single sql database is built to hold millions of records without slowing down. Additionally, most hosting sites have database limits.

    I'd like to build it so if I do enjoy the work and have time - it would be usable by people besides me later on!
    Legacy of Kings: Member

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Birthright PC Game-control battle on multi
    By vota dc in forum The Royal Library
    Replies: 1
    Last Post: 06-29-2009, 08:40 AM
  2. My next campaign
    By Crazypostal in forum The Royal Library
    Replies: 6
    Last Post: 05-31-2007, 09:24 AM
  3. Campaign
    By Sorontar in forum BRWiki Discussions
    Replies: 5
    Last Post: 05-31-2007, 09:07 AM
  4. New Multi-Classing Rule.
    By geeman in forum The Royal Library
    Replies: 62
    Last Post: 09-25-2002, 09:34 PM
  5. Campaign
    By koraf_tdt in forum The Royal Library
    Replies: 11
    Last Post: 06-28-2002, 10:25 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
BIRTHRIGHT, DUNGEONS & DRAGONS, D&D, the BIRTHRIGHT logo, and the D&D logo are trademarks owned by Wizards of the Coast, Inc., a subsidiary of Hasbro, Inc., and are used by permission. ©2002-2010 Wizards of the Coast, Inc.