Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Why is PGSQL better than MySQL
- From: "Jim C. Nasby" <jnasby(at)pervasive(dot)com>
- To: David Rogers <David(dot)Rogers(at)MCI(dot)com>
- Cc: John Mohr <jtmohr(at)healthconresources(dot)com>, pgsql-php(at)postgresql(dot)org
- Subject: Re: Why is PGSQL better than MySQL
- Date: Fri, 16 Dec 2005 18:31:21 -0600
On Tue, Dec 13, 2005 at 08:36:12AM -0600, David Rogers wrote: > Needless to say, this fall we began the conversion to PostgreSQL 8 and > we couldn't be more pleased. As a part of the conversion I found several > new bugs in MySQL due to PostgreSQL complaining about some of my old > queries. The most egregious of these are MySQL silently truncating var > chars that are too long for the column and silently allowing one to > insert a quoted string into an integer column. Ouch! We won't be using > MySQL for any new work here and will eventually migrate all of our > applications to PostgreSQL. You should make sure all that stuff is reported in the gotchas: http://sql-info.de/mysql/gotchas.html -- Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
- References:
- Why is PGSQL better than MySQL
- From: John Mohr
- Re: Why is PGSQL better than MySQL
- From: David Rogers
- Why is PGSQL better than MySQL
- Prev by Date: Re: Why is PGSQL better than MySQL
- Next by Date: Re: Why is PGSQL better than MySQL
- Previous by thread: Re: Why is PGSQL better than MySQL
- Next by thread: Re: Why is PGSQL better than MySQL
- Indexes: