pyxmdb
pyxmdb is a database utility for exporting and importing data between a delimited text file (e.g. CSV) and virtually any DBMS. It has been tested with SQLite, MySQL, PostgreSQL, Oracle, and DB2. It supports running SQL statements before and after performing the import or export. Also allows for any of the SQL statements to be read from a file or provided on the command line. It supports reading and writing of compressed files, in addition to standard input and standard output.
| Tags | Database Front-Ends Utilities |
|---|---|
| Licenses | GPLv2 |
| Operating Systems | OS Independent |
| Implementation | Python |
Recent releases
- 27 Apr 2009 16:40
Changes: This release fixes a bug that was introduced in 0.6, which broke the support of "--sqlfile" for exports.
- 15 Feb 2009 17:42
Changes: Major updates and improvements to the code, but no new functionality. This is partially in preparation for some new features that will be coming soon.
- 09 Jan 2009 14:59
Changes: This release adds code to allow the use of text files containing SQL statements to be used for the pre/post/main SQL commands (refer to the --presqlfile, --postsqlfile, and --sqlfile parameters for more information).
- 27 Aug 2007 20:33
Changes: You can use STDIN/STDOUT instead of a filename, can choose your own default DBMS, and can import/export gzip and bzip2 compressed files. This release has full support for all of the CSV formatting options including a new "dialect" option, and new --presql/--postsql parameters for running an SQL command before or after the main SQL. Some old parameters that were no longer required have been removed.
- 22 Aug 2007 00:11
Changes: A bug with the default logging format string was fixed. Python 2.4 would generate an exception when %(funcName)s was used from the "main" part of the program. Support for Ingres (ingresdbi) was added to the configuration file. Users may now choose which DBMS module they wish to use as a default in the [dbms] section of the configuration file. The default is initially set to sqlite3. The dbserver no longer defaults to localhost.
