RSS Feed

a playground of art, photos, videos, writing, music, life

 


You are here







Random Quote

One of the least impressive liberties is the liberty to starve. This particular liberty is freely accorded to authors.
-- Lord Goodman


 

Blog - Blog Archive by Month - Blog Archive by Tag - Search Blog and Comments

<-- Go to Previous Page

Under Construction

 

I've been building the retail web site, going along and thinking it through. As I've been noodling it through, I've grown increasingly uneasy with my original database schema. Started to look more like spaghetti than intelligent design.

One of my favorite development tools is Microsoft Word's outline view. You can access it by going to "View/Outline" in the menu. Here, you can create a quick and easily editable outline for your thoughts. There's a custom toolbar that comes with this view. Be sure to toggle off "Show Formatting" in the toolbar. The default is a bunch of funky text and frankly it boggles my mind why those font choices are the default...

Databases work best when they model real life relationships and attributes. Which seems obvious on its face, but here's where it becomes a matter of how you view things. Where do you associate, for example, the discount? Obviously, it's associated at the time of ordering. But is it on an item level or on the order level?

After a lot of twisting and turning about it, here's my outline:

And so with that, I'll be undoing and redoing some of my work on the web site.

Interesting puzzles, these are...

 


by Brett Rogers, 1/15/2006 10:58:10 AM
Permalink


Comments

What do you mean that you are uneasy about the "original database schema"???? We are going places with this ... I hope it's okay...

 

 

Posted by guess who, 1/17/2006 3:54:57 PM


I was uneasy with the database schema for order processing at the ArtByBrett site. There's a lot to consider. I plan to offer quantity discounts and bundled discounts/bargains.

After more thinking about it, I've discerned that Iwas closer than I thought I was. After all, I'm not creating a generic shopping cart to resell to others; simply one to manage my needs.

So I think I've got what I need for a model. Next, more programming...

 

 

Posted by Brett Rogers (http://www.beatcanvas.com), 1/17/2006 7:58:29 PM


Whew - I thought it was the data schema for OSOT. ;)

BTW - if I don't answer your question below I get a blank screen and my comment doesn't get saved....you need to talk to your blog developer to get that fixed.

 

 

Posted by Anonymous, 1/18/2006 1:24:58 PM


My web developer complains that he makes too little to make it worth his while to fix. But I'll see if I can stoke him into action!

 

 

Posted by Brett Rogers (http://www.beatcanvas.com), 1/18/2006 2:08:33 PM


I've discovered who the mystery poster is! And welcome aboard :)

OSOT is safe, don't you worry. (OSOT is an acronym for "One Source of Truth," the huge summer project for Wells that I built and on which I continue to work.)

I've fixed the blank page problem and it now gives a nice big red warning that your comment didn't go as planned. Thanks for the great feedback!

 

 

Posted by Brett Rogers (http://www.beatcanvas.com), 1/18/2006 8:27:44 PM



Add Your Comment:
Name (required):
Web Site:
Remember Me:   
Content: (4000 chars remaining)
To prevent spammers from commenting, please give a one-word answer to the following trivia question:

What's the first name of the tiger who pitches Frosted Flakes?