From: Sam Smoot <ssmoot@...>
Date: 2006-10-21T05:25:11+09:00
Subject: Re: MsSqlClient ActiveRecord Adapter initial gem-release!

I'm re-thinking my email reply to Tom:

Tom Ward wrote:
> It looks like most of the work you've put in is in implementating the
> ms_sql_client.dll.

It's subtle, but getting the sqlserver adapter to be "stateless" was a
bit tricky, and for me at least, definitely a behaviour I want to keep.
I can't stress this one enough. There's no performance advantage to
Rails' "pseudo-connection-pooling", and it causes problems. It goes on
the chopping block IMO. :-)

> Is there any reason you couldn't adapt this to provide a new
> DBI driver which would work seamlessly with the current
> sqlserver_adapter code?  If there are reasons, are there any changes
> that could be made to the sqlserver_adapter so it could easily work
> with both DBI and your interface?
>
> Tom

I've been thinking about it some more, and I think maybe a "DBI-Plus"
interface... I'm not sure. Bulk Inserts are definitely something I
would want to integrate eventually.

I liked the idea of bringing more of the adapter into C++ eventually,
but the truth is it probably doesn't matter all that much, I probably
should focus on the cleaner seperation you suggest instead.

I would definitely value any input/opinions anyone has on the matter
though.

Thanks, -Sam

PS: Dr Nic:
  If there's any extra database introspection or anything you would
find helpful in your work don't hesitate to suggest it!