Tag Your Database - A Data Dictionary Tool

by brunofig 29. September 2006 18:38

 

Phil wrote:

A few days back Jon Galloway and I were discussing a task he was working on to document a database for a client.  He had planned to use some code generation to initially populate a spreadsheet and would fill in the details by hand.  I suggested he store the data with the schema using SQL extended properties.

We looked around and found some stored procs for pulling properties out, but no useful applications for putting them in there in a nice, quick, and easy manner.

A few days later, the freaking guy releases this Database Dictionary Creator, a nice GUI tool to document your database, storing the documentation as part of your database schema.

Database Dictionary Entry Form

The tool allows you to add your own custom properties to track, which then get displayed in the data dictionary form grid as seen above. Audit and Source are custom properties. It is a way to tag our database schema.

You ask the guy to build a house with playing cards and he comes back with the Taj Mahal.

Check it out.

 

[Via Tag Your Database - A Data Dictionary Tool]

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: ,

Reflection and Shadows with javascript using mootools and efxFactory

by brunofig 29. September 2006 07:58

After converting the reflection effect from script.aculo.us to mootools, i found myself needing also to create simple shadows for images. So I compiled the reflection sample, added the shadow effect and created the efxFactory. This is still under development so it's BETA and a preview of what will be a final version of mootools extensions to the Fx library.

By simply using the efxFactory.shadow($("thumbShadow1")); to create shadows or efxFactory.reflect($("thumbRefect2"), {opacity:1/6}); to create reflections, you can add simple effects to images without using a image editor. Usefull for content management systems.

Currently rated 4.0 by 1 people

  • Currently 4/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: , ,

Round Corners using Transcorners and mootools

by brunofig 29. September 2006 00:54

The people at Inviz created a system that allows "put" round corners on your content.

Download, demo and how to use here.

This system uses mooTools as support library.

Currently rated 2.3 by 3 people

  • Currently 2.333333/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: ,

Fix for the IE6 background image flicker bug

by brunofig 26. September 2006 23:16

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags:

BlogEngine.NET

...and more: The Futurama, South Park, Family Guy and American Dad Episodes

by brunofig 26. September 2006 22:05

From the guys how brought the Simpsons Episodes, you can now watch all these great series online at Daily Episodes.

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags:

BlogEngine.NET

Every Simpson's episode

by brunofig 26. September 2006 22:02

I just love the simpsons, and if you missed any "YOU SHOULD ROTTEN IN HELL!!!"..ops,..not this I wanted to say..sorry, if you missed any episode you can view it here.

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags:

BlogEngine.NET

Lightweight Invisible CAPTCHA Validator Control

by brunofig 26. September 2006 21:50

Source: http://www.dpchallenge.com/image.php?IMAGE_ID=138743

Phil Haack wrote:

Not too long ago I wrote about using heuristics to fight comment spam.  A little later I pointed to the NoBot control as an independent implementation of the ideas I mentioned using Atlas.

I think that control is a great start, but it does suffer from a few minor issues that prevent me from using it immediately.

  1. It requires Atlas and Atlas is pretty heavyweight.
  2. Atlas is pre-release right now.
  3. We’re waiting on a bug fix in Atlas to be implemented.
  4. It is not accessible as it doesn’t work if javascript is enabled.

Let me elaborate on the first point.  In order to get the NoBot control working, a developer needs to add a reference to two separate assemblies, Atlas and the Atlas Control Toolkit, as well as make a few changes to Web.config.  Some developers will simply want a control they can simply drop in their project and start using right away.

I wanted a control that meets the following requirements.

  1. Easy to use. Only one assembly to reference.
  2. Is invisible.
  3. Works when javascript is disabled.

The result is the InvisibleCaptcha control which is a validation control (inherits from BaseValidator)so it can be used just like any other validator, only this validator is invisible and should not have the ControlToValidate property set.  The way it works is that it renders some javascript to perform a really simple calculation and write the answer into a hidden text field using javascript.

What!  Javascript?  What about accessibility!? Calm down now, I’ll get to that.

When the user submits the form, we take the submitted value from the hidden form field, combine it with a secret salt value, and then hash the whole thing together.  We then compare this value with the hash of the expected answer, which is stored in a hidden form field base64 encoded.

The whole idea is that most comment bots currently don’t have the ability to evaluate javascript and thus will not be able to submit the form correctly.  Users with javascript enabled browsers have nothing to worry about.

So what happens if javascript is disabled?

If javascript is disabled, then we render out the question as text alongside a visible text field, thus giving users reading your site via non-javascript browsers (think Lynx or those text-to-speech browsers for the blind) a chance to comment.

Accessible version of the Invisible CAPTCHA control

This should be sufficient to block a lot of comment spam.

Quick Aside: As Atwood tells me, the idea that CAPTCHA has to be really strong is a big fallacy.  His blog simply asks you to type in orange every time and it blocks 99.9% of his comment spam.

I agree with Jeff on this point when it comes to websites and blogs with small audiences. Websites and blogs tend to implement different CAPTCHA systems from one to another and beating each one brings diminishing margins of returns.

