Re: Here we go again...

This WebDNA talk-list message is from

2006


It keeps the original formatting.
numero = 66692
interpreted = N
texte = Does tabbed text make you feel like its somehow less secure? On Apr 3, 2006, at 3:01 PM, Bess Ho wrote: > Yes that is what I am saying. Tab-delimited text files... It really > makes many non-webdna developers "wonder". > > -----Original Message----- > From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of > Dan Strong > Sent: Saturday, April 01, 2006 10:02 AM > To: WebDNA Talk > Subject: Re: Here we go again... > > > I've also never used any flavor of SQL, but I've dabbled with > Access -- to the point where I > realized I could do everything I was trying to do in WebDNA in > about 1/4 the time :)... yeah, I've > tried to explain to non-webdna developers that I simply use tab- > delimted text files to do my thing > and they just stare at me blankly... it's sort of funny to me now. > -Dan > > > On Sat, 1 Apr 2006 08:42:44 -0600 > Pat McCormick wrote: >> Actually WebDNA doesn't use a flat file. That is the case for >> the older Typhoon version, but >> WebDNA, simply because it can have multiple databases open, is no >> longer a flat file system. >> >> The difference is that WebDNA doesn't formalize the structure of a >> db in any way. You are >> responsible for define a sku or key field and there are some nice >> tools to assist the process, >> like [cart]. Comparing that with SQL or Access, those products >> get more antsy about key fields, >> and field formats in general. They also enforce the idea of a >> database consisting of a >> collection of tables, which is also confusing nonsense. >> >> The purpose for products like Oracle, SQL and other "databases" is >> to encrypt your text so that >> you need to buy their products to see your text. Web-DNA is the >> un-database database. Create >> your own relationships. All key fields are optional. Structure >> your project any way you want, >> even using virtual databases ([table]), and to make it even >> better, keep all the data in plain >> text so you can x-ray the files at any time using any text tool. >> Ya gotta love that! >> >> >> >> >> >> >> On Mar 31, 2006, at 2:12 PM, Bess Ho wrote: >> >>> WebDNA is using flat file for storing data. It is not a >>> relationship database like MySQL. Also once your flat file grow >>> beyond roughly 2 GB (check with Network Admin to verify the size), >>> you can't run data very well. The go-around solution is to break >>> down WebDNA database into smaller chunks for faster performance. >>> You really need Relationship Database for scaleable application. >>> >>> -----Original Message----- >>> From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On >>> Behalf Of >>> Kenneth Grome >>> Sent: Friday, March 31, 2006 4:55 AM >>> To: WebDNA Talk >>> Subject: Re: Here we go again... >>> >>> >>> On Fri, 31 Mar 2006 07:05:55 -0500, Terry Wilson wrote: >>>> ... you never know when you'll be required to start doing >>>> something a >>>> certain way; or at some point, an old solution just isn't good >>>> enough >>>> or fast enough any longer ... >>> >>> >>> Example: >>> >>> A client of mine preferred webdna but his searches were too slow, >>> so he hired me to debug and fix them. His code was fine but the >>> database files were not configured to optimize webdna's >>> performance, so I could only recommend two options: (1) >>> reconfigure the databases (not a good solution because updated data >>> files came from another source frequently) ... or (2) switch to >>> MySQL and give that a try ... >>> >>> I really didn't know if MySQL could handle the task any faster than >>> webdna and I told him this, but he went for it anyways. He said >>> webdna hosting cost too much anyways, and since he wasn't committed >>> to using it on his server anyways (although he enjoyed personally >>> mocking up web sites because it's east for a non-programmer to use) >>> he decided to go with PHP and MySQL. >>> >>> The moment we switched his search times dropped from about 10 >>> seconds to less than two seconds. I think the reason is two-fold: >>> (1) he had database files that were too large for webdna to RAM- >>> cache efficiently, and (2) we were doing nested searches, and >>> webdna is pretty slow sometimes when using nested searches, >>> especially with large db files. >>> >>> The bottom line is that he "outgrew" webdna for use on his server, >>> and now he's happy again with a faster free solution. I think this >>> type of situation is going to become more and more common as webdna >>> continues to be less and less aggressively developed, supported and >>> marketed. >>> >>> Sincerely, >>> Kenneth Grome >>> >>> owner@kengrome.com >>> kengrome@gmail.com >>> www.kengrome.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 >> 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 >> 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 > 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 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 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:

    
  1. Re: Here we go again... ( "Bess Ho" 2006)
  2. Re: Here we go again... ( Kenneth Grome 2006)
  3. Re: Here we go again... ( "sal danna" 2006)
  4. Re: Here we go again... ( "Bess Ho" 2006)
  5. Re: Here we go again... ( Kenneth Grome 2006)
  6. Re: Here we go again... ( "Bess Ho" 2006)
  7. Re: Here we go again...WebDNA - SQL- Clustering ( Kenneth Grome 2006)
  8. Re: Here we go again...WebDNA - SQL- Clustering ( "Bess Ho" 2006)
  9. Re: Here we go again...WebDNA - SQL- Clustering ( Donovan Brooke 2006)
  10. Re: Here we go again...WebDNA - SQL- Clustering ( "Bess Ho" 2006)
  11. Re: Here we go again...WebDNA - SQL- Clustering ( "Bess Ho" 2006)
  12. Re: Here we go again...WebDNA - SQL- Clustering ( Alex McCombie 2006)
  13. Re: Here we go again...WebDNA - SQL- Stored Procedures ( Alex McCombie 2006)
  14. Re: Here we go again...WebDNA - SQL- Clustering ( Donovan Brooke 2006)
  15. Re: Here we go again...WebDNA - SQL- Clustering ( Donovan Brooke 2006)
  16. Re: Here we go again...WebDNA - SQL- Clustering ( Adam O'Connor 2006)
  17. Re: Here we go again...WebDNA - SQL- Clustering ( nitai@computeroil.com 2006)
  18. Re: Here we go again...WebDNA - SQL- Clustering ( Donovan Brooke 2006)
  19. Re: Here we go again...WebDNA - SQL- Clustering ( Alex McCombie 2006)
  20. Re: Here we go again...WebDNA - SQL- Stored Procedures ( Adam O'Connor 2006)
  21. Re: Here we go again...WebDNA - SQL- Clustering ( nitai@computeroil.com 2006)
  22. Re: Here we go again... ( nitai@computeroil.com 2006)
  23. Re: Here we go again... ( Kenneth Grome 2006)
  24. Re: Here we go again...WebDNA - SQL- Clustering ( Donovan Brooke 2006)
  25. Re: Here we go again... ( Donovan Brooke 2006)
  26. Re: Here we go again...WebDNA - SQL- Clustering ( Alex McCombie 2006)
  27. Re: Here we go again... ( Kenneth Grome 2006)
  28. Re: Here we go again...WebDNA - SQL- Clustering ( Bob Minor 2006)
  29. Re: Here we go again... ( "Bess Ho" 2006)
  30. Re: Here we go again... ( "Bess Ho" 2006)
  31. Re: Here we go again... ( Donovan Brooke 2006)
  32. Re: Here we go again...WebDNA - SQL- Clustering ( Stuart Tremain 2006)
  33. Re: Here we go again...WebDNA - SQL- Clustering ( Adam O'Connor 2006)
  34. Re: Here we go again... ( "Bess Ho" 2006)
  35. Re: Here we go again... ( Adam O'Connor 2006)
  36. Re: Here we go again... ( Adam O'Connor 2006)
  37. Re: Here we go again... ( Marc Thompson 2006)
  38. Re: Here we go again... ( "Bess Ho" 2006)
  39. Re: Here we go again... ( "Bess Ho" 2006)
  40. Re: Here we go again... ( Donovan Brooke 2006)
  41. Re: Here we go again... ( Adam O'Connor 2006)
  42. Re: Here we go again... ( "Bess Ho" 2006)
  43. Re: Here we go again... ( "Bess Ho" 2006)
  44. Re: Here we go again... ( Pat McCormick 2006)
  45. Re: Here we go again... ( Pat McCormick 2006)
  46. Re: Here we go again... ( "Bess Ho" 2006)
  47. Re: Here we go again... ( "Bess Ho" 2006)
  48. Re: Here we go again... ( Pat McCormick 2006)
  49. Re: Here we go again... ( Chris 2006)
  50. Re: Here we go again... ( Terry Wilson 2006)
  51. Re: Here we go again... ( Donovan Brooke 2006)
  52. Re: Here we go again... ( Donovan Brooke 2006)
  53. Re: Here we go again... ( Adam O'Connor 2006)
  54. Re: Here we go again... ( Kenneth Grome 2006)
  55. Re: Here we go again... ( Kenneth Grome 2006)
  56. Re: Here we go again... ( "Dan Strong" 2006)
  57. Re: Here we go again... ( "Dan Strong" 2006)
  58. Re: Here we go again... ( Donovan Brooke 2006)
  59. Re: Here we go again... ( Adam O'Connor 2006)
  60. Re: Here we go again... ( Donovan Brooke 2006)
  61. Re: Here we go again... ( Pat McCormick 2006)
  62. Re: Here we go again... was: DDEConnect not working ( Robie Blair 2006)
  63. Re: Here we go again... ( "Bess Ho" 2006)
  64. Re: Here we go again... ( Kenneth Grome 2006)
  65. Re: Here we go again... ( Terry Wilson 2006)
  66. Re: Here we go again... ( Larry Hewitt 2006)
  67. Re: Here we go again... ( Phil Herring 2006)
  68. Re: Here we go again... ( Jesse Proudman 2006)
  69. Re: Here we go again... ( Stuart Tremain 2006)
  70. Re: Here we go again... ( Jesse Proudman 2006)
  71. Re: Here we go again... ( Stuart Tremain 2006)
  72. Re: Here we go again... ( Jesse Proudman 2006)
  73. Re: Here we go again... ( "Dan Strong" 2006)
  74. Re: Here we go again... ( Jesse Proudman 2006)
  75. Re: Here we go again... ( "Dan Strong" 2006)
  76. Re: Here we go again... ( Stuart Tremain 2006)
  77. Re: Here we go again... was: DDEConnect not working ( Chris 2006)
  78. Re: Here we go again... was: DDEConnect not working ( Kenneth Grome 2006)
  79. Re: Here we go again... was: DDEConnect not working ( Chris 2006)
  80. Re: Here we go again... was: DDEConnect not working ( Kenneth Grome 2006)
  81. Re: Here we go again... was: DDEConnect not working ( Chris 2006)
  82. Re: Here we go again... was: DDEConnect not working ( Kenneth Grome 2006)
  83. Re: Here we go again... ( Donovan Brooke 2006)
  84. Re: Here we go again... was: DDEConnect not working ( Chris 2006)
  85. Re: Here we go again... ( Terry Wilson 2006)
  86. Re: Here we go again... was: DDEConnect not working ( Kenneth Grome 2006)
  87. Re: Here we go again... was: DDEConnect not working ( Stuart Tremain 2006)
  88. Re: Here we go again... was: DDEConnect not working ( "Dan Strong" 2006)
  89. Re: Here we go again... was: DDEConnect not working ( Stuart Tremain 2006)
  90. Re: Here we go again... was: DDEConnect not working ( Jay Van Vark 2006)
  91. Re: Here we go again... was: DDEConnect not working ( Stuart Tremain 2006)
  92. Re: Here we go again... was: DDEConnect not working ( "Bess Ho" 2006)
  93. Re: Here we go again... was: DDEConnect not working ( Gary Krockover 2006)
  94. Here we go again... was: DDEConnect not working ( "Dan Strong" 2006)
Does tabbed text make you feel like its somehow less secure? On Apr 3, 2006, at 3:01 PM, Bess Ho wrote: > Yes that is what I am saying. Tab-delimited text files... It really > makes many non-webdna developers "wonder". > > -----Original Message----- > From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of > Dan Strong > Sent: Saturday, April 01, 2006 10:02 AM > To: WebDNA Talk > Subject: Re: Here we go again... > > > I've also never used any flavor of SQL, but I've dabbled with > Access -- to the point where I > realized I could do everything I was trying to do in WebDNA in > about 1/4 the time :)... yeah, I've > tried to explain to non-webdna developers that I simply use tab- > delimted text files to do my thing > and they just stare at me blankly... it's sort of funny to me now. > -Dan > > > On Sat, 1 Apr 2006 08:42:44 -0600 > Pat McCormick wrote: >> Actually WebDNA doesn't use a flat file. That is the case for >> the older Typhoon version, but >> WebDNA, simply because it can have multiple databases open, is no >> longer a flat file system. >> >> The difference is that WebDNA doesn't formalize the structure of a >> db in any way. You are >> responsible for define a sku or key field and there are some nice >> tools to assist the process, >> like [cart]. Comparing that with SQL or Access, those products >> get more antsy about key fields, >> and field formats in general. They also enforce the idea of a >> database consisting of a >> collection of tables, which is also confusing nonsense. >> >> The purpose for products like Oracle, SQL and other "databases" is >> to encrypt your text so that >> you need to buy their products to see your text. Web-DNA is the >> un-database database. Create >> your own relationships. All key fields are optional. Structure >> your project any way you want, >> even using virtual databases ([table]), and to make it even >> better, keep all the data in plain >> text so you can x-ray the files at any time using any text tool. >> Ya gotta love that! >> >> >> >> >> >> >> On Mar 31, 2006, at 2:12 PM, Bess Ho wrote: >> >>> WebDNA is using flat file for storing data. It is not a >>> relationship database like MySQL. Also once your flat file grow >>> beyond roughly 2 GB (check with Network Admin to verify the size), >>> you can't run data very well. The go-around solution is to break >>> down WebDNA database into smaller chunks for faster performance. >>> You really need Relationship Database for scaleable application. >>> >>> -----Original Message----- >>> From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On >>> Behalf Of >>> Kenneth Grome >>> Sent: Friday, March 31, 2006 4:55 AM >>> To: WebDNA Talk >>> Subject: Re: Here we go again... >>> >>> >>> On Fri, 31 Mar 2006 07:05:55 -0500, Terry Wilson wrote: >>>> ... you never know when you'll be required to start doing >>>> something a >>>> certain way; or at some point, an old solution just isn't good >>>> enough >>>> or fast enough any longer ... >>> >>> >>> Example: >>> >>> A client of mine preferred webdna but his searches were too slow, >>> so he hired me to debug and fix them. His code was fine but the >>> database files were not configured to optimize webdna's >>> performance, so I could only recommend two options: (1) >>> reconfigure the databases (not a good solution because updated data >>> files came from another source frequently) ... or (2) switch to >>> MySQL and give that a try ... >>> >>> I really didn't know if MySQL could handle the task any faster than >>> webdna and I told him this, but he went for it anyways. He said >>> webdna hosting cost too much anyways, and since he wasn't committed >>> to using it on his server anyways (although he enjoyed personally >>> mocking up web sites because it's east for a non-programmer to use) >>> he decided to go with PHP and MySQL. >>> >>> The moment we switched his search times dropped from about 10 >>> seconds to less than two seconds. I think the reason is two-fold: >>> (1) he had database files that were too large for webdna to RAM- >>> cache efficiently, and (2) we were doing nested searches, and >>> webdna is pretty slow sometimes when using nested searches, >>> especially with large db files. >>> >>> The bottom line is that he "outgrew" webdna for use on his server, >>> and now he's happy again with a faster free solution. I think this >>> type of situation is going to become more and more common as webdna >>> continues to be less and less aggressively developed, supported and >>> marketed. >>> >>> Sincerely, >>> Kenneth Grome >>> >>> owner@kengrome.com >>> kengrome@gmail.com >>> www.kengrome.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 >> 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 >> 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 > 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 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 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/ Pat McCormick

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:

New Web Site Developers Database (1996) Re2: Calculating multiple shipping... (1997) Somewhat OT: IE issues (2002) Webcatalog 4.0 - Storebuilder (2000) Invisible file issue now a real 'bug' (1999) Online SQL Resources (2001) WebCatalog for guestbook ? (1997) WebCat2b13MacPlugin - nested [xxx] contexts (1997) [sendmail] and [formvariables] (1997) 2.0 Info (1997) webcat feature request (1997) WebCatalog can't find database (1997) HTML authentication HTML page (1999) Content Management + License (2005) List Address Changed! (1998) [WebDNA] v7.x [thisurl] (2010) [WebDNA] [OT] htaccess question (2017) Still Stumped on ShowNext...HELP! (1997) Carts & cookies (1999) Alternating colors (1997)