Skip to content

ctds adoption #6

@sylvainr

Description

@sylvainr

Speaking of adoption (previous thread), I think a very impactful feature would be to have a SQAlchemy connector to ctds.

I have been on a quest for the perfect Python MSSQL driver for the last few months and each driver has issues:

  • pymssql: No bulk insert support + stability issues reported for 1+ years (which crashes/seg-faults the python process). Pros: multi platform support in conda.
  • pyodbc: No bulk insert support + not easy to setup. Some support in conda.
  • pytds: Does have bulk insert support, but does not support SSL connections, which makes it unusable on Azure. Pros: pure python, easy to deploy.
  • ctds: No SQLAlchemy connector. Not sure if it supports SSL either? Also, is it cross-plarform? It looks like there are some conda packages available for OS X and Linux but did not find anything for Windows.

I feel that the convenience of having a pre-compiled conda package is huge, especially when people using Python+SQL Server are frequently data scientist kind of personas, and tend to favor convenience above everything else.

A SQLAlchemy connector allows more advance users to easily swap their driver. I tried to write one for ctds but pretty much failed.

Finally, I don't think a lot of people know about ctds. Having a blog article on Zillow's tech blog (if it exists!) would definitely give it much more visibility.

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions