SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Member
    Join Date
    Nov 2004
    Location
    Wisconsin
    Posts
    12
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Store Admin Tables in a Seperate DB???

    Lets say you have the following site structure:

    CMS with admin user and user role/permissions tables

    Main site with content submited through CMS by admin users along with an area for customer submitted info such as a mailing list a long with a forum.

    Would you store the admin/CMS info in a seperate DB than the tables that contain the info from the main site or would you keep them all in the same DB?

  2. #2
    SitePoint Enthusiast
    Join Date
    Feb 2006
    Posts
    32
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    If you use the admin/role/users tables in other applications too, I would put them in a seperate database. But if it's all information for the same application (website), then it belongs together in my opinion...
    http://www.messengerstyle.com/
    A collection of the best messenger and forum avatars.

  3. #3
    SitePoint Member
    Join Date
    Nov 2004
    Location
    Wisconsin
    Posts
    12
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks! I just wasn't sure if there was a general rule of thumb on keeping CMS\Admin tables seperate from the rest of the site's info.

  4. #4
    Afrika
    Join Date
    Jul 2004
    Location
    Nigeria
    Posts
    1,737
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I would put them all in the same db, what matters is how they are accessed by the calling application

  5. #5
    SitePoint Guru
    Join Date
    Aug 2003
    Location
    CT
    Posts
    643
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I agree, same database.

    IMO, 1 application gets 1 database. there's no reason for more than that. Setting proper permissions, and even using a view with persmission instead of granting permission directly to the table if need be.


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
  •