Re: [PHPOpenChat-Users] "database independant" is a crock

[Justin C. <ju...@po...>]

Michael Oertel wrote:
 > Justin Clift wrote:
<snip>
 >> If you wanted people to assist in _making it database independant_
 >> that should have been said, not outright lies.
 >>
 >> Very pissed off.
 >
 > Ooops, sorry, I know about an installation using oracle, the worst case
 > so to say, but it's working fine. So, I'll add (but developed using
 > MySQL, be warned :)
 >
 > If there any help you can offer, our ears are open.

Sure.  I _strongly_ suggest amending the website to mention "known good" 
databases that work out of the box, and also mention what it will take 
to get others working.

For example, would you call this good "database independant" code?

***********

'SELECT c.NAME AS NAME,
     c.INVITED AS INVITED,
     c.TYPE AS TYPE,
     COUNT(c.NAME) AS COUNT
   FROM '.DATABASE_TABLE_PREFIX.'user_data d,
        '.DATABASE_TABLE_PREFIX.'channels c
   WHERE ONLINE = \'1\'
     AND LAST_CHANNEL = c.NAME
   GROUP BY c.NAME
   ORDER BY ORDER_IDX'

***********

Here's why I'm pissed off.  I get paid hourly in one of my SysAdmin 
jobs.  I'm good at PostgreSQL, so I charge accordingly.

Because PHP Open Chat said it was database independant using ADOdb 
(which I've used a fair amount), I thought it worth trying with PostgreSQL.

Ha!

So, several hours later, it's damn clear that PHP Open Chat needs a lot 
of work to _become_ database independant.  No thanks for just costing me 
about 1/2 grand in un-billable wasted time.

You expect I want to help you guys now?  After blatently lying about 
capabilities?

Like hell.

+ Justin Clift


 > Sorry,
 > -michael