[DB-SIG] Databases chapter for Python on Windows book

Risney, Marc S msrisney@ingr.com
Wed, 30 Jun 1999 18:16:33 -0500

Andy, my ramblings...

Access , 97 and 2000, please!!, 
if you are writing specifically for win32, IMHO, most users/readers will at
some  point, most likely will be asked to develop using MS Access ,

one thing that you may want to experiment with (and I am just peeling back
the layers, with python and VB)
is that the office 2000 object library includes 
MSDE (as well as Jet, and DAO), which is the same database engine used in
SQLServer 7, essentially MS Access 2000 is  SQLServer 7 , with a 5 user

Also the format of the .mdb is different that preceding version (Access 97,
and 2.0), but there is an option to save and .MDB file as 
an earlier version.

working with Oracle,  Python is indispensable when I create  the load and
control files, in conjunction with SQL Loader for data loading.
my load files are essentially ASCII text files that range in size form 1 meg
to 2 gigs in size,
I have even built a Tk GUI for setting up my Control files,  

for loading objects I use Oracle Tools, I would love to use Python, but I
haven't the time to mess with Digital Creations Oracle module
That's a hint to Paul Everitt, I really would like instructions on how to
build the binary, or get a binary of their DCOracle module for win32.

This is Aaron Waters' "Electric LadyLand", I have turned on GIS departments
in Reston, VA to Python via Gadfly,
used primarily as casual notetaker application, the ability to move the
datafiles from platform to platform   (Sun Solaris to WInNT to VAX and
is exercised daily, as CAD digitizers analyze remote sensing data
(ok..satellite images)
take notes, writing to  a Gadfly datafile, that eventual are migrated into
an Oracle RDBMS.

to quote a senior engineer:
"I am amazed, a little RDBMS, that fits on a floppy, that writes data -
cross platform, that can be redesigned using MS Notepad, why would I wate
time with Java." 

this is a killer app, I have yet to see a Perl equivalent. please give it a
sidebar, I'm hoping that Aaron rev's it this fall, and add an ODBC.dll or
.pyd so that it can be accessed through ODBC on other applications on a

> -----Original Message-----
> From:	andy@robanal.demon.co.uk [SMTP:andy@robanal.demon.co.uk]
> Sent:	Wednesday, June 30, 1999 3:13 PM
> To:	db-sig@python.org
> Subject:	[DB-SIG] Databases chapter for Python on Windows book
> As some of you know, Mark Hammona dna I are putting the finishing
> touches to "Python Programming for Win32", due from O'Reilly this
> autumn.  I'm doing the database chapter.  I hope you'll forgive me for
> asking for answers I could probably dig out with a lot of research,
> but I have a load of other subjects to research too.
> The book needs to 'punch the right buttons' for corporate developers
> and IT managers and I am pushing the ideas of data cleaning and
> transformation scripts in Python.
> Q1.  I know the ODBC API and the Python DB API provide support for
> precompiled SQL statements.  What I don't know is which databases and
> drivers actually use these to get better performance.  Can anyone help
> out on this?
> Q2.  MySQL has quite a following.  Monty granted me a license on
> Windows for the sake of the book and I'd like to say something about
> it.  Unfortunately I have not yet found a compelling reason to use it
> for examples.  Is there anything neat that MySQL, or the Python
> interface to it,  does that cannot be do with (say) SQL Anywhere,
> which is just as cheap on Windows?
> Q3.  We like to include 'case studies' of half a page to a page to ram
> home the point that Python is in use in the real world.  Does anyone
> have any neat stories to tell or projects to boast about?  
> Many thanks,
> Andy Robinson
> _______________________________________________
> DB-SIG maillist  -  DB-SIG@python.org
> http://www.python.org/mailman/listinfo/db-sig