Re: [PHP] MySQL after oracle, still Wise?, was Web application design .......

2009-06-03 Thread Sancar Saran
On Tuesday 02 June 2009 11:36:28 pm optoma...@rogers.com wrote: Everybody has given Angus really great advice in this previous thread and I have learned a lot too. I hope no one mines the fork but I am in the exact same situation as Angus. If anyone could spare a bit of time regarding

RE: [PHP] MySQL after oracle, still Wise?, was Web application design .......

2009-06-03 Thread Bob McConnell
From: Sancar Saran And if you so much thinking about future DB change. Just wrote compatible sql and use multi drive layer (phpADO db). And you are problem free I have some questions about this suggestion. We currently have production systems using Postgres, Sybase ASA, Oracle and MS SQL

Re: [PHP] MySQL after oracle, still Wise?, was Web application design .......

2009-06-03 Thread Eddie Drapkin
Sadly, Mr. Saran wasted a lot of time writing a pluggable backend db layer, as one is built into PHP now, PDO: http://us2.php.net/pdo Sybase / MsSQL: http://www.php.net/manual/en/ref.pdo-dblib.php Postgres: http://us2.php.net/manual/en/ref.pdo-pgsql.php Oracle:

Re: [PHP] MySQL after oracle, still Wise?, was Web application design .......

2009-06-02 Thread Paul M Foster
On Tue, Jun 02, 2009 at 04:36:28PM -0400, optoma...@rogers.com wrote: Everybody has given Angus really great advice in this previous thread and I have learned a lot too. I hope no one mines the fork but I am in the exact same situation as Angus. If anyone could spare a bit of time regarding

Re: [PHP] MySQL after oracle, still Wise?, was Web application design .......

2009-06-02 Thread Eddie Drapkin
High-performance builds of mysql are still faster. And with 5.4 integrating a lot of performance boosts, I'd expect MySQL to retain that lead for a lot longer. There's also a lot more guides / support for MySQL around, as well as having a more robust choosing of UDF's, if you were to need them.