Re: alternatives to MS SQL

2001-12-06 Thread jon
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

RE: alternatives to MS SQL

2001-12-06 Thread Bill King
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

RE: alternatives to MS SQL

2001-12-06 Thread Kurt Ward
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

RE: alternatives to MS SQL

2001-12-06 Thread Shawn Grover
: 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

RE: alternatives to MS SQL

2001-12-06 Thread Costas Piliotis
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

Re: alternatives to MS SQL

2001-12-06 Thread Alex
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

RE: alternatives to MS SQL

2001-12-06 Thread Ben Whalley
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

Re: alternatives to MS SQL

2001-12-06 Thread Alexis Maldonado
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 -

RE: alternatives to MS SQL

2001-12-06 Thread Jeremy Allen
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

RE: alternatives to MS SQL

2001-12-06 Thread Kurt Ward
, 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

RE: alternatives to MS SQL (Pervasive SQL)

2001-12-06 Thread Jeffry Houser
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

RE: alternatives to MS SQL (Pervasive SQL)

2001-12-06 Thread Marcus
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