Re: Reading csv files using SQL

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/py

Re: Reading csv files using SQL

[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, P

Re: Reading csv files using SQL

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

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. Thank

Reading csv files using SQL

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