Tag Archives: ruby

Connecting ActiveRecord to SQL Server

What is ActiveRecord?

  • ActiveRecord is a Ruby library that was written by the creators of Ruby on Rails to do database integration. It connects classes to relational database tables to establish an almost zero-configuration persistence layer for applications.

That’s great, but we’re not using Ruby on Rails and our web app has SQL Server on the back end. How can we leverage ActiveRecord in our environment?

  • Good news! You can use ActiveRecord without Rails! If you are a Ruby programmer, you can can connect very easily to SQL Server to create models! You get a great deal of functionality such as basic CRUD operations, data validations, search support and many others!
  • All of this can be accomplished with the activerecord-sqlserver-adapter gem.

How do I connect ActiveRecord to SQL Server?

For more information, check out my example:


Cha’ Cha’ Changes

In November, I accepted a new position as a SDET within my company. With it, I get the opportunity to program in Ruby full-time, something I’ve been wanting to do for quite some time. Since then, my life has become quite the whirlwind. I have been engrossed in learning the language as well as coming up to speed with the testing culture and being an evangelist to our Devs and QAs.

I’ve also had the opportunity to talk to many people active in the community who are experts in testing to try and learn the best ways to implement automated acceptance testing within an organization.

My first order of business is to implement automated UI testing using Cucumber and Watir. I’m sure over the next few months I’ll be blogging about the challenges that we face to achieve these goals. Stay tuned!

Tagged , , ,