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


Release Notes: This release fixes a bug that was introduced in 0.6, which broke the support of "--sqlfile" for exports.


Release Notes: 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.


Release Notes: 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).


Release Notes: 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.


Release Notes: 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.