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:

    
  1. Re: Db design question (relational vs. flat?) (Grant Hulbert 1998)
  2. Re: Db design question (relational vs. flat?) (Dale Stokdyk 1998)
  3. Re: Db design question (relational vs. flat?) (PCS Technical Support 1998)
  4. Db design question (relational vs. flat?) (Dale Stokdyk 1998)
>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 & Suse Linux (2004) How does WebCatalog search the database? (1997) WebCommerce Security Alert! (1996) More on the email templates (1997) OT - Want to trade? You get webcat code and/or graphics... I get *simple* javascript (2000) Sorting error (1997) Webcat 2.0.1 date math bug -> Crash! (1997) Validation (2000) [Webcat 2]Next (1997) [format xs] freeze (1997) Searchable list archive (1997) installing webcatalog problem. HELP! (1998) Caching [include] files ... (1997) OT: Woa MacWorld (2003) WebDNA emailer details (2005) %@#*& back button!!! (1999) Rumpus/Typhoon modules included in Typhoon ... (1997) [WebDNA] Query re: autonumber (2010) RE: WebCat and image maps (1997) RE: Credit card processing - UK (1997)