Re: Here we go again...WebDNA - SQL- Clustering
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 66733
interpreted = N
texte = 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 back > 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 you > 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 connect > 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 language > but more why to use SQL. > > Nitai This was a conversation about SMSI support that turned into (false) 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 other long-timers joined in. I don't know when the conversation turned into promoting SQL, but 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 for your resume is just that.. using it for the resume. Though I have used 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 are 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 fields would have to be parsed). I said that I think it's wreckless.. because end users (our clients) may watch this list. They are getting false ideas about webdna's capabilities. Donovan -- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o 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 =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o ------------------------------------------------------------- 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:
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 back > 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 you > 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 connect > 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 language > but more why to use SQL. > > Nitai This was a conversation about SMSI support that turned into (false) 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 other long-timers joined in. I don't know when the conversation turned into promoting SQL, but 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 for your resume is just that.. using it for the resume. Though I have used 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 are 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 fields would have to be parsed). I said that I think it's wreckless.. because end users (our clients) may watch this list. They are getting false ideas about webdna's capabilities. Donovan -- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o 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 =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o ------------------------------------------------------------- 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/
Donovan Brooke
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:
[WebDNA] add rows dynamically (2018)
Merry Christmas (2006)
Sendmail & Time Issue (2001)
FYI: virus alert (1996)
using showpage and showcart commands (1996)
WebCat on Linux (2000)
autosensing lanague selection (1997)
RE: Problem (1997)
Nested tags count question (1997)
A multi-processor savvy WebCatalog? (1997)
[WebDNA] [PROTECT] - Log Out (2011)
Field validation problem (1999)
[ShowIf] if the varieable exists (1998)
This [search] worked before update to 4.5.1 (2003)
Next X hits (1996)
Record size (1998)
Hosting Services (1999)
Problems with [Applescript] (1997)
List Archives (2000)
PCS search results page (1998)