Re: What database to use???
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 couple of databases currently set up in mysql. From what I gather: Reasons to switch to Access truncation issue in mysql some issues with null values and numerics in mysql easier interface in Access Reasons not to switch to Access Possible security issues Performance issues? mysql may scale better Microsoft. I am sure there is a lot more that could be said, but are all of the above statements true? (OK, no need to flame me on the last reason; yeah, we all either agree with it or we dont, true) Dana On Sat, 14 Jun 2003 22:48:38 +0200, Jochem van Dieten <[EMAIL PROTECTED]> wrote: > 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 > identifier quote. > > It reports for many databases that they support subqueries, SUM, EXISTS > and GROUP BY. I know that at least Access and PostgreSQL fail the > following query: > SELECTprojectnumber, > SUM(workhours) > FROM work > GROUP BY > projectnumber > HAVINGEXISTS ( > SELECT projectname > FROMprojects > WHERE projects.projectnumber = work.projectnumber > AND > SUM(work.workhours) > projects.budget / 200 > ) > I expect some more databases to fail this one, but according to the table > presented by that crash-me tool it should work. > (I didn't invent this query, it is from the NIST SQL Compliance Test.) > > And if we take the text on top "Some tests may fail because the database > in question does not follow ANSI SQL 92 or ODBC 3.0 but in this case we > regard this as a failure in the database." literally, many of the results > are not logical. > Why does the test show that "Calculate 1--1" is supported by databases, > while it is not even a calculation because "--" is the start of a line of > comment in SQL 92? > How can "Function OR as '||'" be a function if SQL 92 says it is the > concatenation operator? > How can " be allowed as a string marker when the SQL spec says it is an > identifier quote? > How can ' be allowed as identifier quote when SQL 92 says it is a string > delimiter? > > > And as for the completeness, I find the choice of listed functionality > rather curious. Abundant data on ODBC, yet nothing on JDBC, which is what > CF MX uses. > And nothing on OLAP functionality, WITH [RECURSIVE], object facilities, > the information schema, procedural languages and many other high end > features. > > All of this is quite understandable since MySQL AB uses crash-me for > regression testing of their own database, and there is little point in > testing things you don't support anyway. But that does mean it gives a > somewhat different result then if you would use the tools any of the > other databases. > > Just for a comparison, take a look at the following feature comparison > table and notice how suddenly the product of the company that created > that comparison shines (and check out their SQL validator): > http://developer.mimer.com/validator/comparison/comparison%20chart.tml > > Jochem > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What database to use???
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 identifier quote. It reports for many databases that they support subqueries, SUM, EXISTS and GROUP BY. I know that at least Access and PostgreSQL fail the following query: SELECT projectnumber, SUM(workhours) FROMwork GROUP BY projectnumber HAVING EXISTS ( SELECT projectname FROMprojects WHERE projects.projectnumber = work.projectnumber AND SUM(work.workhours) > projects.budget / 200 ) I expect some more databases to fail this one, but according to the table presented by that crash-me tool it should work. (I didn't invent this query, it is from the NIST SQL Compliance Test.) And if we take the text on top "Some tests may fail because the database in question does not follow ANSI SQL 92 or ODBC 3.0 but in this case we regard this as a failure in the database." literally, many of the results are not logical. Why does the test show that "Calculate 1--1" is supported by databases, while it is not even a calculation because "--" is the start of a line of comment in SQL 92? How can "Function OR as '||'" be a function if SQL 92 says it is the concatenation operator? How can " be allowed as a string marker when the SQL spec says it is an identifier quote? How can ' be allowed as identifier quote when SQL 92 says it is a string delimiter? And as for the completeness, I find the choice of listed functionality rather curious. Abundant data on ODBC, yet nothing on JDBC, which is what CF MX uses. And nothing on OLAP functionality, WITH [RECURSIVE], object facilities, the information schema, procedural languages and many other high end features. All of this is quite understandable since MySQL AB uses crash-me for regression testing of their own database, and there is little point in testing things you don't support anyway. But that does mean it gives a somewhat different result then if you would use the tools any of the other databases. Just for a comparison, take a look at the following feature comparison table and notice how suddenly the product of the company that created that comparison shines (and check out their SQL validator): http://developer.mimer.com/validator/comparison/comparison%20chart.tml Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: What database to use???
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??? > >working with data via a cf application. > >Dana > > >On Sat, 14 Jun 2003 13:02:20 -0700, Chris Kief <[EMAIL PROTECTED]> >wrote: > >> Just to clear something up here...are you giving your users direct access >> to >> the database (ie. they're writing ad-hoc SQL statements)? Or are they >> 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??? >>> >>> 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 talking about the customer :) and I hope >>> to >>> hand him the keys to this thing and walk away. It would be nice if it >>> did >>> not break for a reasonable time thereafter. >>> >>> In neither case are we talking about people who are computer literate. >>> At >>> all. So I guess my next question is, would crashing any/all of these >>> *require* computer knowledge and, as you put it, destructive tendencies? >>> >>> Dana >>> >>>> >>>> The real question is, why would you give somebody you don't trust >>>> access >>>> to your data in the first place? >>>> >>>> Jochem >>>> >>>> >>> >> > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What database to use???
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 you can write the SQL statement and the user just fills out the cfqueryparam's. No risk in that. > In the other case, we would be talking about the customer :) and I hope to > hand him the keys to this thing and walk away. It would be nice if it did > not break for a reasonable time thereafter. Again, you write the SQL statement and they just fill out the cfqueryparam's. > In neither case are we talking about people who are computer literate. At > all. So I guess my next question is, would crashing any/all of these > *require* computer knowledge and, as you put it, destructive tendencies? Typically with CF applications, you create an interface to the database. As long as they use your interface, they use your SQL and it really is no big deal. If they go into the database using other tools, they can mess up. So usually that is where the warranty ends and the destructive tendencies start. I mean, if somebody is really going around "what does this button do?", there is no way to stop them. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What database to use???
working with data via a cf application. Dana On Sat, 14 Jun 2003 13:02:20 -0700, Chris Kief <[EMAIL PROTECTED]> wrote: > Just to clear something up here...are you giving your users direct access > to > the database (ie. they're writing ad-hoc SQL statements)? Or are they > 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??? >> >> 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 talking about the customer :) and I hope >> to >> hand him the keys to this thing and walk away. It would be nice if it >> did >> not break for a reasonable time thereafter. >> >> In neither case are we talking about people who are computer literate. >> At >> all. So I guess my next question is, would crashing any/all of these >> *require* computer knowledge and, as you put it, destructive tendencies? >> >> Dana >> >>> >>> The real question is, why would you give somebody you don't trust >>> access >>> to your data in the first place? >>> >>> Jochem >>> >>> >> > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: What database to use???
Just to clear something up here...are you giving your users direct access to the database (ie. they're writing ad-hoc SQL statements)? Or are they 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??? > >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 talking about the customer :) and I hope to >hand him the keys to this thing and walk away. It would be nice if it did >not break for a reasonable time thereafter. > >In neither case are we talking about people who are computer literate. At >all. So I guess my next question is, would crashing any/all of these >*require* computer knowledge and, as you put it, destructive tendencies? > >Dana > >> >> The real question is, why would you give somebody you don't trust access >> to your data in the first place? >> >> Jochem >> >> > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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 doing data entry, so I would like to idiotproof it and make this possible. In the other case, we would be talking about the customer :) and I hope to hand him the keys to this thing and walk away. It would be nice if it did not break for a reasonable time thereafter. In neither case are we talking about people who are computer literate. At all. So I guess my next question is, would crashing any/all of these *require* computer knowledge and, as you put it, destructive tendencies? Dana > > The real question is, why would you give somebody you don't trust access > to your data in the first place? > > Jochem > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What database to use???
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 a, table b, table c, table d, table e ORDER BY a.id Sorting 10 bilion rows requires more space as is available on most systems. Some databases handling this particularly bad can crash irrecoverably from this. Others will just run out of space and stop and roll back on restart. Others, mainly the big 3 if configured correctly, might not even crash in the sense that they start returning the wrong results or stop returning results completely, but they will slow down in such away that the data is inaccessible. Other options include keeping transactions open forever and stowing more and more updates in them until the transaction log runs out of space, defining a function that does nothing but call itself etc. > By normal user I am taking it we mean someone with write access? If you have UPDATE or DELETE, you can just delete or overwrite the data, no need to crash anything. The real question is, why would you give somebody you don't trust access to your data in the first place? Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What database to use???
Please detail the inaccuracies. The Crashme authors want to know. == Stop spam on your domain, use our gateway! For hosting solutions http://www.clickdoug.com ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772 == If 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 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. | > | > Unfortunately, Doug's resource seems to have been made using the crash-me | > utility, which is far from complete and in some cases inaccurate. | > | > Jochem | > | > | > | ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What database to use???
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. > > Unfortunately, Doug's resource seems to have been made using the crash-me > utility, which is far from complete and in some cases inaccurate. > > Jochem > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What database to use???
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 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 from complete and in some cases inaccurate. > > Jochem > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What database to use???
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 from complete and in some cases inaccurate. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What database to use???
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. Dana Robertson-Ravo, Neil (RX) writes: > 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 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 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 surprised. > > > | > > > | > You can view the feature and performance comparisons > > > at > > > | > the following link: > > > | > > > | > > > > http://www.clickdoug.com/compare/FeatureComparisons.htm > > > | > > > | > > > | > == > > > | > Stop spam on your domain, use our gateway! > > > | > For hosting solutions http://www.clickdoug.com > > > | > ISP rated: > > > http://www.forta.com/cf/isp/isp.cfm?isp_id=772 > > > | > == > > > | > If you are not satisfied with my service, my job isn't > > > | > done! > > > | > > > | > > > > ~~ > > > | > ~~~| > > > | > Archives: > > > | > > > > http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 > > > | > Subscription: > > > http://www.houseoffusion.com/cf_lists/index. > > > | > cfm?method=subscribe&forumid=4 > > > | > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq > > > | > > > | > Get the mailserver that powers this list at > > > | > http://www.coolfusion.com > > > | > > > | > Unsubscribe: http://www.houseoffusion.com/cf_lists/uns > > > | > ubscribe.cfm?user=633.558.4 > > > | > > > | > > > | > > > | > > > | s. isaac dealey972-490-6624 > > > | > > > | new epoch http://www.turnkey.to > > > | > > > | lead architect, tapestry cms > > > http://products.turnkey.to > > > | > > > | tapestry api is opensource > > > http://www.turnkey.to/tapi > > > | > > > | certified advanced coldfusion 5 developer > > > | http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 > > > | > > > | > > > | > > > ~~ > > > ~~~| > > > Archives: > > > http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 > > > Subscription: http://www.houseoffusion.com/cf_lists/index. > > > cfm?method=subscribe&forumid=4 > > > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq > > > > > Host with the leader in ColdFusion hosting. > > > Voted #1 ColdFusion host by CF Developers. > > > Offering shared and dedicated hosting options. > > > www.cfxhosting.com/default.cfm?redirect=10481 > > > > > Unsubscribe: > http://www.houseoffusion.com/cf_lists/uns > > > ubscribe.cfm?user=633.558.4 > > > > > > > > > > s. isaac dealey972-490-6624 > > > > new epoch http://www.turnkey.to > > > > lead architect, tapestry cms http://products.turnkey.to > > > > tapestry api is opensource http://www.turnkey.to/tapi > > > > certified advanced coldfusion 5 developer > > http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 > > > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What database to use???
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 for about every database. Just do an unconstrained join with sufficient tables and it will crash because the server runs out of resources. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: What database to use???
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 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 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 surprised. > > | > > | > You can view the feature and performance comparisons > > at > > | > the following link: > > | > > | > > > http://www.clickdoug.com/compare/FeatureComparisons.htm > > | > > | > > | > == > > | > Stop spam on your domain, use our gateway! > > | > For hosting solutions http://www.clickdoug.com > > | > ISP rated: > > http://www.forta.com/cf/isp/isp.cfm?isp_id=772 > > | > == > > | > If you are not satisfied with my service, my job isn't > > | > done! > > | > > | > > > ~~ > > | > ~~~| > > | > Archives: > > | > > > http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 > > | > Subscription: > > http://www.houseoffusion.com/cf_lists/index. > > | > cfm?method=subscribe&forumid=4 > > | > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq > > | > > | > Get the mailserver that powers this list at > > | > http://www.coolfusion.com > > | > > | > Unsubscribe: http://www.houseoffusion.com/cf_lists/uns > > | > ubscribe.cfm?user=633.558.4 > > | > > | > > | > > | > > | s. isaac dealey972-490-6624 > > | > > | new epoch http://www.turnkey.to > > | > > | lead architect, tapestry cms > > http://products.turnkey.to > > | > > | tapestry api is opensource > > http://www.turnkey.to/tapi > > | > > | certified advanced coldfusion 5 developer > > | http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 > > | > > | > > | > > ~~ > > ~~~| > > Archives: > > http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 > > Subscription: http://www.houseoffusion.com/cf_lists/index. > > cfm?method=subscribe&forumid=4 > > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq > > > Host with the leader in ColdFusion hosting. > > Voted #1 ColdFusion host by CF Developers. > > Offering shared and dedicated hosting options. > > www.cfxhosting.com/default.cfm?redirect=10481 > > > Unsubscribe: http://www.houseoffusion.com/cf_lists/uns > > ubscribe.cfm?user=633.558.4 > > > > > s. isaac dealey972-490-6624 > > new epoch http://www.turnkey.to > > lead architect, tapestry cms http://products.turnkey.to > > tapestry api is opensource http://www.turnkey.to/tapi > > certified advanced coldfusion 5 developer > http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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 Dana > > | > 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 surprised. > > | > > | > You can view the feature and performance comparisons > > at > > | > the following link: > > | > > | > > > http://www.clickdoug.com/compare/FeatureComparisons.htm > > | > > | > > | > == > > | > Stop spam on your domain, use our gateway! > > | > For hosting solutions http://www.clickdoug.com > > | > ISP rated: > > http://www.forta.com/cf/isp/isp.cfm?isp_id=772 > > | > == > > | > If you are not satisfied with my service, my job isn't > > | > done! > > | > > | > > > ~~ > > | > ~~~| > > | > Archives: > > | > > > http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 > > | > Subscription: > > http://www.houseoffusion.com/cf_lists/index. > > | > cfm?method=subscribe&forumid=4 > > | > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq > > | > > | > Get the mailserver that powers this list at > > | > http://www.coolfusion.com > > | > > | > Unsubscribe: http://www.houseoffusion.com/cf_lists/uns > > | > ubscribe.cfm?user=633.558.4 > > | > > | > > | > > | > > | s. isaac dealey972-490-6624 > > | > > | new epoch http://www.turnkey.to > > | > > | lead architect, tapestry cms > > http://products.turnkey.to > > | > > | tapestry api is opensource > > http://www.turnkey.to/tapi > > | > > | certified advanced coldfusion 5 developer > > | http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 > > | > > | > > | > > ~~ > > ~~~| > > Archives: > > http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 > > Subscription: http://www.houseoffusion.com/cf_lists/index. > > cfm?method=subscribe&forumid=4 > > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq > > > Host with the leader in ColdFusion hosting. > > Voted #1 ColdFusion host by CF Developers. > > Offering shared and dedicated hosting options. > > www.cfxhosting.com/default.cfm?redirect=10481 > > > Unsubscribe: http://www.houseoffusion.com/cf_lists/uns > > ubscribe.cfm?user=633.558.4 > > > > > s. isaac dealey972-490-6624 > > new epoch http://www.turnkey.to > > lead architect, tapestry cms http://products.turnkey.to > > tapestry api is opensource http://www.turnkey.to/tapi > > certified advanced coldfusion 5 developer > http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What database to use???
just noticed this. As one of the people asking questions in that thread, thank you :) Dana Doug White writes: > Speed and comprehensiveness finished ahead of good design, I am afraid :-( > > == > Stop spam on your domain, use our gateway! > For hosting solutions http://www.clickdoug.com > ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772 > == > 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??? > > > | 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 I realize a lot of Mac / *nix users may not have ready access to > software that displays these files gracefully. > | > | > 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 surprised. > | > | > You can view the feature and performance comparisons at > | > the following link: > | > | > http://www.clickdoug.com/compare/FeatureComparisons.htm > | > | > | > == > | > Stop spam on your domain, use our gateway! > | > For hosting solutions http://www.clickdoug.com > | > ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772 > | > == > | > If you are not satisfied with my service, my job isn't > | > done! > | > | > ~~ > | > ~~~| > | > Archives: > | > http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 > | > Subscription: http://www.houseoffusion.com/cf_lists/index. > | > cfm?method=subscribe&forumid=4 > | > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq > | > | > Get the mailserver that powers this list at > | > http://www.coolfusion.com > | > | > Unsubscribe: http://www.houseoffusion.com/cf_lists/uns > | > ubscribe.cfm?user=633.558.4 > | > | > | > | > | s. isaac dealey972-490-6624 > | > | new epoch http://www.turnkey.to > | > | lead architect, tapestry cms http://products.turnkey.to > | > | tapestry api is opensource http://www.turnkey.to/tapi > | > | certified advanced coldfusion 5 developer > | http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 > | > | > | > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What database to use???
Not a criticism at all. It's an excellent resource, thanks a lot for putting that together and for making it available. > Speed and comprehensiveness finished ahead of good > design, I am afraid :-( > == > Stop spam on your domain, use our gateway! > For hosting solutions http://www.clickdoug.com > ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772 > == > 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??? > | 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 I realize a lot of Mac / *nix users may not have > ready access to > software that displays these files gracefully. > | > | > 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 surprised. > | > | > You can view the feature and performance comparisons > at > | > the following link: > | > | > > http://www.clickdoug.com/compare/FeatureComparisons.htm > | > | > | > == > | > Stop spam on your domain, use our gateway! > | > For hosting solutions http://www.clickdoug.com > | > ISP rated: > http://www.forta.com/cf/isp/isp.cfm?isp_id=772 > | > == > | > If you are not satisfied with my service, my job isn't > | > done! > | > | > > ~~ > | > ~~~| > | > Archives: > | > > http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 > | > Subscription: > http://www.houseoffusion.com/cf_lists/index. > | > cfm?method=subscribe&forumid=4 > | > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq > | > | > Get the mailserver that powers this list at > | > http://www.coolfusion.com > | > | > Unsubscribe: http://www.houseoffusion.com/cf_lists/uns > | > ubscribe.cfm?user=633.558.4 > | > | > | > | > | s. isaac dealey972-490-6624 > | > | new epoch http://www.turnkey.to > | > | lead architect, tapestry cms > http://products.turnkey.to > | > | tapestry api is opensource > http://www.turnkey.to/tapi > | > | certified advanced coldfusion 5 developer > | http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 > | > | > | > ~~ > ~~~| > Archives: > http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 > Subscription: http://www.houseoffusion.com/cf_lists/index. > cfm?method=subscribe&forumid=4 > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq > Host with the leader in ColdFusion hosting. > Voted #1 ColdFusion host by CF Developers. > Offering shared and dedicated hosting options. > www.cfxhosting.com/default.cfm?redirect=10481 > Unsubscribe: http://www.houseoffusion.com/cf_lists/uns > ubscribe.cfm?user=633.558.4 s. isaac dealey972-490-6624 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What database to use???
Speed and comprehensiveness finished ahead of good design, I am afraid :-( == Stop spam on your domain, use our gateway! For hosting solutions http://www.clickdoug.com ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772 == 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??? | 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 I realize a lot of Mac / *nix users may not have ready access to software that displays these files gracefully. | | > 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 surprised. | | > You can view the feature and performance comparisons at | > the following link: | | > http://www.clickdoug.com/compare/FeatureComparisons.htm | | | > == | > Stop spam on your domain, use our gateway! | > For hosting solutions http://www.clickdoug.com | > ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772 | > == | > If you are not satisfied with my service, my job isn't | > done! | | > ~~ | > ~~~| | > Archives: | > http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 | > Subscription: http://www.houseoffusion.com/cf_lists/index. | > cfm?method=subscribe&forumid=4 | > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq | | > Get the mailserver that powers this list at | > http://www.coolfusion.com | | > Unsubscribe: http://www.houseoffusion.com/cf_lists/uns | > ubscribe.cfm?user=633.558.4 | | | | | s. isaac dealey972-490-6624 | | new epoch http://www.turnkey.to | | lead architect, tapestry cms http://products.turnkey.to | | tapestry api is opensource http://www.turnkey.to/tapi | | certified advanced coldfusion 5 developer | http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 | | | ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What database to use???
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 I realize a lot of Mac / *nix users may not have ready access to software that displays these files gracefully. > 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 surprised. > You can view the feature and performance comparisons at > the following link: > http://www.clickdoug.com/compare/FeatureComparisons.htm > == > Stop spam on your domain, use our gateway! > For hosting solutions http://www.clickdoug.com > ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772 > == > If you are not satisfied with my service, my job isn't > done! > ~~ > ~~~| > Archives: > http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 > Subscription: http://www.houseoffusion.com/cf_lists/index. > cfm?method=subscribe&forumid=4 > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq > Get the mailserver that powers this list at > http://www.coolfusion.com > Unsubscribe: http://www.houseoffusion.com/cf_lists/uns > ubscribe.cfm?user=633.558.4 s. isaac dealey972-490-6624 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What database to use???
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 surprised. You can view the feature and performance comparisons at the following link: http://www.clickdoug.com/compare/FeatureComparisons.htm == Stop spam on your domain, use our gateway! For hosting solutions http://www.clickdoug.com ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772 == If you are not satisfied with my service, my job isn't done! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
