RE: CF and Cloudscape/Derby

2005-01-25 Thread Dave Merrill
Thanks Phil. I'd seen the devx article. One thing I noticed in it was these statements about admin requirements: "Larger relational DBMS, such as MySQL and Postgres are available today in open-source form. [snip] they require substantially greater levels of administrative oversight" "As to full

Re: CF and Cloudscape/Derby

2005-01-25 Thread Phil Cruz
>I'm hearing about Cloudscape/Derby as a reasonable database alternative to >MySQL etc. Is anyone here using it? Comments on performance? Scalability? >Stability? Features? > With Tracking-Tools, I offer it as one of the the supported database options (MSSQL, MYSQL, Oracle, and Cloudscape/Derby).

Re: CF and Cloudscape/Derby

2005-01-25 Thread Mark Drew
same here althought I had a little play with cloudscape, it looks like you need to create some sort of object that will start the connection. That article rocks. I must say that I have achieved the same portable environment with CFMX 7 , but I know you could do it from CFMX 6.1 simply by using tom

Re: CF and Cloudscape/Derby

2005-01-25 Thread Marco Antonio C. Santos
Hi Dave. Not. Yet!!! I'm waiting the 2nd part of Phil Cruz and Dick Applebaum article... ;-) Cheers Marco On Tue, 25 Jan 2005 05:55:54 -0500, Dave Merrill <[EMAIL PROTECTED]> wrote: > Marco, do you have any experience using Cloudscape? With CF? If so, any > comments on performance, features, st

Re: CF and Cloudscape/Derby

2005-01-25 Thread Mark Drew
I set this up this week (Postgres) with MX Wasnt too much of a problem, I downloaded the driver from: http://jdbc.postgresql.org/ Under the JVM settings I added the path to the driver: C:\drivers\postgresql-8.0.309.jdbc2.jar, Then created a Datasource as follows: JDBC URL: jdbc:postgresql:/// D

RE: CF and Cloudscape/Derby

2005-01-25 Thread Dave Merrill
Marco, do you have any experience using Cloudscape? With CF? If so, any comments on performance, features, stability? Setup hints for connecting w CFMX61? Thanks, Dave Merrill > Portable? Or Embeddable? Postgre(30MB RAM space) and MySQL(50MB RAM > space) may be Portable but Cloudscape(2MB RAM s

Re: CF and Cloudscape/Derby

2005-01-25 Thread Marco Antonio C. Santos
Hi Chuck Portable? Or Embeddable? Postgre(30MB RAM space) and MySQL(50MB RAM space) may be Portable but Cloudscape(2MB RAM space), HSQLDB, etc are a good option for embeddable apps. And yes we're using PG for big apps and MySQL for smaller... PG is very very nice... Cheers Marco On Mon, 24 Jan

Re: CF and Cloudscape/Derby

2005-01-24 Thread Chuck Mason
Robert - Do you use PostgreSQL as the database for any of your CF apps? If yes, how do you like it? I'm keeping my eyes open for a good portable database to use with CFEverywhere (http://www.sys-con.com/story/?storyid=47827&DE=1) and intend on playing with Cloudscape a bit more (Cloudscape i

Re: CF and Cloudscape/Derby

2005-01-24 Thread Robert Everland III
What about PostgreSQL http://www.postgresql.org/ftp/ they just came out with a native win32 version. They have integrated stored procedures unlike MYSQL. Bob Everland ~| Logware: a new and convenient web-based time tracking ap

CF and Cloudscape/Derby

2005-01-24 Thread Dave Merrill
I'm hearing about Cloudscape/Derby as a reasonable database alternative to MySQL etc. Is anyone here using it? Comments on performance? Scalability? Stability? Features? What's the best way to hook CF up to it? Thanks, Dave Merrill ~