PEP 305 - CSV File API

Ian Bicking ianb at colorstudy.com
Sun Feb 2 18:07:44 EST 2003


On Sun, 2003-02-02 at 15:55, Dennis Lee Bieber wrote:
>         Is anyone working on a csvDB module to plug on top <G> I've 
> encountered so many CSVs where the first row was column headers, and 
> all rows were similar (no variant field counts, etc.) that being able 
> to do something like:
> 
>         con = csvDB(file="some.csv")
>         cs = con.cursor()
>         cs.execute("select field1, field2 from place-holder where field3 = 
> 'Y'")
>         ...

The most practical way to do this would be a CSV loader for Gadfly or
SQLLite.  If you didn't want DBI compatibility (or really SQL
compatibility) then of course it would be considerably easier.

-- 
Ian Bicking           Colorstudy Web Development
ianb at colorstudy.com   http://www.colorstudy.com
PGP: gpg --keyserver pgp.mit.edu --recv-keys 0x9B9E28B7
4869 N Talman Ave, Chicago, IL 60625 / (773) 275-7241






More information about the Python-list mailing list