The Social Development Database

I’ve always been fascinated by development databases — more so sometimes than huge, heavily utilized production ones. Mainly because I’ve seen how the beginnings of a performance problem, or the start of an elegant solution takes shape within a development database. It’s one of the reasons why I love high levels of visibility through full DDL-auditing within development. I love to SEE what database developers are thinking, and how they are implementing their ideas using specific shapes of data structures.

One of the concepts I’d love to see is a “river of news” panel within development tools to see what is going on within a development database. Some of the good distributed source code control systems do this now.

Here’s a good example of what I mean:

http://github-images.s3.amazonaws.com/blog/2011/mac-screenshots/commits-full.png

Imagine if there was a panel in SQL*Developer or TOAD that looked something like this:

This wouldn’t be all that hard to implement if full DDL-auditing was turned on…

4 Responses to “The Social Development Database”

  1. Dominic Brooks Says:

    What a great idea!

  2. Gary Says:

    Not sure I like the ‘logged in’ alerts – too many.

    You should get badges for adding comments to columns and tables though. And earn a mayor-ship (mayoralty ?) for scheduling backups.

    You need to throw this out with a twitter hashtag :)

  3. Gwen Shapira Says:

    This may be the only way to convince DBAs to login with their own user and not “/ as sysdba”.

    I like it :)

  4. √ėyvind Isene Says:

    Cool! And an extra level for every 10th foreign keys, or flashing alerts for each new constraint.

Leave a Reply

Posting code can be a pain. To make sure your code doesn't get eaten, you may want to pre-format it first by using HTML Encoder