access vs sql

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • 10ashsd
    New Member
    • Aug 2007
    • 2
    #1

    access vs sql

    Hi, I'm new here but I'm lookin for some help.
    I need to create a DB that can put on the web. The DB will have about 500 entries. within each db entry I'll be adding multiple comments and archiving them for each entry.
    I would like to have this on the web, searchable and easily updated.
    Can any of you tell me which program would be better suited for this?
    Thank you,
    Tags: None
    • pbmods
      Recognized Expert Expert
      • Apr 2007
      • 5821
      #2
      Heya, 10ashsd. Welcome to TSDN!

      What software will your server be running (e.g.., Apache vs. IIS)?
      Do you have any previous database server experience?
      What sort of traffic do you anticipate?

        Comment

        • 10ashsd
          New Member
          • Aug 2007
          • 2
          #3
          I don't really know. I'm novice in this area. My ultimate goal is to have something on a server hosted from home which means not that many simultaneous users. less than 100.

          I'm certainly open to suggestions.

          even if you or someone on this forum could suggest some direction for learning I am certainly open to reading up on this stuff.
          Thank you,

            Comment

            • jhardman
              Recognized Expert Specialist
              • Jan 2007
              • 3405
              #4
              Originally posted by 10ashsd
              I don't really know. I'm novice in this area. My ultimate goal is to have something on a server hosted from home which means not that many simultaneous users. less than 100.

              I'm certainly open to suggestions.

              even if you or someone on this forum could suggest some direction for learning I am certainly open to reading up on this stuff.
              Thank you,
              I think a lot of people start out with access and then if they find that this isn't big enough they move up to msSQL, they conversion is fairly straight-forward. This is what I did, and I only ever had small conversion problems.

              However, some of the best out there currently are actually free: MySQL works very well for big and small applications and is free open source (although not especially user-friendly and might be harder for novices to handle).

              Jared

                Comment

                • pbmods
                  Recognized Expert Expert
                  • Apr 2007
                  • 5821
                  #5
                  Originally posted by jhardman
                  (although not especially user-friendly and might be harder for novices to handle).
                  I don't know what you're talking about.

                    Comment

                    • jhardman
                      Recognized Expert Specialist
                      • Jan 2007
                      • 3405
                      #6
                      Originally posted by pbmods
                      I don't know what you're talking about.
                      My impression of MySQL has been that it is very powerful, but "bare-bones" as far as user interface and appearance. I think this makes it daunting to novices. Maybe this isn't the case if you get it as part of a package (like WAMP). What is your experience?

                      Jared

                        Comment

                        • pbmods
                          Recognized Expert Expert
                          • Apr 2007
                          • 5821
                          #7
                          Heya, Jared.

                          To be honest, I don't have enough experience with any other database server software to be able to make an objective evaluation.

                          But I've always liked MySQL, so I recommend it.

                          What features do you feel are missing from MySQL?

                            Comment

                            Previous template Next
                            Working...