SQL connection improvements · Issue #1662 · pandas-dev/pandas (original) (raw)

From pydata mailing list:

Been enjoying pandas, and using it some with SQL. I've posted a gist at git://gist.github.com/3164289.git with code that sniffs DataFrame types, creates a table if needed, and writes the dataframe to Sqlite, MySQL, Oracle, or PostgreSQL.

It is lightly tested -- used on a couple of ad hoc jobs so far -- and does not save or restore indexes, but hope you'll find it useful.