Kudos to this blog for helping with postgres performance tuning. http://www.revsys.com/writings/postgresql-performance.html Per the blog, the biggest change that you'll notice is the shared_buffers change. I tried this, but got into kernel shmmax ...
Top 6 list for future fathers
A friend of mine had a top list for 2010 and thought that was a pretty cool thing to do. Stealing from him and focusing on my most entertaining stories has led to a top list of fatherhood knowledge: 1. Learn your kid's cues Yes, it sounds vague, c...
Developer estimates
In the agile methodology, developers provide estimates on features. Features must provide business value,be small enough to put into a sprint (or work iteration), and have enough definition to provide an estimation for. If a feature is too big for...
Running shell scripts in Ruby
In transitioning an application from java/jsp/oracle to ruby/postygresql, there are still some java processes I'd like to keep (or rather due to time constraints not re-write). So I needed a way to call the java processes from Ruby upon user-compl...
Remember all the oracle functions? We need those in postgresql.
Well, how the hell do I do that? Here's how: 1. Install perl (if you don't already have it): apt-get install perl perl -MCPAN -e shell m DBI get DBD::Oracle 2. Install oracle instant client on your linux box (if you don't already have it): apt-get...
How to create a branch in github
So the dev project I'm working on is going two separate paths. My co-worker is looking at more of the ajax/look & feel stuff while I'll be working on the model (moving to postgresql). We might not bump into each other much, but better safe than so...
2 sites to get Ruby & Postgresql running on Ubuntu
I take no credit - these bloggers did a great job and made mine easier today: 1. Installing ruby & posgresql onto a new ubuntu machine: http://vandenabeele.com/Rails-on-Ubuntu-Jaunty 2. Getting postgresql to accept remote connections: http://www.c...
How to get, and parse XML for storing in a DB in java
Initialize! I first read from a config file to get needed DB connect & directory parameters. I also read in a pre-stored-procedure and post-stored-procedure optional parameters in case we decide to do some db-side dirty work later. Getting the XML...
Twitter search via Ruby
Thanks to http://www.instantmessagingplanet.com/public/article.php/3800716/Create-a-Twitter-Mood-Graph-With-Ruby.htm, I finally have a twitter search feed working. The link shows how to generate a graph based on tweets, which maybe helpful later. ...
UNetbootin
At home, I have a dell xps400 that was just trying to deal with windows XP. A friend of mine recommended Ubuntu. So, what do i do? I download the ISO, burn a CD with it on it, and plug it into my xps machine. "No boot device found" It's going to b...