Comments on: Gleeful Calamity http://michaeljswart.com/?p=340 Database Whisperer Mon, 06 Sep 2010 00:56:15 +0000 hourly 1 http://wordpress.org/?v=3.0.1 By: Michael J. Swart http://michaeljswart.com/?p=340&cpage=1#comment-2256 Michael J. Swart Fri, 05 Mar 2010 13:42:11 +0000 http://michaeljswart.com/?p=340#comment-2256 One more failure: show_statistics histogram + graphical display = useless lines and rectangles. One more failure:
show_statistics histogram + graphical display = useless lines and rectangles.

]]> By: Moussaka and Coffee at Three Kretans | loudlunch http://michaeljswart.com/?p=340&cpage=1#comment-1994 Moussaka and Coffee at Three Kretans | loudlunch Tue, 09 Feb 2010 01:40:22 +0000 http://michaeljswart.com/?p=340#comment-1994 [...] at work, and last Friday we decided to get in the car and try something different.  Local internet database celebrity Michael Swart had mentioned Three Kretans, a well-established Greek place on Frederick St east of Weber.  We got [...] [...] at work, and last Friday we decided to get in the car and try something different.  Local internet database celebrity Michael Swart had mentioned Three Kretans, a well-established Greek place on Frederick St east of Weber.  We got [...]

]]> By: Michael J. Swart http://michaeljswart.com/?p=340&cpage=1#comment-1655 Michael J. Swart Fri, 18 Dec 2009 20:21:44 +0000 http://michaeljswart.com/?p=340#comment-1655 Hey Richard, Short answer: I like multiple schemas inside dbs and have no problems with them. Long answer: Multiple schemas inside a database are just one way to collect tables into logical groupings. It's one extra level of granularity for this kind of logical grouping that currently looks like: server/instance/database/schema/table. What does using multiple schemas buy us? From a practical point of view, multiple schemas in a database allow admins to apply security settings and permissions at that granularity. I'm not sure of many other uses. But aside from that, it's easier on the brain for me and other developers if a database with 1000s of tables had that extra grouping layer. Two gotchas that make me want to give up the idea is that (1) developers would have to get used to the schema.table syntax which might negate any advantages and (2) refactoring an existing database would be very difficult and again, maybe not worth the effort. Hey Richard,

Short answer: I like multiple schemas inside dbs and have no problems with them.

Long answer:
Multiple schemas inside a database are just one way to collect tables into logical groupings. It’s one extra level of granularity for this kind of logical grouping that currently looks like: server/instance/database/schema/table.

What does using multiple schemas buy us? From a practical point of view, multiple schemas in a database allow admins to apply security settings and permissions at that granularity. I’m not sure of many other uses.

But aside from that, it’s easier on the brain for me and other developers if a database with 1000s of tables had that extra grouping layer. Two gotchas that make me want to give up the idea is that (1) developers would have to get used to the schema.table syntax which might negate any advantages and (2) refactoring an existing database would be very difficult and again, maybe not worth the effort.

]]> By: Richard Wallace http://michaeljswart.com/?p=340&cpage=1#comment-1652 Richard Wallace Fri, 18 Dec 2009 19:48:41 +0000 http://michaeljswart.com/?p=340#comment-1652 I gleened one random point from this... Should I assume that you are a proponent for multiple schemas in a database? I'm interested in that point. I gleened one random point from this… Should I assume that you are a proponent for multiple schemas in a database? I’m interested in that point.

]]> By: Michael J. Swart http://michaeljswart.com/?p=340&cpage=1#comment-1641 Michael J. Swart Wed, 16 Dec 2009 17:50:52 +0000 http://michaeljswart.com/?p=340#comment-1641 What you said Aaron, is *exactly* what I meant. Your comment is a one sentence summary of what I was trying to explain. What you said Aaron, is *exactly* what I meant. Your comment is a one sentence summary of what I was trying to explain.

]]> By: Aaron Bertrand http://michaeljswart.com/?p=340&cpage=1#comment-1639 Aaron Bertrand Wed, 16 Dec 2009 17:29:17 +0000 http://michaeljswart.com/?p=340#comment-1639 Great post Michael - while it is often disappointing when creativity leads to a dead end, I agree that the process is rewarding enough that I continue to do it... Great post Michael – while it is often disappointing when creativity leads to a dead end, I agree that the process is rewarding enough that I continue to do it…

]]>