Announcement

Collapse
No announcement yet.

SQL Database shutdown

Collapse
X
Collapse
 
  • Page of 2
  • Filter
  • Time
  • Show
Clear All
new posts
Previous 1 2 template Next
  • #16
    Originally posted by Urban Ranger
    All the comparative reviews I read put MySQL and PostgresSQL on the same level. Each has its own advantages and disadvantages.
    The main difference is PostgreSQL can scale much higher and handle more concurrent connections.

    All MySQL commands are standard SQL AFAIK.
    That's not true, there are all kinds of MySQL-specific functions that are common with lazy coders.

    Bugzilla is being ported to work on other databases, they're just running into some problems with all the MySQL-specific stuff they've had.
    "The issue is there are still many people out there that use religion as a crutch for bigotry and hate. Like Ben."
    Ben Kenobi: "That means I'm doing something right. "

    Comment

    • #17
      Originally posted by Asher

      The main difference is PostgreSQL can scale much higher and handle more concurrent connections.
      We the people are the rightful masters of both Congress and the courts, not to overthrow the Constitution but to overthrow the men who pervert the Constitution. - Abraham Lincoln

      Comment

      • #18
        phpBB would be nice, though.

        Asmodean
        Im not sure what Baruk Khazad is , but if they speak Judeo-Dwarvish, that would be "blessed are the dwarves" - lord of the mark

        Comment

        • #19
          Originally posted by Asher
          The main difference is PostgreSQL can scale much higher and handle more concurrent connections.
          Again, there's no clear conclusion on the subject. It certainly is interesting that Google, Yahoo! and craigslist use MySQL.
          (\__/) 07/07/1937 - Never forget
          (='.'=) "Claims demand evidence; extraordinary claims demand extraordinary evidence." -- Carl Sagan
          (")_(") "Starting the fire from within."

          Comment

          • #20
            Originally posted by Urban Ranger
            Again, there's no clear conclusion on the subject. It certainly is interesting that Google, Yahoo! and craigslist use MySQL.
            I think you're trying to imply something that's not the case -- Google and Yahoo certainly do not use MySQL for their search engine. They seem to use it for other, smaller products.
            "The issue is there are still many people out there that use religion as a crutch for bigotry and hate. Like Ben."
            Ben Kenobi: "That means I'm doing something right. "

            Comment

            • #21
              There are other issues with MySQL:

              It is not ANSI SQL compliant, does not support referential integrity, rules, views, triggers, unicode (? it may now, it didn't last I checked), inheritence, sub-selects, etc.

              Even stored procedures are a brand-new feature in 5.0...
              "The issue is there are still many people out there that use religion as a crutch for bigotry and hate. Like Ben."
              Ben Kenobi: "That means I'm doing something right. "

              Comment

              • #22
                Originally posted by Asmodean
                phpBB would be nice, though.

                Asmodean
                I don't like phpBB too much, at least not the default theme.
                The Apolyton Forum is fine the way it is!


                About MySQL, I still have to cope with ****ty 3.23.something (no sub-selects, no transactions or not that I know of - I don't really want to dig into that waste of a technology any further).
                PostgreSQL is fine, but people say you have to run a vacuum pretty often. Maybe they changed it with some version.

                Comment

                Previous 1 2 template Next
                Working...
                X