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:

For all you thinking about a switch to PHP (2003) Limitations on fields? Server is crashing (1997) Document Contains No Data msg (1997) [WebDNA] WordPress plugin (2020) [OT] WebCat Programmer Wanted (NJ) (1999) Nested Loops and SHOWIFs (1997) Which GUI HTML editors work with WC ? (1997) Redirect (2003) Two options to consider (2008) Running a store on BOTH http and https (1998) adding shipping cost (1998) WebCat2b15MacPlugin - [protect] (1997) [WebDNA] 30 Minute Cookies (2016) Help! WebCat2 bug (1997) Finding max value for a field (1997) [shownext max=?] armed (1997) Date Formats (1997) Re:No Data (1997) emailer and other smtp (1998) Fwd: [WebDNA] Fails to recognize comma-separated db (2010)