Migrate MySQL... or not...

[Madison Kelly]

tug wrote:
> Robert Brockway wrote:
>> On Wed, 19 Aug 2009, tug wrote:
>>
>>> At TLUG meetings I've heard negative comments about MySQL, and that 
>>> Postgres is a better option. If I've got to go through hoops (aka 
>>> read manuals and look at log files) to get the database migrated, 
>>> should I also consider switching databases?
>>
>> MySQL vs Postgres is like vi vs Emacs or Linux vs FreeBSD.
>>
>> The reality tends to show that each has advantages over the other 
>> depending on the workload.
>>
>> Even if you found that Postgres was faster than MySQL for your 
>> application it is unlikely that the difference would be enough for 
>> your to care. Under low load the bottleneck probably isn't the DB at all.
>>
>> OTOH the best way to learn about an app is to use it, so if you want 
>> to get experience with Postgres, then by all meants switch over.
>>
>> Cheers,
>>
>> Rob
>>
> Thanks for the responses... I was worried about backing the wrong 
> (unmaintained) horse... I just use a database as a place to store data, 
> and don't really care which (open source) - INSERT, UPDATE, SELECT and 
> DELETE are all I use.
> 
> If ever I develop a prototype killer app, I will be sure to consult a 
> database expert :)
> 
> Tug

For what you're doing, I don't think one is really better than the other.

I general though; I've come to see the differences as:

MySQL; Faster, More features
PostgreSQL; More Robust/Reliable, More compliant to the SQL standards.

Madi
--
The Toronto Linux Users Group.      Meetings: http://gtalug.org/
TLUG requests: Linux topics, No HTML, wrap text below 80 columns
How to UNSUBSCRIBE: http://gtalug.org/wiki/Mailing_lists