[storm] using odbc as a backend

[James Henstridge]

On Fri, Mar 6, 2009 at 12:21 PM, Jeremy R. Fishman <jfishman at bowdoin.edu> wrote:
>>  Has anyone done this? Any pointers?
>>
>> martin
>>
> Either of the two options above will _work_ for connections, but if
> there are any database-specific quirks there could still be issues.  See
> storm.databases.mysql for some examples.  There is an alternative
> Connection object (using Database.connection_factory), and alternative
> Result object (using Connection.result_factory), and some alternative
> compile functions (using Connection.compile and tagged with
> @compile.when(...)).
>
> Try a Database object and run the tests - I hope it works!

Note that there is database specific code for all three currently
supported databases, so it is very unlikely that a new backend could
be done without similar work.

This also means that a generic "pyodbc" backend is not on the cards:
it would depend on what database is actually being talked to.

It probably wouldn't be a huge effort to support PostgreSQL or MySQL
through pyodbc, but I'd guess that isn't what Martin is after.

There are backends for MS SQL and Oracle in development that might be
helpful, but neither has been merged.

James.