Here is from an email I was writing a friend who is interested in how to use a wiki. I wanted to share with him so cool stuff I am doing, and it evolved into an interesting picture of how I use wiki
I have been using XML objects to store configuration data, and to persist data between runs for a program that develops website content.
It's rapidly looking like i need to have a SQL database for the intermediate results.
So I was looking up alternatives for SQL from java. I could just use one of the copies of SQL server that I run, but then I couldn't easily make this java program available as a standalone program without some complicated setup instructions, and requiring someone to have their own copy of SQL server. So I created a wiki page with a couple of standalone alternatives for doing SQL from java. hsqldb is one I've seen mentioned a lot, so I downloaded it....
So then i was looking at some examples on the net of how to use it. It is tedious to use JDBC to talk to SQL databases from java. Linq for C# is way easier once you get over the learning curve.
I found a wrapper class that looked cool..... Then I was needing to make some updates to the code (since it was from 2003), and then doing some "wouldn't it be nice if" thinking, started running into problems, figured them out, then created a wiki page about that:
Dealing with unimplemented exceptions
Then i was arguing with the networking on the server when I couldn't get to my subversion repository. I recognized it as a dropped gateway problem. I had previously written a wiki article, back in 2007, about [problems with dropped gateways], so I reread my article to refresh my memory about what I'd learned, and read some of the things I'd found in my previous research.
Multiple Gateways on Windows 2003 Server
It's interesting to go to the Tools -> Info and look at the list of google queries people were using to find this page.
From reading that, and the linked pages, I thought I figured out a fix to the problem, tried it, and it seemed to work, so I added a note:
Fixing a dropped gateway on Windows Server 2003 with new route entry
Then when it didn't work, I added another update to that page....