Re: one abstraction layer (my proposal for)
| From: | Manuel Lemos | Date: | Tue, 04 Dec 2001 00:24:01 +0000 |
| Subject: | Re: one abstraction layer (my proposal for) | ||
| References: | 1 2 | Groups: | php.pear.dev |
| Request: | Send a blank email to pear-dev+get-3336@lists.php.net to get a copy of this message | ||
Hello,
John Lim wrote:
> > 4.9) Data quoting (manual & automatic)
>
> Automatic is very difficult to do unless you can query the database
> internals
> for field types. MySQL/PostgreSQL is trivial as numbers can be quoted, but
> other databases will object. Definitely only in "portable PEAR DB" please.
I think automatic means when using prepared queries where you specify
the type of data using the proper paremeter value set function.
> > * (4.8) Data Type conversion to be done by a more generic class
> > PEAR_DataType
> > (suitable to be used in other enviroments too, like xmlrpc, etc)
>
> Sounds good, but you need to define what abstract data types you want
> to support. The main issue is dates and datetime, because Unix timestamps
> are not very good equivalents for dates unfortunately. Most other
> database types have natural PHP mappings.
Not just date and time fields, but also decimal and float fields besides
the others that are more obvious.
Regards,
Manuel Lemos