Differences between revisions 16 and 17
Revision 16 as of 2013-02-17 11:39:25
Size: 3938
Comment: Fix formatting.
Revision 17 as of 2013-02-18 01:26:02
Size: 4002
Editor: jiangwen365
Comment:
Deletions are marked like this. Additions are marked like this.
Line 72: Line 72:
 Platforms:: Windows, Linux  Platforms:: Windows, Linux [[inux ODBC in 3 steps|Connect SQL Server on Linux in 3 steps]]

Microsoft SQL Server

URL

http://www.microsoft.com/sql/default.mspx

licence
commercial/proprietary software, although a free (gratis) edition "SQL Server 2008 R2 Express" is available
platforms
Windows 2000 and later

Pros

  • SQL Server is a robust and fully-featured database, and it performs very well. Moreover, I have not had any problems using this database with Python.
  • The SQL Server Express versions are free to download, use and can even be redistributed with products.

Cons

  • Windows only.
  • SQL Server comes in various flavours. The latest free version has a 10GB database size limit. It comes with the GUI tools and Reporting Services. The standard and other versions include many extra features.


DB API 2.0 Drivers

adodbapi

URL

http://adodbapi.sourceforge.net/

SourceForge

http://sourceforge.net/projects/adodbapi

licence
LGPL
platforms
Windows only

pymssql

URL

http://code.google.com/p/pymssql/

licence
LGPL
platforms
Windows and Unix

mssql

URL

http://www.object-craft.com.au/projects/mssql/

licence
BSD
platforms
Windows

mxODBC

URL

http://www.egenix.com/

License
eGenix.com Commercial License
Platforms
Windows, Unix, Mac OSX, FreeBSD, Solaris

mxODBC requires an ODBC driver to talk to SQL Server. On Windows, this comes with SQL Server, on the other platforms, there are several commercial ODBC high quality drivers available. There's also a FreeTDS ODBC driver which is free.

Unicode is supported both for data and SQL statements. mxODBC supports both 32-bit and 64-bit platforms.

pyodbc

URL

http://code.google.com/p/pyodbc

License
MIT
Platforms
Windows, Linux, MacOS X, FreeBSD, Solaris, Any (source provided)
Python versions
2.4 - 3.2

Actively maintained Open Source project.

Precompiled binaries are available for Windows. RedHat Enterprise Linux, Centos, and Fedora have precompiled RPMs available in their Extras repositories.

Supports ANSI and Unicode data and SQL statements and includes an extensive set of unit tests for SQL Server.

pypyodbc

URL

http://code.google.com/p/pypyodbc

License
MIT
Platforms

Windows, Linux Connect SQL Server on Linux in 3 steps

Python versions
2.4 - 2.7

One pure Python script, runs on CPython / IronPython / PyPy , Version 2.4 / 2.5 / 2.6 / 2.7 , Win / Linux , 32 / 64 bit. Almost totally same usage as pyodbc ( can be seen as a re-implementation of pyodbc in pure Python ). Simple - the whole module is implemented in a single python script with less than 3000 lines. Built-in Access MDB file creation and compression functions on Windows.

ODBC

It is possible to connect to an SQL Server database using ODBC, either the mxODBC driver or the one included with Win32all. However, this is not recommended - adodbapi is a better solution, in part because it supports unicode.

Comment: This is actually not true at all: ODBC is the native API used for SQL Server and does support Unicode all the way. In fact, ODBC is the preferred way of accessing SQL Server if you care for performance. Microsoft has just released the SQL Server Native Client which is an extended ODBC driver for SQL Server. ADO is just a layer on top of the ODBC interface and a lot slower as a result. See e.g. MS TechNet for a comparison of ODBC, OLE DB and ADO, or this cookbook entry.

Comment: Note about the comment above -- just because it should be pointed out, mxODBC is not a free product from what I can see, and the 'cookbook entry' from 2005 referenced above indicates that it is.

SQL Server (last edited 2017-08-07 19:32:49 by MaximilianFuxjaeger)

Unable to edit the page? See the FrontPage for instructions.