SQL

Getting Ruby to talk to MSDE

Posted by Michael on April 9, 2010 in Configuration, General, Ruby Language, SQL, Setups

Getting Ruby to talk to Microsoft SQL Server 2005 is one thing. Getting Ruby to talk to Microsoft SQL Server Developer Edition 2000, has one twist that threw me off for hours. Here, I’ll show you how to do and hopefully save you lots of frustration and brain damage from banging your head [...]

Rails vs. Ramaze Performance Comparison

Posted by Michael on February 19, 2009 in General, SQL, Servers, Systems

One of my biggest concerns of late is that my “more than just a little trivial” Rails projects seem to find their way straight into the heavyweight category in no time at all. While I am quite hopeful that Merb being the 3.0 version of Rails will resolve many of the issues I face [...]

Ruby, Mysql, CentOS 5, and 64-bit

Posted by Michael on January 19, 2009 in SQL, Systems

I have lately switched away from Ubuntu as my desktop and started using CentOS 5.2 because I wanted better support for a lot of RAM and virtualization (where I can quickly commission Linux servers to build out my testbed of target environments).  With the change, I also make the leap into pure 64-bit libraries with [...]

Converting Oddmuse Wiki to Edgewall Trac

Posted by Michael on October 2, 2008 in Macs, Programming, Python Language, Ruby Language, SQL

Our company began long ago with wiki’s, but we chose the Oddmuse wiki way back when. These days, we’re heavy users of Trac wiki because of its integrated ticket support system. So what to do with all those old wiki’s that folks have stopped using and reading. The Oddmuse wikis still hold [...]

Geocoded Zipcodes

Posted by Michael on July 7, 2008 in Ruby Language, SQL

You would think that loading up a database of zip codes would be an extremely simple case of finding a public database on www.usps.gov, and then loading up with a database bulk load. It turns out that, while the USPS does offer products for you to purchase, and a rather nice lookup interface for [...]

DRYing your Views

Posted by Michael on July 5, 2008 in General, Ruby Language, SQL

Let me start out by saying that I am finally beginning to understand a bit about that magical Ruby block notion and how implementing methods through block passing can really empower you as a Ruby developer. Thanks to, a most excellent Ruby tutorial, I am definitely feeling a good bit more empowered about getting [...]