Elasticsearch – Creating an english analyzer with asciifolding

When using the english analyzer with my Elasticsearch index I also wanted to use the asciifolding filter to remove accents. I couldn’t find a simple way to do this so I ended up just replicating the existing english analyzer, and then adding asciifolding to the list of filters. See below:

Running server density on startup on OS X (El Capitan Edition)

For some reason the existing solution for configuring server density to run on startup with OS X was failing for me. For whatever reason, this is what ended up working for me, and I dare not touch it now!

Using pg_activity with Amazon RDS

By default you aren’t able to use pg_activity to connect directly to your Amazon RDS instance. This is due to two things: You don’t have superuser, ever, on Amazon RDS pg_activity tries to get information on all databases, which includes the rdsadmin database that you will never have access to.  This database is owned/managed by… Read More »

Building your own solar panels

I was getting tired of powering a lot of the computers I use in my home office every month so decided to try out building some solar panels!  I’m going to start off small, but try to plug the batteries into my existing electrical system.  Luckily my fiance’s uncle is an electrician so he’ll be… Read More »

PostgreSQL + Chef – Automatically configure based on server RAM

I was sick of changing shared_buffers, effective_cache_size, maintenance_work_mem, work_mem, SHMMAX, SHMALL each time we’d spin up a new server. So I decided instead to have chef calculate it for me! It takes the available RAM of the server and then calculates each value based on:

The recipe: