Re: CF and Cloudscape/Derby
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 2005 17:14:27 -0600, Chuck Mason [EMAIL PROTECTED] wrote: 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=47827DE=1) and intend on playing with Cloudscape a bit more (Cloudscape isn't something you jump right into without having reviewed the docs). Cheers! Chuck Robert Everland III wrote: 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 ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191664 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF and Cloudscape/Derby
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 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 2005 17:14:27 -0600, Chuck Mason wrote: 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=47827DE=1) and intend on playing with Cloudscape a bit more (Cloudscape isn't something you jump right into without having reviewed the docs). Cheers! Chuck Robert Everland III wrote: What about PostgreSQL http://www.postgresql.org/ftp/ they just came out with a native win32 version. They have integrated stored procedures unlike MYSQL. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191671 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF and Cloudscape/Derby
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://host/database Driver Class: org.postgresql.Driver username: username password: pass And bingo, connected first time etc. Regards Mark Drew 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, 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 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 2005 17:14:27 -0600, Chuck Mason wrote: 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=47827DE=1) and intend on playing with Cloudscape a bit more (Cloudscape isn't something you jump right into without having reviewed the docs). Cheers! Chuck Robert Everland III wrote: What about PostgreSQL http://www.postgresql.org/ftp/ they just came out with a native win32 version. They have integrated stored procedures unlike MYSQL. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191677 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF and Cloudscape/Derby
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, 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 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 2005 17:14:27 -0600, Chuck Mason wrote: 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=47827DE=1) and intend on playing with Cloudscape a bit more (Cloudscape isn't something you jump right into without having reviewed the docs). Cheers! Chuck Robert Everland III wrote: What about PostgreSQL http://www.postgresql.org/ftp/ they just came out with a native win32 version. They have integrated stored procedures unlike MYSQL. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191678 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF and Cloudscape/Derby
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 tomcat and adding the application as a WAR. Wonder if it is too simple to explain? or should I write an article about it too? MD On Tue, 25 Jan 2005 09:39:04 -0200, Marco Antonio C. Santos [EMAIL PROTECTED] wrote: 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, 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 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 2005 17:14:27 -0600, Chuck Mason wrote: 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=47827DE=1) and intend on playing with Cloudscape a bit more (Cloudscape isn't something you jump right into without having reviewed the docs). Cheers! Chuck Robert Everland III wrote: What about PostgreSQL http://www.postgresql.org/ftp/ they just came out with a native win32 version. They have integrated stored procedures unlike MYSQL. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191680 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF and Cloudscape/Derby
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). It works fine for my needs. For further info on how it stacks up to other database options check the FAQs at http://philcruz.com/cfeverywhere/ What's the best way to hook CF up to it? That's Part 2 of the CFEverywhere article series. It's coming soon... -Phil ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191695 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF and Cloudscape/Derby
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 commercial databases such as Oracle, DB2, SQL Server, and Informix, of course, they require significantly more administration I've worked quite a bit with SQL Server, and while it's clearly more expensive, especially web licensing, and not small footprint, our admin load has been roughly zero, other than backup. Data file about 800M and growing, but not intense throughput, and it's been doing just fine. Is it other folks' impression that recent versions of SQL Server do generally need a lot of dba? How about MySQL? The article is clearly implying that Cloudscape doesn't; is that your impression? That's an important point for both developers and their clients. 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? With Tracking-Tools, I offer it as one of the the supported database options (MSSQL, MYSQL, Oracle, and Cloudscape/Derby). It works fine for my needs. For further info on how it stacks up to other database options check the FAQs at http://philcruz.com/cfeverywhere/ What's the best way to hook CF up to it? That's Part 2 of the CFEverywhere article series. It's coming soon... -Phil ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191699 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF and Cloudscape/Derby
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 application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191599 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF and Cloudscape/Derby
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=47827DE=1) and intend on playing with Cloudscape a bit more (Cloudscape isn't something you jump right into without having reviewed the docs). Cheers! Chuck Robert Everland III wrote: 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 application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191610 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54