5

By best, I mean most-common, easiest to setup, free. Performance doesn't matter.

Corey Trager
  • 21,997
  • 16
  • 80
  • 121
  • Duplicate: http://stackoverflow.com/questions/289978/whats-the-simplest-way-to-access-mssql-with-python-or-ironpython – S.Lott Mar 01 '09 at 01:01
  • 1
    Related, but not a duplicate, I think. The "from linux" in my question and the "or ironpython" in the other question makes these questions different. I need something I know will work on linux. – Corey Trager Mar 01 '09 at 01:39

5 Answers5

3

I decided that pyodbc was the best fit. Very simple, stable, supported:
http://code.google.com/p/pyodbc/

Corey Trager
  • 21,997
  • 16
  • 80
  • 121
2

pymssql, the simple MS SQL Python extension module.

Bill the Lizard
  • 386,424
  • 207
  • 554
  • 861
2

You may find this topic helpful:

What's the simplest way to access mssql with python or ironpython?

Community
  • 1
  • 1
Randolpho
  • 54,161
  • 16
  • 143
  • 176
  • 1
    The best answer for the other question is SQLAlchemy, an ORM layer. Yikes, I just want to run a couple of insert statements from a little python script. I don't need an ORM layer for that. – Corey Trager Mar 01 '09 at 13:34
  • Maybe you do, but don't know it yet. Don't build too much technical debt on your first iteration. – Randolpho Mar 02 '09 at 00:16
1

FreeTDS

mluebke
  • 8,170
  • 7
  • 33
  • 30
0

I'm just learning Python myself, but it seems like there are Python libraries that look more like Java JDBC drivers. Google found these articles about SQLObject and cx_Oracle.

duffymo
  • 299,921
  • 44
  • 364
  • 552