On Thu, 18 Apr 2002 16:05:13 +0200, Manuel Lemos wrote:

> Hello,
> Sp wrote:
>> Hi Manuel, I still don't see a problem in others telling their
>> experiences with certain packages.  If someone has just used metabase
>> or has just used adodb then I would like to hear how easy/hard it was
>> to port to another database.
> Sure, but what I meant is that since most people only have experienced
> one or the other, you only hear from people that can't compare both.
> If you want to hear experiences of people that tried Metabase, try
> asking in Metabase mailing list (
> http://groups.yahoo.com/group/metabase-dev/ ) or BinaryCloud mailing
> lists ( http://binarycloud.tigris.org/servlets/ProjectMailingListList ).
> I think Alex Black (BinaryCloud project leader) has tried both MySQL and
> Oracle with Metabase.

I have done MySQL (MyISAM, INNODB), PostgreSQL and Oracle 9i with AdoDB -
see http://iptrack.sourceforge.net. Works just fine for me. The hardest
part was to get around limitations of certain databases - like Oracle
does no support record count. This is not impossible to get around, but
when you are used to making use of these standard features of other
databases, it takes a bit of getting used to. Other issues are syntax
issues - you cannot use any funky functions which are unique to your dbf.
Also, you must write very standard SQL - no shortcuts. For example, with
Oracle you MUST specify the table name throughout your query when doing
joins, even if the column is unambiguos.

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to