2 Dec 15:01
Future for Python driver
Hi all, Those who attended my "Python drivers" session at conference in Luxembourg already know that last two months I have worked on another Python driver for Firebird (codename fdb). It was just an experiment how far I could go in short time with another approach to implementation, not real attempt to replace both existing drivers (KInterbasDB and firebirdsql). However, it went so well, that we have a real chance to get out a truly universal pure Python driver for Firebird next year. Here are details... The *fdb* driver is based on my old experiments (back in 2009) with ctypes interface to Firebird. Back then it ended with ibase.py interface and very basic connection and transaction classes, and ability to make a connection and start a transaction. Over last month I was able to implement full DB API 2.0 Spec + some extra. - Connection, including drop and create database - Transaction, incl. multiple transaction per connection, transaction parameters, savepoints and retaining. - Cursor. Fully supports materialized BLOBs, input parameters (incl. BLOBs), should handle dialect 1 gracefully (but it wasn't thoroughly tested), has row mappings and iterator protocol support built-in, automatic unicode/connection charset conversions. - Services. All what KInterbasDB 3.3.0 supports (i.e. all except TRACE). What is missing: - Prepared Statements (some work done, but unfinished). - db_info API calls(Continue reading)
RSS Feed