ActiveRecord msaccess_adapter
Ever wanted an ActiveRecord adapter for Microsoft Access? Well, I'm creating one! It's not done yet, so I can't give you a link, but I'll tell you a little about it. It works off of ADO, using WIN32OLE - not DBI. I decided to go with straight ADO because DBI was just an unnecessary layer of limitation. To this point, I have most of my read capability figured out - only a few more data types need mapped correctly; and the date format for writing needs fixed. I'd say I'm half done, but even at my current level I have a RESTful web service built on top of my access database. Since most reasons for using Access have to do with an Access database for some old software that needs reading and manipulating, I made sure it's easy to specify a different database file, table name, and primary key for each model (the last two functionalities already exist, actually).
Please comment if you want me to post it when I'm done!
# - - - - - - - - - - - - - - - - - - #
Added July 16, 2007:
Okay, I've released it - head over to http://blog.behindlogic.com/2007/07/msaccess-for-rails-heres-your-rough.html to read more and get the code!
4 comments:
I'm interested in what you are working on. Let me know when you feel comfortable letting it loose.
Sounds very nice. I also would opt-in for a beta test.
Hey, I don't think I can get your email addresses from the comments -- if you happen to check back here, shoot me an email at ghouldiwno@kriocoudek.mailexpire.com (that'll expire in a few months though).
I'm definitely interested in this feature. I recently had a painful experience migrating Access data to my Rails app. Please let me know when you're ready. I'm available at ETHANDLE@GMAIL.COM. Thanks. Best wishes.
Post a Comment