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’ »
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’ »
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’ »
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’ »
If you want to get the numeric month from strftime your only only is %m which is zero padded. So January is “01”. But what if you don’t want zero padding? Turns out that’s non-trivial, unless you’re on a system that supports strftime flags. Then you can use “%-m” for no padding (“1”) and “%_m” …
I have a Ruby On Rails project with a fair amount of hierarchical data. I have already tried a few different techniques of managing this data. Nested sets and materialized paths sound good in theory but in practice they didn’t work out so well. Here are some thoughts thus far.
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 …
Trying to figure out how easy it is to use ruby to write a desktop application. It would be nice to have something cross-platform. At the moment I’m playing with qt4, gtk2, and wxwidgets.
Just walking through some bug fixing.
Lots’ of work moving to unobtrusive mapping using googe maps and jquery, storing location data as hcard microformat.