re: Large databases in WebCat
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 14478
interpreted = N
texte = >How about this? Grant, could Webcat handle the likes of Sears(big), >Service Merchandise(medium), Circuit City or Lands End(small), complete >with a users/password database, shipping, etc?Let's break it into separate pieces: the product catalog vs. some kind of membership database. I don't think Sears has more than 100,000 products, and WebCatalog would have no trouble at all with that. Now if you want to track 50 million customers, that's another matter. For one thing, it really makes no sense, because Sears has so much legacy equipment and infrastructure that they would probably never put that on the web (if for security reasons alone)....But if you still wanted to do it, then using cookies would bring that into line quite well; store the customer's shipping address and other particulars in a cookie so the server itself never has to store it. Customers who are afraid of cookies will just have to re-type their particulars each time.I'd love the chance to tackle a Sears with WebCatalog, and that's not just idle boasting -- the requirements of a web site are so different from those of a traditional huge physical store that you have to re-think your basic assumptions. Some of those assumptions (like SQL is the only answer, and it has to be connected 'live' to the web) aren't always the solution. Sears used to print millions of paper catalogs that had a few thousand items in them, and those were never connected 'live' to the web either. WebCatalog can present those catalog items in a much more dynamic and refreshing way, and far faster than any traditional database system that has been back-hacked to the web can.Grant Hulbert, V.P. Engineering | ==== eCommerce for the Rest of Us ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
Associated Messages, from the most recent to the oldest:
>How about this? Grant, could Webcat handle the likes of Sears(big), >Service Merchandise(medium), Circuit City or Lands End(small), complete >with a users/password database, shipping, etc?Let's break it into separate pieces: the product catalog vs. some kind of membership database. I don't think Sears has more than 100,000 products, and WebCatalog would have no trouble at all with that. Now if you want to track 50 million customers, that's another matter. For one thing, it really makes no sense, because Sears has so much legacy equipment and infrastructure that they would probably never put that on the web (if for security reasons alone)....But if you still wanted to do it, then using cookies would bring that into line quite well; store the customer's shipping address and other particulars in a cookie so the server itself never has to store it. Customers who are afraid of cookies will just have to re-type their particulars each time.I'd love the chance to tackle a Sears with WebCatalog, and that's not just idle boasting -- the requirements of a web site are so different from those of a traditional huge physical store that you have to re-think your basic assumptions. Some of those assumptions (like SQL is the only answer, and it has to be connected 'live' to the web) aren't always the solution. Sears used to print millions of paper catalogs that had a few thousand items in them, and those were never connected 'live' to the web either. WebCatalog can present those catalog items in a much more dynamic and refreshing way, and far faster than any traditional database system that has been back-hacked to the web can.Grant Hulbert, V.P. Engineering | ==== eCommerce for the Rest of Us ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
Grant Hulbert
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:
Max Record length restated as maybe bug (1997)
Email Set-Up? (1997)
Sendmail Context (2003)
[OT] Test - THE ANSWER (2003)
Serial Number Question (1997)
2.01 upgrade problems (1997)
syntax question, not in online refernce (1997)
Single Link browsing (1997)
[WebDNA] Windows Share (2011)
RAM variables (1997)
international time (1997)
Stopping bad HTML propagation ? (1997)
WebCatalog 3.0.8 Mac OS (2000)
SSL and reg web* (1997)
extending webcatalog (1997)
vars (2000)
New public beta available (1997)
redirect with frames (1997)
WebDNA 5 - Function test weirdness or ? (2003)
[WebDNA] max in a search (2009)