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:

triggers.db (1999) Duplicate Cart ID (2001) Almost a there but..bye bye NetCloak (1997) Simple way to create unique SKU (1997) [WebDNA] Talklist Archive & Twitter (2009) Re:Comments Convertion-part2 (1998) Format of Required fields error message (1997) Don't tick me off :) [elaspedtime] (1997) [OT] XML Primer (2004) File Upload (2000) [WebDNA] Can't see were it's wrong.... (2017) [DOS]/DOS query - A SOLUTION (2003) RE: [WebDNA] Installing 6.0 onto Server 2008 (2011) Format date.... (2003) [WebDNA] Is this safe? (2013) placement of ? (2000) Re:Webmessage Hyperboard (1998) WebCat2 - Getting to the browser's username/password data (1997) [OT] Bad Hard Drive? (2003) [include ...] behavior (1997)