On Mar 24, 2006, at 8:41 AM, Ted Roche wrote:
The Python special Interest group of the GNHLUG met last night and
watched Ed's presentation at PyCon, MST3K fashion. A good time was
had by all.
Yeah, probably at my expense! ;-)
Ed mentioned during his presentation that dabo supported MySQL,
PostgreSQL, Firebird and SQLite, and that attempts had be made and
not yet completed to support Oracle and MS SQL. Ed cited problems
with MS SQL compatibility with access from platforms other than
Windows as a roadblock.
I don't know if this continues to be a major stumbling block for
folks, but a number of members were very interested in this point.
The older solutions used the Sybase TDS driver and attempts at the
ODBC layer. One of the participants cited Django going with pymssql
as their current interface. pymssql is GPL (although they are
looking at an LGPL license) and used the MS SQL DB-Library in C
rather than ODBC level calls, is up to version 0.7, and has been
tested on a variety of linuxes, BSDs, Solaris, OSX and WinXP
against MS SQL 2000 and 2006. If anyone is interested in developing
a dabo interface, you can find pymssql here:
http://pymssql.sourceforge.net/
I don't think the GPL license is a deal-breaker. It would just mean
that anyone needing that sort of connectivity would have to install
the connector themselves.
The last time I looked at pymssql, they said that OS X was not
working. I'm glad to see that they've made progress. Perhaps after my
self-imposed documentation period, I'll set up SQL Server 2000 (the
last version I have a license for) and test this out.
-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
