Thursday, July 21, 2005

MSSqlServer, Python and the *nixes

Okay, so here goes..
  • FreeTDS - Making the leap to SQL Server
    FreeTDS is a set of libraries for Unix and Linux that allows your programs to natively talk to Microsoft SQL Server and Sybase databases.
    apt known as: freetds-dev

  • SQSH - A swiss army knife command line interface to Sybase/SQL Server. A must-have program.
    Sqsh is much more than a nice prompt, it is intended to provide much of the functionality provided by a good shell, such as variables, redirection, pipes, back-grounding, job control, history, command completion, and dynamic configuration. Also, as a by-product of the design, it is remarkably easy to extend and add functionality.
    More Features
    apt known as sqsh

  • FreeTDS - Python Binding
    Shows how to install the python extensions. Seems as if it's being run used parallel to the FreeTDS installation. .
    Oops, there might be a little prob here: the TODO file from the source archive (2002 file) says blobs are unsupported... But that was back then, i'm not sure if they are supported right now...
    There is a file in there, that claims to be DB-API 2 compatible with a threadsafety level of 2: Threads may share the module and connection...
    All this is based on the 0.37 version. Carefully follow the installation instructions

  • SQL Relay
    SQL Relay is a persistent database connection pooling, proxying and load balancing system for Unix and Linux supporting ODBC, Oracle, MySQL, mSQL, PostgreSQL, Sybase, MS SQL Server, IBM DB2, Interbase, Lago and SQLite with APIs for C, C++, Perl, Perl-DBD, Python, Python-DB, Zope, PHP, Ruby, Ruby-DBD and Java, command line clients, a GUI configuration tool and extensive documentation. The APIs support advanced database operations such as bind variables, multi-row fetches, client side result set caching and suspended transactions. It is ideal for speeding up database-driven web-based applications, accessing databases from unsupported platforms, migrating between databases, distributing access to replicated databases and throttling database access.
    .... Additionally, SQL Relay can connect to Microsoft SQL Server or Sybase using a connection compiled against FreeTDS....
    apt known as sqlrelay

  • SQL Relay - python DB API
    Well. this is kinda obvious on one side..
    apt known as python2.3-sqlrelay

  • MSSQLServer with Zope. I'm not saying it is, but it might be interesting...
    The same applies for this one, which is even more and better documented - it includes some sample settings to bind FreeTDS to the MSSqlServer. (which in turn refers to this post... (which seems to be a work in progress))

This is what i have gathered after some hours of searching and reading. More info follows after some installation has succeeded. First i would need a place that would have MSSqlServer and a unix server close to each other :).
But that will be the case in a few days i guess.