On Monday 04 February 2008 07:39:06 pm Omer Zak wrote: > I noticed that to access MS-SQL databases, Dabo uses the pymssql module. > Is it possible to add another backend, which uses the pyodbc module? > > While it may be slower, it has the following advantages: > > 1. It passes Unicode strings intact, without coercing them to a 8-bit > encoding (this is a deal-breaker for using Dabo in a project on which I > am working). > (see: > http://www.zak.co.il/tddpirate/2007/12/25/choosing-a-python-module-for-acce >ssing-microsoft-sql-server-unicode-data/) > > 2. It is supposed to allow you to access all DBs available in the > MS-Windows platform. > > I am very new to the Dabo source code, but I am willing to hack together > an pyodbc using backend if someone is willing to hand-hold me and tell > me exactly what files I should add/modify, and then review my > contribution before committing it to the repository. > > Thanks, > --- Omer
To my knowledge pymssql passes the unicode correctly because Dabo converts everything to unicode. If I'm wrong someone please correct me! However, if you wish to write a backend for pyodbc I'm sure we can help. First make sure pyodbc conforms to DBAPI 2.0. If that's true (I think it is from the website info) - then you can follow the structure of dbPostgres, dbMySQL, or dbFirebird. After you review the files you can ask questions. However, I did not see any statements about the module being cross-platform? If the module is not cross-platform I doubt that it will be included as the preferred ms-sql module. For this type of work it is best that you download Dabo via SVN. See the Dabo download page. I assume you are using windows. Your best bet is to install TortoiseSVN. Have no fears - you can do this! -- John Fabiani _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev Searchable Archives: http://leafe.com/archives/search/dabo-dev This message: http://leafe.com/archives/byMID/dabo-dev/[EMAIL PROTECTED]
