Searching Elasticsearch

October 11, 2016

I wanted to return a list of entries from ElasticSearch, and I wanted to just return ones where the _type field was set to c.


This URL will filter to just the rows with a _type of c ...

Listing ElasticSearch indexes

October 11, 2016

To find out a top level list of indexes in an ElasticSearch database, use:


which returns something like

health status index               pri rep docs.count docs.deleted store.size 
yellow open   logstash-2016.10.06   5   1      18908            0        6mb            6mb 
yellow ...

RegEx Search and Replace in Java

July 7, 2016

I wanted to remove the contents of any tags in my XML that ended with the word Password, and replace the password with stars. So:


should turn into


This can ...

Venn Diagram in SVG

June 22, 2016

I wanted to put a three way Venn diagram onto a web page. I didn't want to control the size of the circles, but I did want to put numbers into the intersections.

I managed to do it with the following SVG. The double curly bracket notation is Django ...

Tags: svg venn html

Extracting XML from Oracle XMLType using XPath

May 4, 2016

I wanted to extract some XML from a column in a table. The column was of type XMLType, and the XML that was within it had a Namespace in it.

INSERT INTO drumcoder values ('<fred xmlns="drum"><joe>456</joe></fred>');

The value of the joe tag (456) can be ...