Re: [Pmtool-devel] PostgreSQL port issues

[Robby R. <ro...@pl...>]

On Sun, 2005-02-20 at 19:02 -0800, Robby Russell wrote:
> Few things that will need to be addressed.
> 
> - Table user, needs to be renamed to users or something as 'user' is a
> special word in postgresql.
> 
> - there is no PASSWORD() function in postgresql. We need to move this
> function into PHP or have a special instance for postgresql to md5() the
> password before saving. The biggest issue is that anyone using mysql
> right now cannot migrate to postgresql unless we can duplicate the
> PASSWORD function in php.
> 
> - Fix all the SQL queries that compares INT fields to '' (string).
> PostgreSQL is a bit more intolerant of this. (which is a good thing)
> 
> ..more to come.
> 
> -Robby
> 

Chris, how do you feel about PEAR::DB ?

That was the db library that I was planning on using for V.2. 

-Robby


-- 
/***************************************
* Robby Russell | Owner.Developer.Geek
* PLANET ARGON  | www.planetargon.com
* Portland, OR  | ro...@pl...
* 503.351.4730  | blog.planetargon.com
* PHP/PostgreSQL Hosting & Development
* --- Now hosting Ruby on Rails Apps ---
****************************************/