Re: [PHP] Re: PEAR vs PHPLIB
Hello, Mark Charette wrote: > > > From: Manuel Lemos [mailto:[EMAIL PROTECTED]] > > Unlike PEAR-DB and PHPlib, Metabase provides true database independence > > to your applications. > > Actually - no. Querys/conformance to specs/sequences/stored procs and more > are different from DB to DB. While the abstration layers help a little, they > really don't help a lot. If you want to write applications that take advantage of things that are specific to one database, database abastraction layers are of no user to you. Although if you give up on some things, you can write database independent applications making them more maintainable and take less time to release them letting you reach a broader market. It is a strategy that may worthy a lot of money if you run a software company. For instance, Siebel CRM packages AFAIK does not use stored procedures to be able to reach a wider market in less time. Anyway, back to PHP database abstraction packages, Metabase abstracts things that are possible to provide in a portable way, like data type mapping, and even things that others have been copying like sequences and limiting the range of rows that are returned by a select query which are important things for Web development. Metabase also abstracts database schema installation and maintenance which is a real time saver. Regards, Manuel Lemos -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] Re: PEAR vs PHPLIB
> From: Manuel Lemos [mailto:[EMAIL PROTECTED]] > Unlike PEAR-DB and PHPlib, Metabase provides true database independence > to your applications. Actually - no. Querys/conformance to specs/sequences/stored procs and more are different from DB to DB. While the abstration layers help a little, they really don't help a lot. Mark C. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Re: PEAR vs PHPLIB
Hello, Dennis Gearon wrote: > > How are the usage stats for these two libraries shaping up? > > Both have advantages, I'm just wondering which one to start my own designs > around. That depends on what you want to do. You also should consider other well thought solutions. If you are looking for a well structured framework look at BinaryCloud ( http://binarycloud.tigris.org/ ). If you are looking for a good database abstraction package, look at Metabase ( http://phpclasses.UpperDesign.com/browse.html/package/20 ). Unlike PEAR-DB and PHPlib, Metabase provides true database independence to your applications. This means that with Metabase, you do not have to handle database differences with database specific code in your applications. For instance, each database may format date fields in different ways. Metabase assures that all date values that go back and forth the database are formatted according to the ISO 9601 format (-MM-DD), regardless if the underlying database uses that format to represent dates or some other. There are other nice features like the ability to install your database schemas just by defining your tables, fields, indexes and sequences in a custom XML format that is database independent. Just take a look in the page above to learn more about it. Regards, Manuel Lemos -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]