OT(?): ADO driver for DBI--anybody working on that?

[Roy]

Hey All,

I'm toying w/the idea of trying to breathe life into the ADO driver
for DBD (the lack of which is I think the last thing keeping me from
moving to ruby 1.9). (This would be a stretch for me skills-wise, so
nobody should hold their breath waiting for it.)

Nobody's already working on that, are they?

Thanks!

-Roy

[Clifford Heath]

On 25/11/2009, at 4:10 AM, Roy wrote:
> I'm toying w/the idea of trying to breathe life into the ADO driver
> for DBD

I built a "win32ado.rb" module that acts as a thin-as-possible layer
over ADO using win32ole, with the thought that the SQL server
adapter should avoid DBI and DBD altogether - they're mostly
just unnecessary fat in this case. Using win32ado, you can for
example issue multiple commands and return multiple datasets
in one go, which saves on context switch overhead.

You're welcome to take it and run with it, just ask. It's not on GH.

Clifford Heath.

[Ken Collins]

Have at it, when I find time and the gumption I'll be moving with some testing of IronRuby and the native ADONET connection layer. Sure IronRuby does not even pass many of the tests, but it is hopefully a good way forward those on Windows.

I agree with Clifford that DBI and the ODBC DBD are big middle layers, but there are two important things to consider. First, the elephant dances and passes all test, there is something to be said for that. Second, the way I have the adapter now it is not highly coupled to that implementation. So when/if I do take the time to test IronRuby with ADONET, it will not be a big underlying chance, just pretty much a connection option. Same thing should apply for the backward ADO connection. Hope that helps and feel free to fire off questions as you go.

- Ken

> --
>
> You received this message because you are subscribed to the Google Groups "Rails SQLServer Adapter" group.
> To post to this group, send email to rails-sqlse...@googlegroups.com.
> To unsubscribe from this group, send email to rails-sqlserver-a...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/rails-sqlserver-adapter?hl=en.
>
>

[Roy Pardee]

Thanks guys!  I've asked Clifford for his code.  I (mostly) successfully built and installed a do-nothing gem on the bus ride home today, so part of the mystery is becoming clear.

I think the first thing I'll try is to gem up Michael Neumann's original ado.rb & see if I can make that barf...

Thanks!

-Roy

--
Roy Pardee
http://facebook.com/rpardee

[Ken Collins]

Keep in touch. To both you and Clifford, I am WAY more than open on adding all sorts of low level alternate connection options. If that win32ole.rb is tested and prime time, I'd love to take a patch to incorporate it!!!

 - Ken