Sam Smoot
10/20/2006 8:23:00 PM
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!