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’reRead more
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
- Define the model and controller (nifty_scaffold is great for building quick, CRUD interfaces)
- Add data to the database via the CRUD interface
- 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
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
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