Re: [phpgrabcomics-announce] PostgreSQL backend support

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

Jim Wyllie wrote:
> I looked through the TODO / other documents and saw nothing to this
> effect, so I figure this is a kosher question to ask.
> 
> Is there any objection / advice on where to start for writing a
> PostgreSQL backend alongside a MySQL backend?  I'd rather use it for my
> server.
> 
> Looking at the code, it seems that the database layer could be easily
> abstracted to this effect.  Any objections / comments?

Hi Jim,
I don't see a reason not to have a PostgreSQL backend.

I didn't write the code because it has not been asked before by anyone.
Most of the users of phpGrabComics have access only to a fairly simple
server configuration - and that was my case as well until December.
PostgreSQL is often not available in cheap web hosting environments.

Some comments:
-at the present time there is no database abstraction. I know it's bad,
but it was done for performance reasones.
-at the present time you would have either to introduce a database
abstraction level or to simply rewrite the database parts.
-rewriting the database parts does not seem a good idea. It would imply
having to maintain too much code.

I have no objections in considering to restructure the code in
phpGrabComics to use database abstraction, but only if the decrease in
performance is not unreasonable.

I think that something below 20% might still be acceptable. As database
abstraction layer, MDB2 looks like a good candidate
(http://pear.php.net/package/MDB2), as phpGrabComics is already using PEAR.

If you are interested to do some work on it, and if the performance
decrease will not be too bad, it would be interesting to include the
code in phpGrabComics.

What do you think?

	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