Reading csv files using SQL

[Pablo was Paolo]

Hi,
exists a Python library that allows to interface to csv files as if you 
manage a database, using SQL language?

Something like csvjdbc in Java, where table name is file name and the 
field's names are in first row.

Thanks!
Paolo
-- 
http://mail.python.org/mailman/listinfo/python-list

Re: Reading csv files using SQL

[Pablo was Paolo]

Hi,

Dennis Lee Bieber ha scritto:
>   You could maybe use SQLite to load the CSV file and process in an
> actual DBMS...

Ok, this is the solution I'm using actually (with PostGres).
My hope is to find a way to do the same thing without using a DBMS but 
working directly with the files.

Thanks a lot,
Paolo
-- 
http://mail.python.org/mailman/listinfo/python-list

Re: Reading csv files using SQL

[Pablo was Paolo]

Paul McGuire ha scritto:
> Sqlite has an in-memory option, so that you can read in your csv, then
> load into actual tables.

Thanks, this could be the perfect solution.

Paolo
-- 
http://mail.python.org/mailman/listinfo/python-list

Re: Reading csv files using SQL

[Pablo was Paolo]

[EMAIL PROTECTED] ha scritto:
> If you want to work directly with the files why not just use Python's csv
> module?

Now, with Java, I use the same class to read several databases and csv 
files (with SQL instructions).
I'd like to find a library for using the same approach in Python.

Thank you,
Paolo
-- 
http://mail.python.org/mailman/listinfo/python-list

Re: Reading csv files using SQL

[Pablo was Paolo]

Tim Golden ha scritto:
> I vaguely remember that you can get an ODBC driver for CSV.

There is a standard ODBC driver for use text file or csv, in windows.
But I use Linux on production servers.
I'd like to find a Python library or tool.

Thanks!
Paolo
-- 
http://mail.python.org/mailman/listinfo/python-list