Linux Journal: Information Management for the Desktop

“It’s been tough being a newbie for these past several years.
I’ve managed to stick with it and believe I’ve set a good example
for being a sustainable newbie overall. The nice thing about the
open-source world is that there is no stigma attached to being
stuck on square one for extended periods of time. Unlike public
school, where you are subjected to unbearable ridicule if you fall
behind, in the Open Source community, there is no ‘behind’, only
‘forward’, ‘onward’ and ‘upward’. That’s a good thing.

“I have a PostgreSQL database on my home computer, and I must
say that it’s a most impressive application. I managed to combine
that with another application, called pgaccess. Between the
command-line interface and pgaccess, I enjoy adding information to
the little databases I’ve created. Sometimes, I’m rewarded with
having useful information to look at when I search the database
with SQL queries. I’ve wondered from time to time, however, how I
might use the database to centralize all the information on my
system. For example, I have some useful information floating around
in e-mail archives, never to be read again. I suppose I could learn
the search/grep commands that would let me revisit old e-mails, but
that doesn’t seem productive to me. Now, if the old e-mails with
useful information could be transferred to my database, I think
that would be nifty. The following, then, is a description of what
I came up with that seems simple and easy and might even be
useful….”

Complete Story