SQLAlchemy w/ Sybase?

[skip.mo...@gmail.com]

I may have asked this here before. If so, I don't recall seeing an answer.
Has anyone looked at writing a driver for SQLAlchemy that talks to the
Object Craft Sybase module?

SQLAlchemy-0.http://object-craft.com.au/projects/sybase/

If not, how difficult is such a driver to write? Is there any porting
documentation available?

Thx,

Skip Montanaro

[Rick Morrison]

Skip, I looked at (and rejected as too green) an early implementation of an MS-SQL module from Object Craft when putting together the MS-SQL module for SA. It was very similar to their Sybase module.

That's no surprise:  as you probably know, MS-SQL was originally a joint project between MS and Sybase, and MS came out later with their own version of SQL Server. (What happened later to Sybase, and other MS "partner" companies like Lattice, is a rant for another day).

Anyway, to this day the underlying wire protocols of MS-SQL and Sybase are nearly identical. Given that, along with the shared Transact-SQL that they both use,  I would think that the MS-SQL and Sybase modules would be so similar that they could be better done as a single integrated module.

But these days, I'm thinking that effort might be better spent on an ODBC module that could be used to drive MS-SQL, Sybase and dozens of other ODBC compliant databases.

Rick

[skip.mo...@gmail.com]

Rick> Skip, I looked at (and rejected as too green) an early
Rick> implementation of an MS-SQL module from Object Craft when putting
Rick> together the MS-SQL module for SA. It was very similar to their
Rick> Sybase module.

Rick> That's no surprise: as you probably know, MS-SQL was originally a
Rick> joint project between MS and Sybase, and MS came out later with
Rick> their own version of SQL Server. (What happened later to Sybase,
Rick> and other MS "partner" companies like Lattice, is a rant for
Rick> another day).

Rick> Anyway, to this day the underlying wire protocols of MS-SQL and
Rick> Sybase are nearly identical. Given that, along with the shared
Rick> Transact-SQL that they both use, I would think that the MS-SQL and
Rick> Sybase modules would be so similar that they could be better done
Rick> as a single integrated module.

Rick> But these days, I'm thinking that effort might be better spent on
Rick> an ODBC module that could be used to drive MS-SQL, Sybase and
Rick> dozens of other ODBC compliant databases.

Rick,

Thanks for your response. Unfortunately, none of this means a whole lot to
me. I have no MS-SQL experience (nor do I want to acquire any). Also, I'm
not really interested in horsing around with a new DB-API module. I'd
really like to find out how hard it would be to write an SQLAlchemy driver
for the python-sybase module. That looks like a much more tractable problem
to me. If there's another DB-API module that will talk to Sybase without
modification I'm willing to look at it.

Thx,

Skip

[Rick Morrison]

Point I was trying to make is that it might be easier to adapt the SA MS-SQL driver to work with your Sybase DB-API module than it would be to write a whole new one.

Rick

[skip.mo...@gmail.com]

Rick> Point I was trying to make is that it might be easier to adapt the
Rick> SA MS-SQL driver to work with your Sybase DB-API module than it
Rick> would be to write a whole new one.

Thanks. I completely missed that reference/implication in your original
post.

Skip