[Monetdb-developers] Python + SQL

Arjan Scherpenisse A.C.Scherpenisse at cwi.nl
Wed Apr 21 15:06:19 CEST 2004


I have fixed the Mapi.py thanks to Niels' tips. The result strings still 
need parsing ofcourse. I could write my own parsing or write wrappers 
for the existing Mapi.h API.

I am willing to implement a Python database wrapper according to the 
Python Database API specs (http://www.python.org/peps/pep-0249.html).

Maybe we can talk about this tomorrow with Peter, and how something like 
this can fit into my graduation work ;)

regards, Arjan

Martin Kersten wrote:
> Arjan,
> It supprises me, because the Mapi protocol does not constrain the 
> language. I noticed, though, that MapiClient.py is currently hardwired
> for mil indeed. It seems that Sjoerd (the Python expert) can help
> you (and make MapiClient.py a little better?)
> The main question to decide upon is the functionality required.
> Using ODBC would allow your application also to run on other DBMSs
>  From the perspective of re-use that is a nice property. Ofcourse,
> the application builder has to spent more energy to prepare for this.
> Using the ODBC layer of Sjoerd would be a good exercise to challenge
> its current functionality. Help is close at hand to make it bearable.
> Perhaps an issue to discuss with Peter (and me).
> regards, Martin
> Arjan Scherpenisse wrote:
>> Hello,
>> can someone point me to a simple way of using the SQL frontend from 
>> within Python? The default interface (Mapi.py) does only allow the MIL 
>> language, as far as I can see.
>> In the past I did it by using the ODBC module, but that was very 
>> tiresome. Is there a better way?
>> cheers, Arjan
>> -------------------------------------------------------
>> This SF.Net email is sponsored by: IBM Linux Tutorials
>> Free Linux tutorial presented by Daniel Robbins, President and CEO of
>> GenToo technologies. Learn everything from fundamentals to system
>> administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
>> _______________________________________________
>> Monetdb-developers mailing list
>> Monetdb-developers at lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/monetdb-developers

Arjan Scherpenisse

Centrum voor Wiskunde en Informatica,
Amsterdam, the Netherlands

More information about the developers-list mailing list