Projects / pyxmdb

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
Licenses
Operating Systems
Implementation

Recent releases

  •  27 Apr 2009 15:49

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

    •  15 Feb 2009 17:42

      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.

      •  09 Jan 2009 14:59

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

        •  28 Aug 2007 03:33

          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.

          •  22 Aug 2007 07:11

            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.

            Screenshot

            Project Spotlight

            OpenStack4j

            A Fluent OpenStack client API for Java.

            Screenshot

            Project Spotlight

            TurnKey TWiki Appliance

            A TWiki appliance that is easy to use and lightweight.