Re: Db design question (relational vs. flat?)
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 17070
interpreted = N
texte = >What if I stuff all the category names into the category field in my >catalog.txt instead of creating another db like category.db? Can you >help me understand pros and cons of one vs. the other?The downside of that is you can't easily create a popup or list or any other construct that would require breaking out every word as an individual item (that's why our admin pages can't display a list of Groups). The upside is that it's faster for searching, and in many ways easier to comprehend (and edit) because the words are just sitting there in a single field.There's nothing stopping you from doing both - create a category database whose purpose is to ease popup/list creation, but also have lists of words in a big field. The only problem would be someday getting the two out of synch, but I don't really know what your application is, so I don't know if that's a huge problem.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:
>What if I stuff all the category names into the category field in my >catalog.txt instead of creating another db like category.db? Can you >help me understand pros and cons of one vs. the other?The downside of that is you can't easily create a popup or list or any other construct that would require breaking out every word as an individual item (that's why our admin pages can't display a list of Groups). The upside is that it's faster for searching, and in many ways easier to comprehend (and edit) because the words are just sitting there in a single field.There's nothing stopping you from doing both - create a category database whose purpose is to ease popup/list creation, but also have lists of words in a big field. The only problem would be someday getting the two out of synch, but I don't really know what your application is, so I don't know if that's a huge problem.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:
[WebDNA] WebDNA and PHP cohabitating? (2009)
Formating Tables w/[founditems] (1998)
Possible Bug in 2.0b15.acgi (1997)
WebCat editing, SiteGuard & SiteEdit (1997)
Join us at MacWorld -- in the booth and after the show!!! (1999)
'does not contain' operator needed ... (1997)
Webcat 3.0.5b9, b8 trigger failures ON WEBSTAR (1999)
OT: P3P (was Shop from PDF) (2004)
[Announce]: Web server security and password protection (1997)
Re:trouble (1997)
Paths, relative paths, webstar server setup and security (1997)
Need relative path explanation (1997)
PCS Frames (1997)
textA (1998)
ReturnRaw context (1997)
Server slowing down. (1997)
Dates - Search and Sorting (1999)
Date stamp and purging (1998)
Sendmail problem (2002)
WebCat3.04/w*4/OS8.5.1 and aliases (1999)