Re: Here we go again...WebDNA - SQL- Clustering
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 66734
interpreted = N
texte = Hi Donovan Yes, the right tools for the right task :-) Most applications (I=20= bet even in the PHP world) would work with a flat file system. It= is hassle free, no need to install a separate server and so on.=20= I think PHP or alike just never did anything else then talking to= a SQL server and thus the widespread use of MySQL. My point is just that we have all used flat files for so long, th= at once you switch to SQL and see it's possibilities it makes a l= ot of sense and one should consider to code future projects with=20= a SQL database. This is even a safe precaution because if anythin= g happens you already have the database and all what is needed is= to change the middleware (WebDNA, ColdFusion, PHP, etc.). But as always, these are just suggestions :-) Nitai -- eContentPark - Enterprise Digital Asset Management eServices - The complete SupportSuite eSurvey - Online Questionnaire made easy Redakto CMS - Content Management that simply works ComputerOil=C2=AE AG Neugutstrasse 66 8600 D=C3=BCbendorf / Switzerland Telefon +41 (0)844 44 55 66 info@computeroil.com http://computeroil.com > -----Original Message----- > From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On B= ehalf Of > Donovan Brooke > Sent: Dienstag, 4. April 2006 18:13 > To: WebDNA Talk > Subject: Re: Here we go again...WebDNA - SQL- Clustering > > nitai@computeroil.com wrote: > > > Let's put it in simple word: > > > > Once you start using SQL syntax and use some of the languages= > > very own features like JOIN or UNION you simply won't go bac= k > > to use flat files. > > > > Instead of using a search within a search and then a lookup > > within that founditems (all true real world examples) and yo= u > > see how easy this is done with ONE SQL statement it should > > start making sense to everyone :-) > > > > It just open up a new world of possibilities. Imagine you > > have one single location for all your data and that location= > > does not even has to be in house. That other systems can con= nect > > to it as well is a life saver sometimes. > > > > Now when you start with stored procedures you have another > > story where your database does all the work for you and not > > the webserver anymore... > > > > I don't think this is a conversation of the scripting languag= e > > but more why to use SQL. > > > > Nitai > > This was a conversation about SMSI support that turned into (fa= lse) > statements about webdna that turned into SQL promotion (amongst= other > things). :-) I was > correcting wreckless false statements such as webdna db's not > being relationable, and more generally, the message that webdna= > is not a valid solution. Frankly, I'm a bit suprised that no ot= her > long-timers joined in. > > > I don't know when the conversation turned into promoting SQL, b= ut you > can count me in. I am not against using the right tool for the > job. But I think using SQL because its accepted or using SQL fo= r your > resume is just that.. using it for the resume. Though I have us= ed the SQL > tags in the very occassional soution, relational flat files > still are the best working solution for 97% of my clients (I do= mostly > eCommerce stuff). There is absolutely no downside to using them= .. The > times I do consider other options is when the customer wants to= connect > to a core inventory database or something.. or even when they a= re > thinking about connections in the future... > Flat files can migrate to most any platform.. so even if webdna= > dissappears, the data is just fine (well, webdna encrypted fiel= ds would > have to be parsed). > > I said that I think it's wreckless.. because end users (our cli= ents) may > watch this list. They are getting false ideas about webdna's ca= pabilities. > > Donovan > > -- > =3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do= =3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do > DONOVAN D. BROOKE EUCA Design Center > > <- Web Development (specializing in eCommerce),-> > <- Custom Paint, Labels, and Specialty Signage. -> > <- Home and Business Embellishment/Fabrication, -> > <- Glass Blowing, and Art Glass -> > > PH/FAX:> 1 (608) 835-2476 > Web:> http://www.egg.bz | http://www.euca.us > =3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do= =3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list
. > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to digest@talk.smithmicro.com> > Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Hi Donovan Yes, the right tools for the right task :-) Most applications (I=20= bet even in the PHP world) would work with a flat file system. It= is hassle free, no need to install a separate server and so on.=20= I think PHP or alike just never did anything else then talking to= a SQL server and thus the widespread use of MySQL. My point is just that we have all used flat files for so long, th= at once you switch to SQL and see it's possibilities it makes a l= ot of sense and one should consider to code future projects with=20= a SQL database. This is even a safe precaution because if anythin= g happens you already have the database and all what is needed is= to change the middleware (WebDNA, ColdFusion, PHP, etc.). But as always, these are just suggestions :-) Nitai -- eContentPark - Enterprise Digital Asset Management eServices - The complete SupportSuite eSurvey - Online Questionnaire made easy Redakto CMS - Content Management that simply works ComputerOil=C2=AE AG Neugutstrasse 66 8600 D=C3=BCbendorf / Switzerland Telefon +41 (0)844 44 55 66 info@computeroil.com http://computeroil.com > -----Original Message----- > From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On B= ehalf Of > Donovan Brooke > Sent: Dienstag, 4. April 2006 18:13 > To: WebDNA Talk > Subject: Re: Here we go again...WebDNA - SQL- Clustering > > nitai@computeroil.com wrote: > > > Let's put it in simple word: > > > > Once you start using SQL syntax and use some of the languages= > > very own features like JOIN or UNION you simply won't go bac= k > > to use flat files. > > > > Instead of using a search within a search and then a lookup > > within that founditems (all true real world examples) and yo= u > > see how easy this is done with ONE SQL statement it should > > start making sense to everyone :-) > > > > It just open up a new world of possibilities. Imagine you > > have one single location for all your data and that location= > > does not even has to be in house. That other systems can con= nect > > to it as well is a life saver sometimes. > > > > Now when you start with stored procedures you have another > > story where your database does all the work for you and not > > the webserver anymore... > > > > I don't think this is a conversation of the scripting languag= e > > but more why to use SQL. > > > > Nitai > > This was a conversation about SMSI support that turned into (fa= lse) > statements about webdna that turned into SQL promotion (amongst= other > things). :-) I was > correcting wreckless false statements such as webdna db's not > being relationable, and more generally, the message that webdna= > is not a valid solution. Frankly, I'm a bit suprised that no ot= her > long-timers joined in. > > > I don't know when the conversation turned into promoting SQL, b= ut you > can count me in. I am not against using the right tool for the > job. But I think using SQL because its accepted or using SQL fo= r your > resume is just that.. using it for the resume. Though I have us= ed the SQL > tags in the very occassional soution, relational flat files > still are the best working solution for 97% of my clients (I do= mostly > eCommerce stuff). There is absolutely no downside to using them= .. The > times I do consider other options is when the customer wants to= connect > to a core inventory database or something.. or even when they a= re > thinking about connections in the future... > Flat files can migrate to most any platform.. so even if webdna= > dissappears, the data is just fine (well, webdna encrypted fiel= ds would > have to be parsed). > > I said that I think it's wreckless.. because end users (our cli= ents) may > watch this list. They are getting false ideas about webdna's ca= pabilities. > > Donovan > > -- > =3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do= =3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do > DONOVAN D. BROOKE EUCA Design Center > > <- Web Development (specializing in eCommerce),-> > <- Custom Paint, Labels, and Specialty Signage. -> > <- Home and Business Embellishment/Fabrication, -> > <- Glass Blowing, and Art Glass -> > > PH/FAX:> 1 (608) 835-2476 > Web:> http://www.egg.bz | http://www.euca.us > =3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do= =3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to digest@talk.smithmicro.com> > Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
nitai@computeroil.com
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
[append] problem (1997)
[addlineitems] (1997)
[WebDNA] Open Source CMS (2012)
Bug Report, maybe (1997)
add to cart within a page? (1997)
Annoying character on writefile... (2004)
more info on [setlineitems] (1997)
Problem with empty form-variables in [search] (1998)
new PurgeDatabase command? (was NT vs Mac) (1997)
Sendmail (1997)
send mail problem? (1997)
The Guru Speaks (1998)
Dynamic PDFs? (2004)
[WebDNA] Crashing Database (2011)
Error Lob.db records error message not name (1997)
Please help (2004)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
[WebDNA] Triggers (2016)
Why did this copyfile stop working? (2004)
Re:WebCatalog/WebMerchant III (1998)