Re: What database to use???

2003-06-14 Thread Dana Tierney
Since I usually give complicated answers to questions, I can't help but be amused. First of all, I would like to thank the people posting in this thread as I am reading you all with great interest. I am reading a little more than I can absorb just now, but that's ok :) So. I, a newbie, have a c

Re: What database to use???

2003-06-14 Thread Jochem van Dieten
Doug White wrote: > Please detail the inaccuracies. The Crashme authors want to know. It reports MySQL has a SQL 92 VARCHAR type. Since VARCHAR fields are not allowed to loose trailing spaces, this is not accurate. It reports PostgreSQL does not have circular foreign keys or an ANSI SQL iden

RE: What database to use???

2003-06-14 Thread Chris Kief
So then you probably don't need to worry since you are in control of all the SQL statements :) chris >-Original Message- >From: Dana Tierney [mailto:[EMAIL PROTECTED] >Sent: Saturday, June 14, 2003 1:07 PM >To: CF-Talk >Subject: Re: What database to use??? > >

Re: What database to use???

2003-06-14 Thread Jochem van Dieten
Dana Tierney wrote: > Well, I have a couple of different situations going on. In the one case I > will probably keep sole access, alhough gee, I can envision cases where it > would be nice to have a volunteer doing data entry, so I would like to > idiotproof it and make this possible. But then

Re: What database to use???

2003-06-14 Thread Dana Tierney
y > working with the data via a CF application? > > chris > > > > >> -Original Message- >> From: Dana Tierney [mailto:[EMAIL PROTECTED] >> Sent: Saturday, June 14, 2003 12:53 PM >> To: CF-Talk >> Subject: Re: What database to use??? >&g

RE: What database to use???

2003-06-14 Thread Chris Kief
Saturday, June 14, 2003 12:53 PM >To: CF-Talk >Subject: Re: What database to use??? > >Well, I have a couple of different situations going on. In the one case I >will probably keep sole access, alhough gee, I can envision cases where it >would be nice to have a volunteer doin

Re: What database to use???

2003-06-14 Thread Dana Tierney
Well, I have a couple of different situations going on. In the one case I will probably keep sole access, alhough gee, I can envision cases where it would be nice to have a volunteer doing data entry, so I would like to idiotproof it and make this possible. In the other case, we would be talkin

Re: What database to use???

2003-06-14 Thread Jochem van Dieten
Dana Tierney wrote: > So you are saying his resource is wrong about that? I am convinced they can all be crashed by people with sufficient priviledges and destructive tendencies. > They all can be crashed? Sure. Just do the math on the following query for a 100 row table: SELECT * FROM table

Re: What database to use???

2003-06-14 Thread Doug White
you are not satisfied with my service, my job isn't done! - Original Message - From: "Dana Tierney" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, June 14, 2003 1:57 PM Subject: Re: What database to use??? | On Sat, 14 Jun 2

Re: What database to use???

2003-06-14 Thread Dana Tierney
On Sat, 14 Jun 2003 16:11:35 +0200, Jochem van Dieten <[EMAIL PROTECTED]> wrote: > Dana Tierney wrote: > >> I am going by Doug's resource, that is what it says about the MS abd IBM >> products. And that would be something I would have to account for, ya, >> utterly illiterate clients. > > Unfortu

Re: What database to use???

2003-06-14 Thread Dana Tierney
So you are saying his resource is wrong about that? They all can be crashed? By normal user I am taking it we mean someone with write access? Dana On Sat, 14 Jun 2003 16:11:35 +0200, Jochem van Dieten <[EMAIL PROTECTED]> wrote: > Dana Tierney wrote: > >> I am going by Doug's resource, that is

Re: What database to use???

2003-06-14 Thread Jochem van Dieten
Dana Tierney wrote: > I am going by Doug's resource, that is what it says about the MS abd IBM > products. And that would be something I would have to account for, ya, > utterly illiterate clients. Unfortunately, Doug's resource seems to have been made using the crash-me utility, which is far f

Re: What database to use???

2003-06-14 Thread Dana Tierney
iginal Message- > From: Dana Tierney [mailto:[EMAIL PROTECTED] > Sent: 14 June 2003 13:46 > To: CF-Talk > Subject: Re: What database to use??? > > > Anyone with normal access can crash an Access database That's about all > I need to hear in Mysql vs Access >

Re: What database to use???

2003-06-14 Thread Jochem van Dieten
Dana Tierney wrote: > Anyone with normal access can crash an Access database That's about all > I need to hear in Mysql vs Access Why? Do you give other people normal access to databases? Or do you predefine queries where they only get to fill out the parameters? Besides, crashing goes

RE: What database to use???

2003-06-14 Thread Robertson-Ravo, Neil (RX)
any one with access to mysql can crash it... -Original Message- From: Dana Tierney [mailto:[EMAIL PROTECTED] Sent: 14 June 2003 13:46 To: CF-Talk Subject: Re: What database to use??? Anyone with normal access can crash an Access database That's about all I need to hear in Mys

Re: What database to use???

2003-06-14 Thread Dana Tierney
Anyone with normal access can crash an Access database That's about all I need to hear in Mysql vs Access Dana > > | > There was a recent thread where different folks were > > | > talking about their > > | > favorite database to use when building web > > applications, > > | > and I have p

Re: What database to use???

2003-06-14 Thread Dana Tierney
uot; <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Friday, June 13, 2003 10:17 PM > Subject: Re: What database to use??? > > > | Thanks a lot Doug, this is a really great resource... > | > | The only comment I have is that it's

Re: What database to use???

2003-06-13 Thread S . Isaac Dealey
Isaac Dealey" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Friday, June 13, 2003 10:17 PM > Subject: Re: What database to use??? > | Thanks a lot Doug, this is a really great resource... > | > | The only comment I have is that it's

Re: What database to use???

2003-06-13 Thread Doug White
== If you are not satisfied with my service, my job isn't done! - Original Message - From: "S.Isaac Dealey" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, June 13, 2003 10:17 PM Subject: Re: What database to use??? | Than

Re: What database to use???

2003-06-13 Thread S . Isaac Dealey
Thanks a lot Doug, this is a really great resource... The only comment I have is that it's tough to follow the headers with so many items in a given group -- you might add one in every 10 lines or so. In an Excel sheet I'd lock the headers at the top and only scroll the remaining rows, although

Re: What database to use???

2003-06-13 Thread Doug White
There was a recent thread where different folks were talking about their favorite database to use when building web applications, and I have put together an extensive feature comparison between the various flavors available, that goes quite a bit beyond the sales hype. Some of you just might be su