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 https://github.com/logstash/log4j-jsonevent-layout

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

Logstash

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 http://logstash.net/docs/1.4.2/tutorials/getting-started-with-logstash, 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 https://bobswift.atlassian.net/wiki/display/info/How+to+display+SVG+attachments+in+Confluence

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