I don't think it is wrapped, which makes sense since both the win32all
odbc and mxodbc extensions are well known/supported. Is there something
that those packages don't do that you need?
I don't know Rahl's reasons, but mxODBC is encumbered by a
commercial licence which makes it problematic for me in some
situations (such as right now), and the old odbc module in
win32all is as far as I know neither maintained nor updated
to DB API 2.0.
Is wxODBC available on Linux? That would give it a big advantage
over the win32all module.
On Windows, I usually use adodbapi, but it's not a perfect
solution. It's kind of a wrapper over a wrapper over a wrapper...
There are other alternatives to odbc depending on the database; if
you are using Postgresql, for example, pyscopg provides better speed
and capabilities than odbc. It's available for Windows, too (don't recall
about Macs).
HTH --
-frank
···
On Wed, 3 Dec 2003, Magnus Lycka wrote:
Roach, Mark R. wrote:
> On Tue, 2003-12-02 at 16:12, Rahl wrote:
> > Is it possible to use wxODBC with Python?
>
> I don't think it is wrapped, which makes sense since both the win32all
> odbc and mxodbc extensions are well known/supported. Is there something
> that those packages don't do that you need?
I don't know Rahl's reasons, but mxODBC is encumbered by a
commercial licence which makes it problematic for me in some
situations (such as right now), and the old odbc module in
win32all is as far as I know neither maintained nor updated
to DB API 2.0.
Is wxODBC available on Linux? That would give it a big advantage
over the win32all module.
On Windows, I usually use adodbapi, but it's not a perfect
solution. It's kind of a wrapper over a wrapper over a wrapper...
I don't know Rahl's reasons, but mxODBC is encumbered by a
commercial licence which makes it problematic for me in some
situations (such as right now), and the old odbc module in
win32all is as far as I know neither maintained nor updated
to DB API 2.0.
Is wxODBC available on Linux? That would give it a big
advantage over the win32all module.
On Windows, I usually use adodbapi, but it's not a perfect
solution. It's kind of a wrapper over a wrapper over a
wrapper...
Is ODBC even necessary, when we can just interact with Python's
DB API directly?
Actually, more accurately (if I understand it completely) I
should say that we can interact directly with the Python
drivers for MySQL, PostGres, MS-SQL, Oracle, etc. etc. As long
as the drivers comply (more or less) with the the DB API it
should work fine and without the need for the ODBC wrapper
which can be a bitch to install and maintain on an end-user's
system (especially if you are deploying multi-platform apps),
and which performs much worse than just interacting directly
with the Python drivers.
I am also trying to avoid non-liberal licenses, which is one of
the main reasons I'm using wxPython instead of PyQt in the
first place. mxODBC would be a problem for me as well.
On Windows, I usually use adodbapi, but it's not a perfect
solution. It's kind of a wrapper over a wrapper over a wrapper...
A Python wrapping of wxODBC would be the same. But as I've mentioned recently on wxPython-dev, if somebody does the work or creating the wrappers, agrees to maintain it and answer quesitons about it on the mail list, then I'll include it in the distribution. There is at least one person who was interested in doing this, so maybe there can be some colaboration...
···
--
Robin Dunn
Software Craftsman http://wxPython.org Java give you jitters? Relax with wxPython!