Use PostgreSQL Gem Instead of SQLite When Deploying Rails Applications to Heroku

Ruby on Rails logo

This is for both RoR 3.2 and 4.0.0 beta1/RC1! When creating a new Ruby on Rails application, the Gemfile will include the gem for SQLite by default. Example excerpt from Gemfile in your RoR application directory: When running Rails server in development on your local computer (most likely a Mac or Linux), this works fine. … Read more

Issues with CFML Syntax when Switching from Adobe ColdFusion to Railo

Adobe ColdFusion logo

Railo is an open source CFML server that can replace Adobe (or Macromedia) ColdFusion. I ported several CFML-based apps from an old instance of Macromedia ColdFusion MX 6 to Railo 3.2.1 about two years ago, and it’s been relatively trouble-free since the change. However, the change itself was fraught with difficulties. That was due, not … Read more

Do We Have to Use a SQL Cursor?

SQL Server logo

In migrating data from a legacy budget application to its replacement, my requirement was to take the first and last years in a budget from the old application and update the corresponding table in the “new” app table with those dates as the beginning and ending of the project. One possible solution is to use … Read more