On Sat, May 29, 2004 at 06:27:05PM +0200, R. Klemme wrote:
> But if I understand you correctly there is no legal or technical reson that
> would prevent integration of freetds.
Correct! And, it's not neccessary to integrate a FreeTDS DatabaseDriver
into DBI, it could live as a separate project, like for example the
Oracle 9i DBD.
> > You can already access MSSQL from all platforms via DBD ODBC + DBD
> > Proxy. But that might not give you the performance you need.
>
> So I assume, that you need a proxy running on some wintel box that does the
> ODBC connection and a client on any platform that connects via this proxy to
> the db.
Exactly! You run a proxy on the Windows machine (of course this works
with any other platform/database on which ruby runs/for which a DBD
exists), and can connect to it via TCP/IP using DRb (Distributed Ruby).
Of course there are security issues and performance issues to respect.
Security can be fixed by tunneling (or using a SSL socket), performance
might be the bigger problem. But keep in mind that the Proxy DBD is just
~100 lines of pure Ruby code, and the proxyserver is ~150 lines of pure
Ruby. And DRb is ~800 lines (pure Ruby again :-).
Regards,
Michael
|
