Xaprb

Stay curious!

Archive for October, 2008

I unsubscribed from the Planet MySQL feed

with 15 comments

Now why would I do that, especially when my blog is syndicated through it?

Simple. I’m always trying to cut back on RSS and other “stuff.” Less is more. But don’t worry — I subscribed again. Only this time, I subscribed to my own filtered version of it! I built it via Yahoo! Pipes. And I made it public, so you can subscribe to it too.

Read the rest of this entry »

Written by Xaprb

October 30th, 2008 at 6:39 pm

Posted in SQL, World Wide Web

Tagged with , , ,

The power of a good SQL naming convention

with 13 comments

At my previous employer, one of the early decisions that had huge payoffs later was the SQL naming conventions. A good naming convention is more than just a nicety. It lets you write programs that don’t need to be told about the relationships among tables and columns.

There are many ways to do this, I think. But in practice, I think I’ve seen only a few customer systems that have a completely consistent, logical naming convention. And there are levels of convenience; some systems have a couple extra rules that make a big difference.

In this post I’ll explain the components of my ideal naming conventions.

Read the rest of this entry »

Written by Xaprb

October 26th, 2008 at 2:43 pm

Posted in Coding, SQL

Tagged with , , ,

How to swap Caps-lock and Esc keys in Ubuntu

with 3 comments

Here’s a productivity tip that has saved me countless work while typing. Swap your Caps-lock and Escape keys. If you’re like most people, you use Caps-lock virtually never, and Escape quite a lot. Especially if you’re a programmer who happens to use the best text editor, Vim. Read on to learn how to do this.

Read the rest of this entry »

Written by Xaprb

October 22nd, 2008 at 6:00 pm

Posted in Coding, Desktop

Tagged with , , , , ,