RE: alternatives to MS SQL (Pervasive SQL)
I have to use a Pervasive system every day and have a small piece of advice for anyone that is going to attempt this... Run Away! Pervasive has no support for NULL states. It can't handle large SQL statements. It is very case aware. And it's just kludgy to have around! Marcus ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: alternatives to MS SQL (Pervasive SQL)
I want to throw in here.. My experience with PervasiveSQL is that it is a flat file system, not a RDBMS. Both FileMaker and Lotus Approach use the flat-file approach to DBs, if you want a frame of reference. It's not a relational database and I wouldn't recommend using it as a relational database. Business Visions (An accounting software) was developed on top of Pervasive SQL, and while we (when I say we, I mean me) are supposed to write some migration / transfer code to move data from a web order database into the internal Business Visions accounting system, I haven't actually done serious experimentation w/ accesing Pervasive SQL w/ ColdFusion via ODBC. I was very upset after being told that the client was upgrading to the "SQL Server" version of Business Visions to find out that there was no SQL Server version and the 'SQL' version of the product was developed in Pervasive SQL. -- Jeffry Houser | mailto:[EMAIL PROTECTED] AIM: Reboog711 | ICQ: 5246969 | Fax / Phone: 860-223-7946 -- DotComIt: Database Driven Web Data My Book: Instant ColdFusion 5 | http://www.instantcoldfusion.com My New Book: ColdFusion: A Beginner's Guide due out next February -- Far Cry Fly, Alternative Folk Rock http://www.farcryfly.com | http://www.mp3.com/FarCryFly -- Todd for President, muffins for all ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: alternatives to MS SQL
Jon- Check into this MySQL interface: http://www.dbtools.com.br/index.php It has some very powerful import/export routines (MS SQL import, export as XML, etc.). I haven't used anything since for MySQL... Kurt -Original Message- From: jon [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 06, 2001 11:43 AM To: CF-Talk Subject: Re: alternatives to MS SQL There's TONS of support for MySQL, albeit from a community perspective. I would imagine that it wouldn't be too much trouble to find a consultant with a fair amount of experience with it. Also, phpmyadmin is a decent interface to mysql... (there are, of course, others... but nothing I've seen that quite compares to the M$ SQL enterprise manager) I mean -- I can understand their reluctance, but how widely deployed is PervasiveSQL. So pervasive, that no one has ever heard of it? In contrast, mySQL is deployed on probably millions of sites out there. -- jon - jon roig epilepsyfoundation.org On Thu, 6 Dec 2001, Ben Whalley wrote: > Anything out there I should be looking at? A client of ours can't afford > MSSQL but is loath to use free alternatives - no support, nasty interface > etc. > > Came across PervasiveSQL - has anyone had any experience of this? Going to > look at the developer tools etc but would appreciate any info people have > > Regards, > > Ben > > > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: alternatives to MS SQL
Ben, You might check out Interbase. It is free as in BEER source code included, yet has borland backing it for full support. It is not an enterprise scale database, but for a mid to large sized application it is a good choice. It has pretty GUI client for windows etc. Thanks Jeremy Allen elliptIQ Inc. -Original Message- From: Ben Whalley [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 06, 2001 11:31 AM To: CF-Talk Subject: alternatives to MS SQL Anything out there I should be looking at? A client of ours can't afford MSSQL but is loath to use free alternatives - no support, nasty interface etc. Came across PervasiveSQL - has anyone had any experience of this? Going to look at the developer tools etc but would appreciate any info people have Regards, Ben ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: alternatives to MS SQL
PostgreSQL.. is one of the most advanced opensource Databases that i've worked with so far that offers almost all of the main features that Oracle and MSSQL have.. It is also has a strong developed community... Ive just started to use it and i already love it.. - Original Message - From: "Ben Whalley" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, December 06, 2001 10:30 AM Subject: alternatives to MS SQL > Anything out there I should be looking at? A client of ours can't afford > MSSQL but is loath to use free alternatives - no support, nasty interface > etc. > > Came across PervasiveSQL - has anyone had any experience of this? Going to > look at the developer tools etc but would appreciate any info people have > > Regards, > > Ben > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: alternatives to MS SQL
We are developing it but they plan to take it in house for hosting and ongoing development. I didn't have the impression Oracle was a cheap option - am I wrong? Ben ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: alternatives to MS SQL
Oracle. MSAccess. Why would your client care what the interface looks like if you will be doing it and there is support for the free alternatives. On Thu, 6 Dec 2001, Ben Whalley wrote: > Anything out there I should be looking at? A client of ours can't afford > MSSQL but is loath to use free alternatives - no support, nasty interface > etc. > > Came across PervasiveSQL - has anyone had any experience of this? Going to > look at the developer tools etc but would appreciate any info people have > > Regards, > > Ben > > > ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: alternatives to MS SQL
If they have a single licence for Office 2000 or XP, this gives them the ability to use MSDE, which upsizes perfectly to SQL Server when the budget allows for it. Costs nothing, and you still use an NT based database... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 06, 2001 8:53 AM To: CF-Talk Subject: RE: alternatives to MS SQL In my experience it is best to try to stick with some main-stream options. In order to give your client the best service and room for expansion it would (in my opinion) be best to start with something like Access 2000 and upsize to MS SQL when the budget allows. We have supported very high traffic generating sites with a large volume of READ, UPDATE, DELETE functions. Upsizing to SQL has always been a breeze and clients save money. Alternatively hosting at a good company that already has the SQL setup and allows you full access would be good too. - Just some thoughts. - BILL - -Original Message- From: Ben Whalley [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 06, 2001 9:31 AM To: CF-Talk Subject: alternatives to MS SQL Anything out there I should be looking at? A client of ours can't afford MSSQL but is loath to use free alternatives - no support, nasty interface etc. Came across PervasiveSQL - has anyone had any experience of this? Going to look at the developer tools etc but would appreciate any info people have Regards, Ben ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: alternatives to MS SQL
If I'm remember right, PervasiveSQL is from the same folks who did Btrieve. It would be a cheaper alternative to MS SQL, and I was able to get decent support for Btrieve when I neeeded it a few years back. Shawn Grover -Original Message- From: jon [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 06, 2001 9:43 AM To: CF-Talk Subject: Re: alternatives to MS SQL There's TONS of support for MySQL, albeit from a community perspective. I would imagine that it wouldn't be too much trouble to find a consultant with a fair amount of experience with it. Also, phpmyadmin is a decent interface to mysql... (there are, of course, others... but nothing I've seen that quite compares to the M$ SQL enterprise manager) I mean -- I can understand their reluctance, but how widely deployed is PervasiveSQL. So pervasive, that no one has ever heard of it? In contrast, mySQL is deployed on probably millions of sites out there. -- jon - jon roig epilepsyfoundation.org On Thu, 6 Dec 2001, Ben Whalley wrote: > Anything out there I should be looking at? A client of ours can't afford > MSSQL but is loath to use free alternatives - no support, nasty interface > etc. > > Came across PervasiveSQL - has anyone had any experience of this? Going to > look at the developer tools etc but would appreciate any info people have > > Regards, > > Ben > > > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: alternatives to MS SQL
PervasiveSQL is a good product. I have used it in the past with CF and liked it enough to say I'd use it again. The server is fairly easy to set up and speed is comparable to most RDBMS systems. If you don't need support for transactions, I would go with MySQL. There are plenty of resources on the web and in print for it. Kurt -Original Message- From: Ben Whalley [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 06, 2001 11:31 AM To: CF-Talk Subject: alternatives to MS SQL Anything out there I should be looking at? A client of ours can't afford MSSQL but is loath to use free alternatives - no support, nasty interface etc. Came across PervasiveSQL - has anyone had any experience of this? Going to look at the developer tools etc but would appreciate any info people have Regards, Ben ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: alternatives to MS SQL
In my experience it is best to try to stick with some main-stream options. In order to give your client the best service and room for expansion it would (in my opinion) be best to start with something like Access 2000 and upsize to MS SQL when the budget allows. We have supported very high traffic generating sites with a large volume of READ, UPDATE, DELETE functions. Upsizing to SQL has always been a breeze and clients save money. Alternatively hosting at a good company that already has the SQL setup and allows you full access would be good too. - Just some thoughts. - BILL - -Original Message- From: Ben Whalley [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 06, 2001 9:31 AM To: CF-Talk Subject: alternatives to MS SQL Anything out there I should be looking at? A client of ours can't afford MSSQL but is loath to use free alternatives - no support, nasty interface etc. Came across PervasiveSQL - has anyone had any experience of this? Going to look at the developer tools etc but would appreciate any info people have Regards, Ben ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: alternatives to MS SQL
There's TONS of support for MySQL, albeit from a community perspective. I would imagine that it wouldn't be too much trouble to find a consultant with a fair amount of experience with it. Also, phpmyadmin is a decent interface to mysql... (there are, of course, others... but nothing I've seen that quite compares to the M$ SQL enterprise manager) I mean -- I can understand their reluctance, but how widely deployed is PervasiveSQL. So pervasive, that no one has ever heard of it? In contrast, mySQL is deployed on probably millions of sites out there. -- jon - jon roig epilepsyfoundation.org On Thu, 6 Dec 2001, Ben Whalley wrote: > Anything out there I should be looking at? A client of ours can't afford > MSSQL but is loath to use free alternatives - no support, nasty interface > etc. > > Came across PervasiveSQL - has anyone had any experience of this? Going to > look at the developer tools etc but would appreciate any info people have > > Regards, > > Ben > > > ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists