If you're going to start again with a free database there are a few options apart from mySQL.
http://www.postgresql.org - Works great as long as you are happy to use *nix as the database operating system http://www.sapdb.org - Just downloaded and installed it last friday. It's definitely looking like an alternative to SQL Server, but I haven't given it any real hard testing yet. Both these have a similar level of functionality to SQL 2000 - Stored procedures, indexes, triggers, user defined functions (PostgreSQL only). If you actually need these features then they're well worth checking out. If you just need a glorified flat file database (which is the case for many web apps) then mySQL should do fine. For most people, the main objection to PostgreSQL is that it only really works properly on *nix although you can get it to work on Windows. The main objection to SapDB is that it works differently to Access/SQL Server, but then again it has extensive documentation, so if you run into a problem you can normally find a solution pretty quickly. The same applies to the PostgreSQL documentation, but if you're not *nix savvy, it might turn out to be a bit of a headache. Just my thruppence. Spike > -----Original Message----- > From: Robertson-Ravo, Neil (REC) > [mailto:[EMAIL PROTECTED]] > Sent: 23 September 2002 15:17 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] Which SQL ?? > > > You are correct, it is no where near as powerful, but it is free. > > -----Original Message----- > From: Tom Smith [mailto:[EMAIL PROTECTED]] > Sent: 23 September 2002 14:20 > To: [EMAIL PROTECTED] > Subject: Re: [ cf-dev ] Which SQL ?? > > > the non-development release (of MYSQL) does not support > nested sub queries or stored procedures, which in my eyes is > a reason not to use it. this means that the functionality is > far less that you can expect from SQL server.... take an example > > select * from table where id in (select id from table2) > > would have to be done in at least to queries... > > psuedo code: > cfquery1 > select id from table2 > > cfquery2 > select * from table where i_id in (valuelist(cfquery1.id)) > > this is 2 queries where one should suffice, this is 2 > connections where one should suffice. obviously this example > isn't best, but use you imagination and you should be able to > see where this could be problematic... > > Stored procedures are a fantastic way of using the data in > the database as well... I prefer stored procedures as there > is so much you can do with them, and they are definitely much > more secure than writing queries... think about doing some > data manipulation that you have to do with CF, and the write > it back to the database, this shoudl be possible using a > stored procedure. > > I am sure there are other reasons, but I am pretty new to > MySQL and it's OK, but not nearly as powerful as SQL server... > > ----- Original Message ----- > From: <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Monday, September 23, 2002 11:48 AM > Subject: RE: [ cf-dev ] Which SQL ?? > > > > Thanks for all the info so far. > > > > Just wondering what the special functionality is that > SQL2000 has over > > mysql. > > > > It looks like sql2000 is what we need but he bods will ask why and > > will want a non techy answer as to do we spend > > > > ************************************************************* > > This email and any files transmitted with it are confidential and > > intended solely for the use of the individual or entity to > whom they > > are addressed. If you have received this email in error > please notify > > [EMAIL PROTECTED] > > > > The views expressed within this email are those of the > individual, and > > not necessarily those of the organisation > > ************************************************************* > > > > > > > -------------------------------------------------------------- > -------------- > ---- > > > > �xxxx or do we get mysql for much > cheaper. > > Can anyone let me know why not to use mysql - all that head > banging stuff etc.... > > Regards - Paul. > > > > > -------------------------------------------------------------- > -------------- > ---- > > > > -- > > ** Archive: > http://www.mail-archive.com/dev%> 40lists.cfdeveloper.co.uk/ > > > > > To unsubscribe, e-mail: > [EMAIL PROTECTED] > > For additional commands, e-mail: > [EMAIL PROTECTED] For > > human help, e-mail: [EMAIL PROTECTED] > > __________________________________________________ > Do You Yahoo!? > Everything you'll ever need on one web page > from News and Sport to Email and Music Charts http://uk.my.yahoo.com > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] For human help, e-mail: > [EMAIL PROTECTED] > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] For human help, e-mail: > [EMAIL PROTECTED] > > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
