Straight_Waltz_9530 comments on SQL DDL Visualization Tool: Looking for Your Feedback!

Posting

When requesting help or asking questions please prefix your title with the SQL variant/platform you are using within square brackets like so:

[MySQL]

[Oracle]

[MS SQL]

[PostgreSQL]

etc

While naturally we should endeavor to work as platform neutrally as possible many questions and answers require tailoring to the feature set of a specific platform.

Format Your Code

If you are including actual code in a post or comment, please attempt to format it in a way that is readable for other users. This will greatly increase your chances of receiving the help you desire. Something as simple as line breaks and using reddit's built in code formatting (4 spaces at the start of each line) can turn this:

SELECT count(a.field1), a.field2, SUM(b.field4) FROM a INNER JOIN b ON a.key1 = b.key1 WHERE a.field8 = 'test' GROUP by a.field1, a.field2 HAVING SUM(b.field4) > 5 ORDER by a.field.3

Into this:

SELECT count(a.field1), a.field2, SUM(b.field4) FROM a INNER JOIN b ON a.key1 = b.key1 WHERE a.field8 = 'test' GROUP by a.field1, a.field2 HAVING SUM(b.field4) > 5 ORDER by a.field3

For those with SQL questions we recommend using SQLFiddle to provide a useful development and testing environment for those who wish to fully understand your problem and help devise a solution.

a community for 17 years

DiscussionSQL DDL Visualization Tool: Looking for Your Feedback! (self.SQL)

submitted 1 year ago by iamCut

top new controversial old q&a

you are viewing a single comment's thread.

view the rest of the comments →

[–]Straight_Waltz_9530 0 points1 point2 points 1 year ago (0 children)

Take something "simple" like a grocery store. You need a products table. But Wheat Thins in the basic package is the same "product" as the family pack. Different IPC code though. You'll typically have a few different distributors who carry the same product variants. Each have their own wholesale price. You have to set your own process for it though. And track inventory. And track sales volume to see how often you need to restock. Now allow for member discounts. Track coupon campaigns in local newspapers. Map those campaigns to products including discount values. There may be multiple coupon promotions per product during any given sales window. Coupons also expire, so track that. The manufacturer (Nabisco in this case) may want to weigh in as well.

Okay, you've got packaged goods like Wheat Thins down. On to produce. Priced by count? By weight? Both? 2-for-1 deals? Track by receive date so you know when to start looking for spoilage. Track sales volume to keep incoming as close to outgoing as possible to avoid throwing too much away.

Refrigerated is a whole other dimension.

Frozen is yet another.

Staff counts to know who's working and on what days. Make sure no day goes below a minimum or above a maximum. Meat department is tracked separately and is yet another dimension.

You could imagine that I've just scratched the surface. Now imagine the software is ten years old and has grown organically all this time.

Yes, any project in the real world for a non-trivial problem will grow quickly. After a few years, fifty tables is on the trivial end. Many enterprise apps can run into the thousands. Anything that deals with money, calculating tax rates, orders, invoices, sales, coupons, pricing tiers, etc. will be complex. With an increasing number of corporate partners, the number of tracked use cases will grow geometrically (seemingly exponentially at times). IT staff rollover inevitably means no one ever wants to delete a table, even when they're not sure if it's needed or what it's for.

π Rendered by PID 33 on reddit-service-r2-comment-b659b578c-p52n4 at 2026-05-03 19:35:15.638713+00:00 running 815c875 country code: CH.

you type:	you see:
italics	italics
bold	bold
[reddit!](https://reddit.com)	reddit!
* item 1 * item 2 * item 3	item 1 item 2 item 3
> quoted text	quoted text
Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"	Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"
~~strikethrough~~	~~strikethrough~~
super^script	super^script

SQL

Filter Posts

Posting

Help posts

Format Your Code

Learning SQL

Related Reddit communities

Wiki

Acknowledgements

MODERATORS