Announcement

Collapse
No announcement yet.

MySQL vs. Postgresql

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • MySQL vs. Postgresql

    An interesting article:

    http://www.phpbuilder.com/columns/tim20000705.php3

    John
    John Percival

    Artificial intelligence usually beats real stupidity ;)

  • #2
    But look at another article written a little more recently by the same author:

    http://www.phpbuilder.com/columns/tim20001112.php3

    I see the tide turning toward PostGreSQL every where I look/read, and therefore I think it should be a high priority for vBulletin developer's to make vBulletin support PostGreSQL.

    Comment


    • #3
      Originally posted by Lynn
      But look at another article written a little more recently by the same author:

      http://www.phpbuilder.com/columns/tim20001112.php3

      I see the tide turning toward PostGreSQL every where I look/read, and therefore I think it should be a high priority for vBulletin developer's to make vBulletin support PostGreSQL.
      wow bringing back a thread that's over 1 yrs old
      :: Always Back Up Forum Database + Attachments BEFORE upgrading !
      :: Nginx SPDY SSL - World Flags Demo [video results]
      :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

      Comment


      • #4
        Is there anyone on vbulletin (developers) that knows how to use these alternative databases ?
        Email: [email protected]
        Site: Under Construction

        Comment


        • #5
          Originally posted by Kaizen
          Is there anyone on vbulletin (developers) that knows how to use these alternative databases ?
          There sure are

          Comment


          • #6
            Email: chr[email protected]
            Site: Under Construction

            Comment


            • #7
              I'm good at MS SQL (and have a license as well ). I'm not a developer though.

              Comment


              • #8
                newer versions of postgre wipe the floor with the ailing MySQL... its a fact
                http://www.e-tones.co.uk - The best site on the net for mobile phones.

                Comment


                • #9
                  Well I am hoping that perhaps there will be versions in the future for postgreSQL. I have been doing a lot of comparing and contrasting for which one is better.
                  vB guys always do whats right
                  Board of the Month: November
                  Websites: Pixeljunction , vBulletin.org
                  Button Sets: XP and Aqua Button sets! FREE!
                  vB Customization: My sig is now vbulletin compliant. Contact me to make yours compliant too!

                  Comment


                  • #10
                    Originally posted by Sinecure
                    I have been doing a lot of comparing and contrasting for which one is better.
                    Same here.... technically speaking, I am convinced PostgreSQL is better... however there have been some severe limitations and speed issues in the past, but with each new release they seem to be getting much better. For most sites with less traffic, MySQL seems to be a better choice most of the time.

                    Comment


                    • #11
                      Is there any site that shows the differences in query syntax between the major RDBMS's(pgSQL,msSQL,mySQL,oracle,sybase).

                      Comment


                      • #12
                        I don't know of a site that does off hand. You could go to the home page for each database and scan the docs.

                        Comment


                        • #13
                          www.dbforums.com is the place to start your search.
                          Christopher Padfield
                          Web Based Helpdesk
                          DeskPRO v3.0.3 Released - Download Demo Now!

                          Comment


                          • #14
                            Hmmm. The complete documentation for Oracle comes on several CD's... 10 if I recall correctly.

                            However you can get the gist of it from their reference CD which is only 492 megabytes. Don't think you can download it though.

                            Anyway, I have personal experience with Oracle, Sybase and Ms-SQL Server.

                            The query syntax for Sybase and MS-SQL Server are pretty much the same. However Oracle's is completely different.
                            Translations provided by Google.

                            Wayne Luke
                            The Rabid Badger - a vBulletin Cloud demonstration site.
                            vBulletin 5 API

                            Comment


                            • #15
                              The documentation for Oracle can be viewed on-line at http://technet.oracle.com . You have to register, but it's free. You can also access their trial download area with the same login.

                              I'm starting to get problems with mysql on my boards now. It crashes once a month. The worst part is the length of time it takes to repair the tables. I'm guessing it will only get worse as the tables get bigger. I'd go to innodb, but I need to buy a bigger hard drive first. I couldn't believe how much extra space innodb needs .
                              http://britishexpats.com/ - British expatriate community

                              Comment

                              widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                              Working...
                              X