Phew - patch for ActiveRecord for InterBase

Things just went crazy since i last posted - so I have only just finished testing the ActiveRecord patch for InterBase. Perhaps my biggest disappointment with it was finding out that ActiveRecord (the sub-project of Rails that Rails uses for accessing the database) does not support parameterized data types when talking to the database - everything is converted to a whopping great big string and executed. This means that there is no support for binary blobs in the InterBase adapter and BLOB text is limited in size (32k depending on the rest of the SQL size). But as they say in the Rails community, if you want it to work better, make a patch - so thats what I will do and see if I can get it accepted - on initial examination, Ruby’s duck typing should be a big help!

So if you are interested in using InterBase with Ruby on Rails, go grab Edge Rails, apply the patch and get IBRuby 0.5.2 (fixes were necessary to get it past the gamut of tests that come with ActiveRecord). It fully supports Migrations, allowing you to programatically version your changes to the database - starting out with a table, adding and removing columns and indexes, renaming the table and so forth. That in itself was a fascinating exercise in examining the InterBase meta-tables.

Share This | Email this page to a friend

Posted by Richard Vowles archive on December 23rd, 2006 under Uncategorized |

Server Response from: dnrh1.codegear.com