psahores at free.fr
Wed Jan 21 17:54:59 CST 2009
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
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,
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,
mobile : 06 03 95 77 70
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.
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
More information about the use-livecode