I created an account on Stack Overflow, then deleted it within a few hours

Like many developers I come across Stack Overflow pages with some frequency when performing research. I came across a question to which I had an answer and I decided to was time to try and contribute. Well, my answer was deleted, and then the question was deleted, and at no time did I get any …

Continue reading ‘I created an account on Stack Overflow, then deleted it within a few hours’ »

Stumbling on cool things

I’m interested in emulators, always have been, and I was wondering if anyone had used LLVM to write an emulator. I came across this highly detailed account which was a fun read: Statically Recompiling NES Games into Native Executables with LLVM and Go It concludes stating that static recompilation is probably less practical than JIT, …

Continue reading ‘Stumbling on cool things’ »

Rails Database Config Parameters for PG Gem

I’ve noted how difficult it is to get a complete list of parameters that can be used in the Rails’ config.database.yml file. I understand this is because there are different parameters for the different library layers. Still, I would like a more complete list somewhere, especially given that the parameter names can be confusingly similar …

Continue reading ‘Rails Database Config Parameters for PG Gem’ »

The easiest way to migrate a database from MySQL to PostgreSQL

I had to do this recently for a project. The difficult piece was sorting through the opinions of what the best tools and procedures for handling this migration was. So I tried a few until I found one that worked so well, so quickly that I decided it was worth sharing. Firs tthings I used …

Continue reading ‘The easiest way to migrate a database from MySQL to PostgreSQL’ »

The easiest way to get ruby 1.9 debugging functionality on Ubuntu 12.04

I’ve come across a number of posts giving instructions on how to get debugging to work with ruby 1.9.x and they all seem to involve downloading gems and installing them. Here is what I did on my Ubuntu 12.04 workstations that was very easy though not trivial to figure out. sudo gem install linecache19 –pre …

Continue reading ‘The easiest way to get ruby 1.9 debugging functionality on Ubuntu 12.04’ »

Decimal precision for geocoding coordinates

I did some research and found a lot of discrepancy among recommendations for the decimal precision when doing geocoding. Some say you only need 4 digits of precision and others suggest up to 15. In my own testing the best results seemed to be with 6-digits and SQL type of PRECISION(9,6) for latitude and longitude. …

Continue reading ‘Decimal precision for geocoding coordinates’ »

Fixing netbeans in ubuntu

Netbeans has some issues in Ubuntu 10.10 and 11.04.  One of the most serious is that javascript syntax highlighting does not work.  Another is that Rails 3 applications do not run or debug correctly.  I found the solution to be going to “Tools – Plugins -Settings” and enabling the “Netbeans” update center.  Then by going …

Continue reading ‘Fixing netbeans in ubuntu’ »