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 »

TechTool Pro 6.0.8 Download

It took me a while to find the download link for TechTool Pro 6.0.8 so I thought I’d share it for others: TechTool Pro 6.0.8 Download Mirror

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 »

Check for a NULL/nil YAML value stored in a database column

I was trying to google for searching a database for a nil yaml value and it took me a bit so I thought I would post my findings.  Basically if you do this in the rails console:

you’ll receive:

Kind of irritating when you’re trying to write a SQL query. So to check… Read More »

Pinterest Chrome Extension – Disable “Pin It” on Hover

You can easily disable this as an individual who has installed the extension, but if you don’t want it to conflict with any other social software you may have on your site, all you need to do is add this to ever IMG tag: <img src=”myimage.jpg” data-pin-no-hover /> Or you can use nopin.  Found in… 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: