Simple PostgreSQL Scripting

January 12, 2015

I wanted to write a postgresql script that would insert into two tables, and it would include the autogenerated serial from the first insert in the second. I have a master/detail relationship so the serial from the first insert (the master table) needs to be used in multiple rows ...

Python VirtualEnv on Windows

December 31, 2014

I have a need to allow another developer to work on one of my projects, and he's on windows. I develop in Linux. Unfortunately, the setup on my machine has developed over the years, so it's not easy to replicate. There's a lesson there I'm sure ...

Logstash and Log4j

November 11, 2014

I wanted to log from a log4j process through to Logstash, and have the logging stored in Elastic search. This can be done using the code at

To make things easy for my test, I put the source code for net.logstash.log4j.JSONEventLayoutV1 and ...


November 11, 2014

I wanted to have a play with LogStash to see if it would help with analysing log files. I first followed the instructions at, which covers settings up logstash, running elastic search and logging events to it.

  • Elastic search is a ...

SVG in Confluence

October 5, 2014

We wanted to host an SVG document with clickable links in a Confluence site.

SVG Images

First, we followed the instructions at

  • Go to your Confluence server and find the directory where Confluence was installed.
  • Edit ...