Looking for Some Software
Generally my posts here are in the form of information or answers. This one is really a question. I have been thinking about this problem for quite some time and looking for a solution and finally realized it made perfect sense to ask here. If I don't get a good answer, I will have to build my own and I will share the results with you folks.
I have a few hundred logins for various things. They include different things for TUX-related stuff such as my login to our computers, root access information, database user information and even this web site. I then have multiple email accounts and logins on different computers at home. Add to that login information for web sites where I have accounts--from freshmeat.net to powells.com. While some of this is remembered by my KDE wallet, all can't be and I am not always accessing these sites from this machine.
My currect "record keeping system" is a notebook. It is filled with scribbles, things crossed out and pointers to new pages. Efficient is not the word that comes to mind. For example, yesterday I was looking for the root password for a machine I seldom access. It took me about ten minutes to find it.
Having the notebook has taught me there is a lot more needed than just a list of machine name or URL, login and password. For example, for places where I order products, I would like to add a comment when I place an order that includes the order number and some shipping information. For a domain name (such as tuxmagazine.com) I want to know where the domain is registered and when that registration expires. I also want a record of renewals.
This is a simple database application. But, it also needs to be very secure. For that reason, I want something relatively self-contained. That is, I don't want a MySQL or PostgreSQL server somewhere. I want to be able to write the whole system--that is, the data and the program to access and update it--on a USB flash drive to lock away for safe keeping. Or possibly on an encrypted local filesystem.
Armed with that criteria I designed the tables I needed. There are only two: one with the URL, login name, password, a timestamp and an extra field for special considerations such as needing a security key. A second table is for comments. This allows multiple comment records to be associated with each entry in the first table.
Feeling confident this was easy I started looking at the obvious candidates such as OpenOffice.org base. To make a long story short, with the exception of Rekall, all what appeared to be easy solutions failed. Rekall is a possibility but I felt like this was not as easy as it should be. So, I went looking to see if someone else had written a similar solution. I found web-based solutions but they fail in an assortment of ways including being locally secure.
So, here I am today. No solution that makes me really happy. Any ideas?