Re: Here we go again...
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 66695
interpreted = N
texte = You can access tab/comma delimited data from other platforms, but can be tricky. For me its easier to use a RDBMS. I have worked on projects before where system software and web-based software both shared the same data source - this would be tricky if the data source would have been delimited data.Haven't thought of this before but can webdna utilize web services? So if I have a .net server dishing out XML packets via SOAP/XML-RPC, can webdna receive these packets and parse them? I know webdna can parse xml, obviously, but can it interact with a web service? Perhaps it may simple, never tried with webdna.Here's an example, I once had to grab data from an in-house db, MSSQL, but the company would not allow web pages to be served from their location/systems. But, they would allow web services, so I built a web service via C# on their server, then used NUSOAP transmit the data and parse into my php based web page.Bess Ho wrote:> Can you use WebDNA database outside WebDNA folder?> Are you required to use WebDNA to interect with WebDNA database?> How do you see the database relationship?>> Bess> -----Original Message-----> From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of> Pat McCormick> Sent: Saturday, April 01, 2006 6:43 AM> To: WebDNA Talk> Subject: Re: Here we go again...>>> 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 > 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/> -------------------------------------------------------------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:
You can access tab/comma delimited data from other platforms, but can be tricky. For me its easier to use a RDBMS. I have worked on projects before where system software and web-based software both shared the same data source - this would be tricky if the data source would have been delimited data.Haven't thought of this before but can webdna utilize web services? So if I have a .net server dishing out XML packets via SOAP/XML-RPC, can webdna receive these packets and parse them? I know webdna can parse xml, obviously, but can it interact with a web service? Perhaps it may simple, never tried with webdna.Here's an example, I once had to grab data from an in-house db, MSSQL, but the company would not allow web pages to be served from their location/systems. But, they would allow web services, so I built a web service via C# on their server, then used NUSOAP transmit the data and parse into my php based web page.Bess Ho wrote:> Can you use WebDNA database outside WebDNA folder?> Are you required to use WebDNA to interect with WebDNA database?> How do you see the database relationship?>> Bess> -----Original Message-----> From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of> Pat McCormick> Sent: Saturday, April 01, 2006 6:43 AM> To: WebDNA Talk> Subject: Re: Here we go again...>>> 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 > 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/> -------------------------------------------------------------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/
Adam O'Connor
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:
I'm having trouble using [url][interpret][math] together in lookup (1997)
[append] and SSL (1997)
Setting up shop (1997)
shipping costs (1998)
no shopping cart (2000)
Searching multiple fields from one form field (1997)
WebCat2b12plugin - [search] is broken ... not! (1997)
WebCatalog Use Question (1997)
RAW=T..Strange behaviour (2000)
IIS Brain Dead (1998)
possible, WebCat2.0 and checkboxes-restated (1997)
Greeting Card System (2000)
no template caching (1997)
Folder Follies (1998)
Unexpected error (1997)
Re1000001: Setting up shop (1997)
[ShowNext] feature in 2.0 (1997)
[OT] - simple JS question (2004)
hiding return characters (2000)
using showpage and showcart commands (1996)