Rails - Jun 2005 - <rails-l> sqlserver_adapter.rb fyi...

if you want to possibly write a rails-based web replacement for SQL
Server Enterprise.msc, there''s a subtle gotcha in the current
sqlserver_adapter.rb.  It queries the INFORMATION_SCHEMA.COLUMNS
table, which inconveniently does not include the sysobjects,
syscolumns, etc. tables (it only includes objects from sysobjects
where xtype in (''U'',''V'')).

I''m going to try to write a straight-up ADO-talkin'' sql server
adapter
(probably call it mssql_adapter.rb) to supplant the DBI-dependent
sqlserver_adapter.rb.

If anyone wants to help out or needs someone to contribute to an
existing effort, drop me a line.

The main driver on this is to be able to use some of the ADO
Recordset/Record methods with the AJAX paging features, primarily, but
also to allow use of stored procedures as well.

One thing I want to add to it is connection pooling, but I don''t have
any good ideas how to bootstrap it into the existing driver (i.e.,
initial launch sets up N of M connections, and each action gets a
connection from the pool, or starts a new one until M connections are
created), but maybe it''s not really possible (probably would need to
let the adapter have access to session management information in other
places in Rails, no?)

(Sorry for non-Win32 rails users)

-Corey Lawson
corey.ssf.lawson-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org

I''m interested in learning more about what you want.
I am using MSSQL and haven''t found any problem as of AR 1.10.0.
I am not creating a site with high user load though.

Peter J. Fitzgibbons
Applications Manager
Lakewood Homes - "The American Dream Builder"(r)
Peter.Fitzgibbons-STCS76aLmhk1y/cD6r8xzl6hYfS7NtTn@public.gmane.org
(847) 884-8800 


-----Original Message-----
From: rails-bounces-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org
[mailto:rails-bounces-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org] On
Behalf Of Corey Lawson
Sent: Wednesday, June 22, 2005 8:36 PM
To: rails-l
Subject: [Rails] <rails-l> sqlserver_adapter.rb fyi...

if you want to possibly write a rails-based web replacement for SQL
Server Enterprise.msc, there''s a subtle gotcha in the current
sqlserver_adapter.rb.  It queries the INFORMATION_SCHEMA.COLUMNS table,
which inconveniently does not include the sysobjects, syscolumns, etc.
tables (it only includes objects from sysobjects where xtype in
(''U'',''V'')).

I''m going to try to write a straight-up ADO-talkin'' sql server
adapter
(probably call it mssql_adapter.rb) to supplant the DBI-dependent
sqlserver_adapter.rb.

If anyone wants to help out or needs someone to contribute to an
existing effort, drop me a line.

The main driver on this is to be able to use some of the ADO
Recordset/Record methods with the AJAX paging features, primarily, but
also to allow use of stored procedures as well.

One thing I want to add to it is connection pooling, but I don''t have
any good ideas how to bootstrap it into the existing driver (i.e.,
initial launch sets up N of M connections, and each action gets a
connection from the pool, or starts a new one until M connections are
created), but maybe it''s not really possible (probably would need to
let
the adapter have access to session management information in other
places in Rails, no?)

(Sorry for non-Win32 rails users)

-Corey Lawson
corey.ssf.lawson-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org
_______________________________________________
Rails mailing list
Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org
http://lists.rubyonrails.org/mailman/listinfo/rails