However, for a site with a huge audience like Yahoo! or Hotmail, I think strong CAPTCHA is absolutely necessary as it is a central place for spammers to target.  (By the way, remind me to write a bot to post comment spam on Jeff’s blog)

If you do not care for accessibility, you can turn off the rendered form so that only javascript enabled browsers can post comments by setting the Accessible property to false.

I developed this control as part of the Subtext.Web.Control.dll assembly which is part of the Subtext project, thus you can grab this assembly from our Subversion repository.

To make things easier, I am also providing a link to a zip file that contains the assembly as well as the source code for the control. You can choose to either reference the assembly in order to get started right away, or choose to add the source code file and the javascript file (make sure to mark it as an embedded resource) to your own project.

Please not that if you add this control to your own assembly, you will need to add the following assembly level WebResource attribute in order to get the web resource handler working.

[assembly: WebResource("YourNameSpace.InvisibleCaptcha.js",     "text/javascript")]

You will also need to find the call to Page.ClientScript.GetWebResourceUrl inside InvisibleCaptcha.cs and change it to match the namespace specified in the WebResource attribute.

If you look at the code, you’ll notice I make use of several hidden input fields. I didn’t use ViewState for values the control absolutely needs to work because Subtext disables ViewState.  Likewise, I could have chosen to use ControlState, but that can also be disabled.  I took the most defensive route.

[Download InvisibleCaptcha here].

[Via Lightweight Invisible CAPTCHA Validator Control]

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags:

As musicas de antigamente!

by brunofig 26. September 2006 21:47

Não sei como se dizia que as músicas de hoje em dia é que são... como dizer... indecentes. Apesar de cada vez mais haver meninas roliças a abanar o belo do pacote em video clips (e não só), as letras não mudaram assim tanto.

Tomem o exemplo dos Queen. Hoje dei por mim a ouvir uma música cujo título é “I want it all” ou algo do género. A parte da letra que me recorda mais é “I want it all... i want it all… and I want it now”. Ora meus amigos, isto traduzido para português não é nada mais que “Eu quero-o todo… eu quero-o todo… e eu quero-o agora.”.

Agora expliquem-me isto... A mim ninguém me tira da cabeça que aquele ícone abixanado da música que foi o Freddy Mercury queria-o de facto todo... e entenda-se por todo... bem... usem a vossa imaginação.

Já agora... felicidades ao senhora da mala e ao seu colega que queria uma mala com força... e conseguiu!

[Via As músicas de antigamente!]

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags:

BlogEngine.NET

Wallpapers

by brunofig 26. September 2006 02:38

Awsum wallpapers from mandolux.

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags:

BlogEngine.NET

Javascript: Event Handling vs Event Delegation

by brunofig 26. September 2006 02:13

Chris Heilmann at Wait till I come! as wrote a nice article about event handling versus event delegation. The sample uses the Y!UI library.

You can read more here.

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags:

Optimus Mini Three Keyboard Video

by brunofig 26. September 2006 01:57

While the Optimus keyboard isn't out, the people at artlebedev have the Optimus Mini Three Keyboard as a teaser. The people at Gizmodo have a showoff video of this really cool gadget. Can't wait for the keyboard :) .

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags:

BlogEngine.NET

Mais um grande senhor

by brunofig 26. September 2006 01:47

Para fazer concorrência ao Bruno Nogueira e ao Robin Williams, aqui está mais um grande senhor da stand up comedy, Chris Rock.

Uma, duas, três, quatro, cinco, seis, sete, oito partes para rir a bom rir.

Ou então o simplesmente divinal Vida de casado.
(Homens, aprendam! Mulheres, digam lá que não é verdade?)

Um must.

[Via ~ A Aventura das Missangas ~]

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags:

BlogEngine.NET

The relality of a relationship by Chris Rock

by brunofig 26. September 2006 01:41

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags:

BlogEngine.NET

A Dream came true...

by brunofig 26. September 2006 00:20

It seems like some one is just driving an airplane. The reality is that some one is driving an airplane model from the ground using video googles and a webcam on the airplane model. Sweet...

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags:

BlogEngine.NET

Yahoo! UI Extensions Library Release .32

by brunofig 26. September 2006 00:10

Jack as released a new version of is awsum library extension for the Y!UI. One of the improvements is the new event system for the grid control.

A sample can be found here.

You can download version .32 here.

You can read more about this from Jack himself here.

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags:

Powered by BlogEngine.NET 1.4.5.7
Theme by Mads Kristensen

About the author

Hi!

My name is Bruno and I'am a senior consultant. When I'm not working, you can catch me playing with my daugther, taking photos and hanging out with my wife and friends. :)

You can also check my dark side or have fun with my vision of the world.

View Bruno Figueiredo's profile on LinkedIn

TwitterCounter for @brunoshine

Ads

    Page List

      Most comments

      ricos ricos
      1 comments
      be Belgium
      Root Server Root Server
      1 comments
      de Germany
      steph steph
      1 comments
      sg Singapore

      RecentComments

      Comment RSS

      Now Reading

      Professional WCF Programming: .NET Development with the Windows Communication Foundation (Programmer to Programmer) by Scott Klein
      Professional Windows Workflow Foundation by Todd Kitta

      Popuri.us

      My Popularity (by popuri.us)