SQL varieties

[Pierre Sahores]

Hi Sarah,

MySQL (3.2.3) use to be a very unsecure solution. More, it was unable  
to serve more than 10-15 connections/second. At that time, PostgreSQL  
(6.5) had become a very serious alternative to Oracle or Sybase rdbms.

Today, PostgreSQL is still a very suitable solution (more ACID- 
compliant than any issue of Oracle 10/11, very fast in both read and  
write modes, triggers, BSD license,...) and i use it, since 1998, all  
the time on both the Suse, Ubuntu or Mac OS X platforms. Never had any  
db krach or datas loose.... It's no any difficulty in installing  
PostgreSQL under the Linux (just select it in the packages to install)  
or Mac OS X (avoid the apple dev site instructions and prefer the Marc  
Lyanage specs at http://www.entropy.ch/software/macosx/postgresql/ for  
the details).

On the other side, MySQL 4 did lots of progresses over the sad 3.2.3  
issue and MySQL 5.xx is yet a mature and secure rdbms solution. Lots  
of rock solid apps are build on top of it (Typo3, Xoops, eZ Publish,  
limeSurvey,...).

So, to the end, just go to the simplest way for your project context.  
I choose, for my own, PostgreSQL each time i have to build a n-tier  
app from scratch on top of PHP+RunRev. I use MySQL 5.xx, each time i  
have to do with a prebuilded PHP-based app (ECMS, Survey tool, etc...)  
natively MySQL cpmliant.

PostgreSQL installs in the same way on both OS X server and OS X  
desktop. There is no client-side components installation need. About  
the db administration tool, i use differents ones but my prefered is  
Navicat (100 US $).

In about talking about PostgreSQL, the best is to say "Postgre SQL" ;-)

Hope this can help,

Best Regards,
--
Pierre Sahores
mobile : 06 03 95 77 70
www.sahores-conseil.com


Le 22 janv. 09 à 00:02, Sarah Reichelt a écrit :

> 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
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your  
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
>