Database driven articles

Ask a Question related to Coldfusion Database Access, Design and Development.

  1. #1

    Default Database driven articles

    Hello,

    I am supernew to ColdFusion and to these forums, and I'm sorry if this is an
    overly obvious/retarded question. That said:

    I am develping a site which will have regularly updated articles. I want to
    have the latest ones displayed on the front page, and the older ones saved in
    an archive. I figured that a database would be the best means to this end -- I
    could store the article, the author, the date, the catagory, the title, and the
    content. My question is essentially this, is this a good way to create the
    site? My concern is that some of the articles will be pretty long (5-20
    paragraphs) and I wonder if this will bog down the database. With all of the
    basic querying going on, would all of this extra data get in the way? Should I
    store the article data seperately somewhere else? Also, if I am on the right
    track, would it make a major difference which database I use?

    I think I explained that clearly enough.

    Thank you in advance/I apologize in advance,
    PlastechFish

    PlastechFish Guest

  2. Similar Questions and Discussions

    1. Database driven CMS and Contribute
      I am looking to create a hybrid of contribute and database driven CMS (like Joomla or Drupal). Anyone ever tied to do anything similar? Any...
    2. Database Query Only Show Current Month Articles
      Right now we are having to go in and manually change the date to only show this month and years articles, but we'd like to change the query so we...
    3. database driven query
      Hello All, I am try to create a dynamic search page where the admin would create the fields or dropdowns for the user to select. For this example,...
    4. Database driven web site
      Hi, I want to create a website where people can sign up to the site and put there company details on it. Then when a user searches for a...
    5. database driven website using SAN
      We want to develop database driven website. because of enormous amount of data (300GB) customers's tech advisor is insisting on using SAN instead...
  3. #2

    Default Re: Database driven articles

    Yes, this is the correct way to do it.

    No, it will not bog down the db

    An enterprise db will always be better (sql server, oracle, ect...), but they
    cost money
    You could also use ms access
    You could also use mySql (free)

    But any db will depend upon your site host (if the site is being hosted), as
    to what db's they offer

    Ken

    The ScareCrow Guest

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139