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