SQL varieties

Mark Schonewille m.schonewille at economy-x-talk.com
Wed Jan 21 19:55:54 EST 2009


Hi Sarah,

I can't say much about the difference between PostGreSQL and MySQL. I  
have been using MySQL 4 and 5 and have been particularly happy with  
release 5. I just can't think of a reason to switch to PostGreSQL. I  
have also noticed that most, if not all, web providers provide MySQL,  
but not all of them provide PostGreSQL. If you want to stick with a  
particular SQL flavour or need compatibility in case you want to go on- 
line with a project some time in the future, I'd choose MySQL.

Regarding the pronunciation, try this: <http://www.postgresql.org/files/postgresql.mp3 
 >.

--
Best regards,

Mark Schonewille

Economy-x-Talk Consulting and Software Engineering
http://economy-x-talk.com
http://www.salery.biz
Dutch forum: http://runrev.info/rrforum

We are always looking for new projects! Feel free to contact us to  
discuss your custom software project!

On 22 jan 2009, at 00:02, Sarah Reichelt wrote:

> Hi All,
>
> I'm working on a system that will end up using a multi-user database
> served from a central system. While testing I am using SQLite which is
> great as I can test all my SQL commands without having to worry about
> the additional complication of server connections. When that all works
> I will transfer it to MySQL running under MAMP on my desktop and
> finally over to the server.
>
> I run a pure OS X shop so I was going to go with MySQL for the final
> database as it is a standard part of OS X server. However I have read
> posts on this list suggesting that PostgreSQL is a better solution. So
> here are a few questions for the exports:
>
> 1. Is PostgreSQL better & why?
> 2. Is it easy to install on OS X (client & server)
> 3. How do you say PostgreSQL :-)
>
> My system is going to be a relatively small database and not subject
> to heavy usage, if that makes any difference to the recommendations.
>
> TIA,
> Sarah




More information about the Use-livecode mailing list