Re: [phpgrabcomics-announce] PostgreSQL backend support

[Andres B. <an...@ba...>]

Jim Wyllie wrote:
> I agree completely; I was thinking abstraction all the way.  You mention
> that you're making your code PHP5 compatible, is it kosher if I use
> PHP5-only functions, or should I stay away from them?

no, that's fine.

I have been lazy recently with phpGrabComics and incorporating your new
code might be a good thing.

>> I think that something below 20% might still be acceptable.
> 
> You were seeing 20% decreases in performance with an abstraction layer?!
>  Something is very wrong with that figure.  I'm guessing that somewhere,
> something very dumb was happening, like creating / executing / closing a
> database connection for every query.  That's the only thing that makes
> that figure make sense.
> 
> I promise you won't see that kind of performance hit  :)

I have not done any tests recently, but I remember an awful performance
decrease with the PEAR database abstraction layer.

I have used the phplib abstraction layer for a long, long time, but I
have needed it only once since 2000, to reuse some code that was used
for an oracle db in mysql... The problem with phplib is that is
unmantained and unsopported.

A rapid googling gave me this page on abstraction layers for databases:
http://phplens.com/lens/adodb/

I haven't checked the code of the testing, but the web page reports a
40% overhead with phplib and 154% using PEAR...

> I know *of* PEAR, though I haven't ever used it.  I'll grab the code and
> take a look.  I do respect your wish to use PEAR for parts of the
> project; I'll see what I can do.

I do not like PEAR too much. It's quite slow. On the other hand,
phpGrabComics is already using PEAR, and is using caching techniques
(jpcache).

Have you got any alternatives in mind? The main requirement is not to
have to use any "exotic" module (e.g. dbx), because users can't often
have them in shared hostings

> Sounds like we're coming from the same page on this one.  Thanks for the
> reply.

Great!

	Andres

____________

Andres Baravalle
http://www.baravalle.it

____________

Gli uomini d'azione sono poco pratici.
La stessa azione li allontana dalla loro meta.
         Paco Ignacio Taibo I