Re: [GENERAL] PG -v- MySQL

2008-05-14 Thread Matthew T. O'Connor
Andy Anderson wrote: However, being a GUI-oriented person I haven't noticed management tools comparable to phpMyAdmin (for web) and CocoaMySQL (for Mac). Perhaps someone can enlighten me? (Yes, I've tried pgAdmin, but it's not quite ... right. I can't say why at the moment, I should probably

Re: [GENERAL] PG -v- MySQL

2008-05-14 Thread Fernando
Have you tried Navicat? The light version is free for the Mac (I think). Andy Anderson wrote: On May 13, 2008, at 11:42 AM, Merlin Moncure wrote: Here are some other things we have v. mysql: *) Much better shell I tend to agree based on my limited experience. However, being a GUI-orien

Re: [GENERAL] PG -v- MySQL

2008-05-14 Thread Andy Anderson
On May 13, 2008, at 11:42 AM, Merlin Moncure wrote: Here are some other things we have v. mysql: *) Much better shell I tend to agree based on my limited experience. However, being a GUI-oriented person I haven't noticed management tools comparable to phpMyAdmin (for web) and CocoaMySQL

Re: [GENERAL] PG -v- MySQL

2008-05-14 Thread cyclix
It surely rocks. We switched from MySql to PostgreSQL about a year ago and have never looked back, we are happy as Larry. A bit more information on our web site. http://www.alerce.com.au Regards, Mario Joshua D. Drake wrote: Scott Marlowe wrote: On Tue, May 13, 2008 at 9:42 AM, Merlin

Re: [GENERAL] PG -v- MySQL

2008-05-13 Thread Chris Browne
[EMAIL PROTECTED] ("Joshua D. Drake") writes: > Gauthier, Dave wrote: >> I’ve been invited to participate in a forum which discusses >> technical issues for relational DBs used in the corporation. The 3 >> DBs they are discussing are Oracle, SQL-Server and MySQL. I’d like >> to introduce PG, but

Re: [GENERAL] PG -v- MySQL

2008-05-13 Thread Robert Treat
On Tuesday 13 May 2008 12:09:28 Kevin Hunter wrote: > * The documentation on the website for Postgres is by far the better of > the two DBs. MySQL's is decent and very useful, but Postgres' > documentation just plain rocks. In fact, the Postgres documentation is > one of the very best examples of

Re: [GENERAL] PG -v- MySQL

2008-05-13 Thread Joshua D. Drake
Scott Marlowe wrote: On Tue, May 13, 2008 at 9:42 AM, Merlin Moncure <[EMAIL PROTECTED]> wrote: Here are some other things we have v. mysql: *) Transactional DDL: much safer and easier to roll out changes to 24/7 systems And I totally agree with everything you said Merlin. Especially about t

Re: [GENERAL] PG -v- MySQL

2008-05-13 Thread Scott Marlowe
On Tue, May 13, 2008 at 9:42 AM, Merlin Moncure <[EMAIL PROTECTED]> wrote: > Here are some other things we have v. mysql: > *) Transactional DDL: much safer and easier to roll out changes to 24/7 > systems It's also useful for lots and lots of other things. For instance, let's say you had an ind

Re: [GENERAL] PG -v- MySQL

2008-05-13 Thread Kevin Hunter
At 10:39a -0400 on Tue, 13 May 2008, Dave Gauthier wrote: > I’d like to introduce PG, > but want to be able to address the "Why not use MySQL" questions when > they arise. I know in the past there have been many comparisons between > the 2 DBs but would like to know if there are any good, recent o

Re: [GENERAL] PG -v- MySQL

2008-05-13 Thread Dimitri Fontaine
Le mardi 13 mai 2008, Joshua D. Drake a écrit : > I suggest you take a look at: > > http://www.scribd.com/doc/2575733/The-future-of-MySQL-The-Project > http://sql-info.de/mysql/gotchas.html > http://www.bytebot.net/blog/archives/2008/04/17/what-mysql-can-learn-from-p >ostgresql http://www.commandpr

Re: [GENERAL] PG -v- MySQL

2008-05-13 Thread Merlin Moncure
On Tue, May 13, 2008 at 10:39 AM, Joshua D. Drake <[EMAIL PROTECTED]> wrote: > > I've been invited to participate in a forum which discusses technical > issues for relational DBs used in the corporation. The 3 DBs they are > discussing are Oracle, SQL-Server and MySQL. I'd like to introduce PG, b

Re: [GENERAL] PG -v- MySQL

2008-05-13 Thread Joshua D. Drake
Gauthier, Dave wrote: Hi: I’ve been invited to participate in a forum which discusses technical issues for relational DBs used in the corporation. The 3 DBs they are discussing are Oracle, SQL-Server and MySQL. I’d like to introduce PG, but want to be able to address the “Why not use MySQL

[GENERAL] PG -v- MySQL

2008-05-13 Thread Gauthier, Dave
Hi: I work for a large corporation that uses many different databases. I used to use Oracle but then moved away, mainly because of the expense and complexity. I wanted to stay on Linux, so I shy'ed away from SQL-Server. Many others around here use MySQL, but I decided to go with Postgres bec