Postgres vs. MySQL

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Hooper
    Confirmed User
    • Jul 2001
    • 2210

    #1

    Postgres vs. MySQL

    We're working on the back end to our up and coming new program and wondered what all you progammer/geeky types thought about the mysql vs. postgres debate?

    It seems clear that good coding is necessary... but lets *assume* that we're using professionals ;-))

    Any thoughts? Which is better? Why?


    Conversion Cash - Weekly Payouts
    18
    Postgres
    0%
    1
    They seem the same
    0%
    1
    MySQL
    0%
    13
    What's A Database?
    0%
    3
    <a href="http://www.adultplatinum.com/"><img src="http://www.adult.com/wmbanners/10dcash-468x60.gif"></a>
  • Amputate Your Head
    There can be only one
    • Aug 2001
    • 39075

    #2
    mySQL.
    SIG TOO BIG

    Comment

    • NetRodent
      Confirmed User
      • Jan 2002
      • 3985

      #3
      Depends a lot on what you are doing. We use Mysql for data collection and Postgres for reporting. Mysql is faster but Postgres has more functionality. Mysql tables can be read replicated across several servers. Postgres doesn't do replication but supposedly will support read/write replication relatively soon. Postgres supports transactions, while Mysql doesn't really. Each database has its strengths and its weaknesses.
      Last edited by NetRodent; 02-15-2002, 09:54 AM.
      "Every normal man must be tempted, at times, to spit on his hands, hoist the black flag, and begin slitting throats."
      --H.L. Mencken

      Comment

      • Ludedude
        Suck it!
        • Jun 2001
        • 4432

        #4
        SQL2000

        Comment

        • wired1
          Registered User
          • Dec 2001
          • 279

          #5
          Oracle if you can afford it.

          Otherwise MySQL for free...

          Comment

          • duff2
            Registered User
            • Feb 2002
            • 9

            #6
            MySQL, Postgres isn't a real option right now

            Comment

            Working...