Dave’s Tech Blog

I’ve been working on an interface between two systems.

The interface has to watch system A and send transactions to system B. Normally, in the Oracle universe, there would be 2 ways to do this:

1. Use database triggers on System A’s tables to trigger transactions
2. Keep a separate record of the state of System A’s tables and compare it to the actual state - looking for differences which trigger transactions

The drawback with the first method is the performance hit of the database triggers on System A, as well as the possibility they might introduce errors into its processing.

The drawback with the second method is that replicating parts of the watched system is, well, just plain yucky.

Fortunately, in the case of this particular interface, System A uses a column called UPDATE_ON in its major tables. This column is updated whenever there is a change in the row. This means the interface just has to look for rows where UPDATE_ON is greater than when it last looked. It’s a much lighter touch than the other methods.

I encourage Data Architects everywhere to include an UPDATE_ON on their major tables in their designs - even if it’s usefulness isn’t immediately apparent.

For the sarcastic …

http://lmgtfy.com

Here’s an example of it in action:

http://www.lmgtfy.com/?q=let+me+google+that+for+you

Blackle is a front-end to Google search which aims to save energy by using a black background instead of the usual Google white.

Even though there is skepticism about the energy savings, it’s a good message.

On February 13, 2009 at 23:31:30 UTC, the Unix time number will reach 1234567890 seconds (since 1/1/70).

Reminds me of a few years back: 12:34:56 on 7/8/90.

On Linux you can type date +%s to see the “count-up”.

“Appnr is a web-based tool and a service that installs applications on Ubuntu. This is a web interface for APT, and the package is downloaded and installed from Ubuntu/Third-party repositories.”

You know, some people just have too much time in their hands. Good thing they use it to build cool things like ASCIIQuarium.

If you use Ubuntu I’ve packaged and uploaded it here. A package for the perl library that asciiquarium depends on is here.

In my (copious - I wish) spare time I contribute in minor and probably annoying ways to a project called INX which stands for “Is Not X” (and is pronounced ‘inks’). It’s a Linux distribution designed to teach the command-line and some of its tools in an easy and fun way.

Today it reached its version 1.0 release (click on this text to learn more).

Congratulations Peter!

http://cryopid.berlios.de/

Many many occasions in which this would have been so useful. Read the “Use Case Examples” on that page.

As described by the CLUGer who posted about it: “for that ’screen moment’ where you say to yourself ‘I wish I started this from inside a screen session’.”

http://ozlabs.org/~jk/docs/screen-x.php

http://blog.red-bean.com/sussman/?p=96