SitePoint Sponsor

User Tag List

Results 1 to 7 of 7
  1. #1
    SitePoint Zealot
    Join Date
    Sep 2004
    Location
    new york
    Posts
    113
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Data storage for cms

    I'm building a CMS system for some coding practice, and I'm currently trying to figure out whether it is best to store the html body of each page in a MySQL database or in seperate files.

    As far as I can tell this seems to be a matter of preference only - provided one ensures that no harmful code can be added to the database (e.g. use bbcode or similar).

    Have I missed an important aspect of this part of my project?

  2. #2
    SitePoint Author silver trophybronze trophy
    wwb_99's Avatar
    Join Date
    May 2003
    Location
    Washington, DC
    Posts
    10,576
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    Database is much cleaner in general, but both will get the job done.

  3. #3
    SitePoint Zealot
    Join Date
    Sep 2004
    Location
    new york
    Posts
    113
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks for the reply!

    I am finding that too. A database solution is also proving easier to implement.

  4. #4
    Are You There? KDesigns's Avatar
    Join Date
    Oct 2003
    Location
    Your Monitor
    Posts
    1,147
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I believe a database will almost always prove easier to implement and better to use.
    ChooseDaily.com - Follow on Twitter
    Top Resources for Web Designers and Developers Every Day!

  5. #5
    SitePoint Wizard stereofrog's Avatar
    Join Date
    Apr 2004
    Location
    germany
    Posts
    4,324
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    It depends.

    Templates stored in database can be changed from within your CMS only, but some (most?) people prefer to edit their templates in an external editor like Dreamweaver and just upload them per FTP, so the file solution seems to be more flexible and friendly.

  6. #6
    Obsessive designer Infizi's Avatar
    Join Date
    May 2004
    Location
    North Pole
    Posts
    450
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    i have a made a few CMS, and i normally use html templates under a templates folder,

    it allows my clients to easily change thir pages using Dreamweaver, FrontPage, or even CPanels WysiwygPro HTML editor
    New Design - PHP Slowly flowing in!

    Infizi Studio's

  7. #7
    SitePoint Zealot
    Join Date
    Sep 2004
    Location
    new york
    Posts
    113
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Is there any consesus on a CMS that has a good design - ie. a good model to learn from? I realize that Mambo and ezPublish a great CMS's, but they are pretty complex and not ideal to learn from (a bit too complicated for me anyway).

    I guess there is no real replacement for experience, but it would be great to look at a good design and fast forward my learning a bit. I find myself going back and forth on a lot of issues and not being able to decide what is really the best way to go about doing something. My html data storage question is an example of this...


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
  •