From: Zero M. <zer...@gm...> - 2006-08-09 01:03:03
|
Just found out the server is running outdated MYSQL version. That would be the reason. Sorry ;) |
From: Jon P. <jo...@cr...> - 2006-08-09 22:19:09
|
On Tue, 2006-08-08 at 21:02 -0400, Zero Mass wrote: > Just found out the server is running outdated MYSQL version. That > would be the reason. Sorry ;) All is well...you could always write some code to give us compatibility with older MYSQL (while maintaining new compatibility) :) Jon > ------------------------------------------------------------------------- > Using Tomcat but need to do more? Need to support web services, security? > Get stuff done quickly with pre-integrated technology to make your job easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > _______________________________________________ Cctools-cchost mailing list Cct...@li... https://lists.sourceforge.net/lists/listinfo/cctools-cchost -- Jon Phillips jo...@cr... cell: 510.499.0894 Software Engineer Creative Commons www.creativecommons.org |
From: Roan H. <ro...@ho...> - 2006-08-09 23:57:29
|
Hi, During my recent memory problems with mysql (which turned out to be a server physical memory lack), I started to think about hacking cchost to use postgreSQL so I could test what was going on. I did a little looking around at the various libraries that let you write database neutral connection/query/input code. The library then provides the necessary hooks to talk to the desired database. The one I read up on is ADOdb Database Abstraction Library for PHP (and Python) -- http://adodb.sourceforge.net/ I like the idea of opening up the choice of databases that can be used. I think it would help promote the use of cchost. Upside: * choice of databases * no fork of code needed to support different databases * with minimal effort cchost/potential new users can add support for a new database Downside: * another library dependency * for ADOdb in particular, it is dual licensed BSD and LGPL -- don't know if this is a problem for cchost since not GPL Other php db abstraction layers: * http://adodblite.sourceforge.net/index.php * http://pear.php.net/package/DB Didn't know if this has been discussed before. I'd be willing to work on it once I'm finished with svg support for getid3. Thanks, Roan - |
From: Mike L. <ml...@cr...> - 2006-08-10 00:10:49
|
On Wed, 2006-08-09 at 19:57 -0400, Roan Horning wrote: > I like the idea of opening up the choice of databases that can be used. > I think it would help promote the use of cchost. I prefer postgresql to mysql but adding an abstraction layer to support multiple databases to ccHost is a bad idea. Although libraries provide abstraction, actually supporting multiple databases is still difficult and time consuming. Far larger projects have consistently failed to do so in a useful manner. And mysql is ubiquitous and more than good enough. Thanks for the suggestion, don't mean to be overly critical. Mike -- http://wiki.creativecommons.org/User:Mike_Linksvayer |
From: Roan H. <ro...@ju...> - 2006-08-10 00:43:10
|
Mike Linksvayer wrote: > Although libraries provide abstraction, actually supporting multiple > databases is still difficult and time consuming. Far larger projects > have consistently failed to do so in a useful manner. > Fair enough, I figured there would be an initial pain of replacing the mysql specific commands with the abstracted commands, plus setting up the install to allow for multiple databases. > And mysql is ubiquitous and more than good enough. > Very true, which is why a fair portion of the FOSS web apps support mysql only. Like you, I prefer postgreSQL, so it would be nice if it were a tad easier to use postgreSQL with cchost. Even if mysql was the only officially supported database (with it as the only db available with the default install), having the structure set up to more easily add another db would be nice. anywho--nuff said--thank you for listening to my rant on database choice :) Peace, PHP, and PERL regex, Roan |
From: Victor S. <fou...@gm...> - 2006-08-10 02:09:47
|
On 8/9/06, Roan Horning <ro...@ju...> wrote: > Mike Linksvayer wrote: > > Although libraries provide abstraction, actually supporting multiple > > databases is still difficult and time consuming. Far larger projects > > have consistently failed to do so in a useful manner. > > > Fair enough, I figured there would be an initial pain of replacing the > mysql specific commands with the abstracted commands, plus setting up > the install to allow for multiple databases. after two years we haven't had a request for postgre BUT I would claim that the vast majority of the code is abstracted (see cclib/cc-database.php) to pull off what you suggest. There ARE random mysql sepecific calls but the vast majority of the code should be abstracted enough to pull off what you suggest. Again, however, no one has asked for it. VS |