10 Replies Latest reply on Aug 30, 2006 11:09 PM by joey_a

    Access Database or MYSQL database

    joey_a
      I am new to creating databases but I am learning. Could anyone let me know the advantages and disadvantages of both. And what would you recommend.
        • 1. Re: Access Database or MYSQL database
          Level 7
          joey_a wrote:
          > I am new to creating databases but I am learning. Could anyone let me know the advantages and disadvantages of both. And what would you recommend.

          Access is very popular with web developers because it has a "friendly"
          user interface. It's also easy to upload to a website because the
          database is a single file that you upload in the same way as a web page
          or an image. However, Access is designed as a small office tool (that's
          why it's part of the Microsoft Office suite). It creates very large
          files, even if you have only a few records; and it breaks down if more
          than a handful of people attempt to access it simultaneously. It's OK
          for small, low-traffic websites, but not the ideal solution.

          MySQL is a relational database management system. It is capable of
          storing millions of records, is very fast, and can handle a large number
          of simultaneous requests in its stride. However, what puts a lot of
          beginners off is that it doesn't have a glossy interface (although you
          can get free and commercial interfaces to overcome this). Also, it
          stores data in a common data store, so you need to transfer data to a
          remote server by "dumping" your records to a SQL file, which you then
          use to load the data into the target database.

          When someone first recommended MySQL to me about five years ago, I was
          terrified by the unfamiliar way it worked. However, within about a day,
          I realized it was incredibly easy to use. If you want to learn about
          databases, I would say: forget Access. Either use MySQL or consider MS
          SQL Server. Use a database designed for the job, not something designed
          for small office use.

          --
          David Powers
          Adobe Community Expert
          Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
          http://foundationphp.com/
          • 2. Access Database or MYSQL database
            joey_a Level 1
            Thanks for the reply, I really do want to learn more about MYSQL databases but don't know where to begin is there a tutorial that you may be able to recommend on how to build (in Dreamweaver) and understand MYSQL databases?

            I appreciate all of the info you gave me.
            • 3. Re: Access Database or MYSQL database
              Level 7
              On Wed, 30 Aug 2006 05:07:41 +0000 (UTC), "joey_a"
              <webforumsuser@macromedia.com> wrote:

              >Is there a tutorial that you may be able to recommend on how to build (in Dreamweaver) and understand MYSQL databases?
              >
              >I appreciate all of the info you gave me.


              I think it's going to take a bit more than a simple tutorial. However,
              if you're willing to spend a little time and effort, perhaps this will
              get you started:

              Foundation PHP for Dreamweaver 8
              http://foundationphp.com/

              Gary
              • 4. Re: Access Database or MYSQL database
                joey_a Level 1
                I am willing to put the time and effort to learn it. I think you forgot the link to what will help me get started.
                • 5. Re: Access Database or MYSQL database
                  Level 7
                  joey_a wrote:
                  > I am willing to put the time and effort to learn it. I think you forgot the link to what will help me get started.

                  The link Gary gave you was to my book, "Foundation PHP for Dreamweaver
                  8". The link is also in my sig. My book will get you started with the
                  basics of both PHP and MySQL, and take you to an intermediate level. If
                  you want to take MySQL more seriously, anything written by Paul DuBois
                  is excellent. I refer constantly to one of his books, called simply
                  "MySQL". However, it's a 1,300-page brick, so may be not the best to
                  start with.

                  --
                  David Powers
                  Adobe Community Expert
                  Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
                  http://foundationphp.com/
                  • 6. Re: Access Database or MYSQL database
                    Level 7
                    On Wed, 30 Aug 2006 07:30:52 +0000 (UTC), "joey_a"
                    <webforumsuser@macromedia.com> wrote:

                    >I am willing to put the time and effort to learn it. I think you forgot
                    >the link to what will help me get started.

                    As David points out, I didn't forget the link.

                    Gary
                    • 7. Re: Access Database or MYSQL database
                      joey_a Level 1
                      Oh sorry about that, the book I should get is PHP Web Development with DW MX 2004?
                      • 8. Re: Access Database or MYSQL database
                        Level 7
                        On Wed, 30 Aug 2006 15:38:25 +0000 (UTC), "joey_a"
                        <webforumsuser@macromedia.com> wrote:

                        >Oh sorry about that, the book I should get is PHP Web Development with DW MX 2004?


                        What version of Dreamweaver are you using?

                        Gary
                        • 9. Re: Access Database or MYSQL database
                          Level 7
                          joey_a wrote:
                          > Oh sorry about that, the book I should get is PHP Web Development with DW MX 2004?

                          No, the one that everyone has recommended is "Foundation PHP for
                          Dreamweaver 8" ( http://foundationphp.com/dreamweaver8/). It's much more
                          up to date than the other one.

                          --
                          David Powers
                          Adobe Community Expert
                          Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
                          http://foundationphp.com/
                          • 10. Re: Access Database or MYSQL database
                            joey_a Level 1
                            I have MX 2004 on my computer and DW 8 on my laptop.