Connecting Ruby On Rails (on Redhat Linux) to SQL Server

Setting up Ruby On Rails and SQL Server 2005 Database connections on Redhat Linux Following are the setup notes for how I got Ruby On Rails (running on RedHat Enterprise Linux) to connect with Microsoft SQL Server. This is based on the Ubuntu Platform-install instructions for activerecord-sqlserver-adapter Install the Redhat Packages unixODBC unixODBC-devel Download, compile, and install the stable version of FreeTDS Edit the configuration for FreeTDS…. we need to tell it about the SQL Server hosts and ports we’re

Read more

RoR Database seeding

Lately, I’m researching various RoR methods, technologies, and doing further ready on Agile software development methodologies. Below is a technique I’ve learned for seeding RoR databases.

    Database seeding technique

  1. Define the model and controller (nifty_scaffold is great for building quick, CRUD interfaces)
  2. Add data to the database via the CRUD interface
  3. Use sqlite3 command to extract the new seed data into a flat file.
    In this example, the table contains custom fields for name and description.

       cd [project folder]\db
    sqlite3 development.sqlite3

    Read more

MIT Coeus – independent build #1

Standalone – MIT Coeus Build #1

Yesterday marked my first success in doing a stand-alone compile of MIT Coeus, version 4.3.7. Of note, while upgrades must be run separately for new revisions (ex 4.3.1 to 4.3.2 to … to 4.3.7) for schema changes and SQL commands, the Java source (which comes in the same archive) is a complete replacement. Unpacking (ex 4.3.1 to 4.3.2 to … to 4.3.7) into the same source folder and then trying to do a build is asking for problems.

These following doc aws helpful in getting Java code signing and the local keystore configured.

Read more

Buzzwords HaYom

ChangeMan, Remedy, change management, revision control, deployments, MIT Coeus upgrade 4.4.2, merging modified code to a new version, source code diff via BeyondCompare, UML, Use cases, Ruby On Rails, Kuali RICE, workflow, Kuali REW

Read more

Investigating screen-scraping options

Today, I’m investigation screen-scraping options in order for a Ruby on Rails front-end to communicate with a legacy, IBM mainframe application, via terminal emulation and screen-scraping. The purpose of this research is to see how easily a new system could do live queries (and updates) in the legacy system, without having to go batch or open up the legacy system.

Read more