[DB-SIG] Python and static SQL

[Magnus Lycka]

This is a multi-part message in MIME format.
--------------339B6450505560C3C3AC66C6
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

This ODBC discussion made me think of something completely
different...

I haven't actually done a lot of measurements, but I've
often read that databases like Oracle and DB2 have much,
much better performance using static SQL, than they have
with dynamic SQL.

Is anyone using static SQL "with" Python?

What I mean is: Has anyone here built systems where they
do their database calls in C or C++ with embedded SQL,
basically placing their database IO in a C or C++ module?

If the performance claims are true this should be able to
boost performance a lot for standard calls. Lately I've
mainly been using SQL databases from Object-Oriented programs,
and there I think 90% of the accesses are simple CRUD (Create,
Retrieve, Update, Delete) operations, and it seems to me
that it would be fairly simple to write a little program that
would auto-generate the C or C++ code needed to make these
CRUD operations.


/Magnus
--------------339B6450505560C3C3AC66C6
Content-Type: text/x-vcard; charset=us-ascii;
 name="magnus.vcf"
Content-Description: Card for Magnus Lycka
Content-Disposition: attachment;
 filename="magnus.vcf"
Content-Transfer-Encoding: quoted-printable
X-MIME-Autoconverted: from 8bit to quoted-printable by texas.it-center.se id f1QHlSU14368

begin:vcard=20
n:Lyck=E5;Magnus
tel;cell:+46(0)705 82 80 65
tel;fax:+46(0)706 12 80 65
x-mozilla-html:FALSE
url:http://thinkware.se/
org:Thinkware AB
adr:;;Alvans vag 99, 1tr;Umea;;907 50;Sweden
version:2.1
email;internet:magnus@thinkware.se
title:SW Developer / Consultant
fn:Magnus Lyck=E5
end:vcard

--------------339B6450505560C3C3AC66C6--