[DB-SIG] Re: [Python-Dev] database APIs

[Kevin Jacobs]

On Mon, 3 Feb 2003, Luke Kenneth Casson Leighton wrote:

> On Mon, Feb 03, 2003 at 04:01:52PM -0500, Kevin Jacobs wrote:
> 
> > > p.s. if you're interested in how i managed to get MS-SQL 2000
> > >      access from python on a unix system, the code's at
> > > 	 http://sf.net/projects/pyxsqmll.
> > 
> > I use David Cole's MS-SQL w/ Sybase ASE and his Sybase module with FreeTDS. 
> > Both provide fast access to MS-SQL 2000 from linux, though neither is 
> > quite production quality yet.
>  
>  the things that pyxsqmll don't do is binary data and HTTPS
>  (i have a 15 line patch for the HTTPS) but binary data
>  i no longer have access to an MS-SQL database so ain't in a
>  position to add it.
> 
>  freetds wasn't in a useable state at the time i needed MS-SQL
>  access so i plumped for the XML interface option in MS-SQL 2000.

It isn't in a great state even now, though it is crawling towards a better
state.  However it is _much_ faster than pyxsqmll, especially for our
workloads.

-Kevin

-- 
--
Kevin Jacobs
The OPAL Group - Enterprise Systems Architect
Voice: (216) 986-0710 x 19         E-mail: jacobs@theopalgroup.com
Fax:   (216) 986-0714              WWW:    http://www.theopalgroup.com