PgDBF, Another XBase to PostgreSQL converter

From: Kirk Strauser <kirk(at)strauser(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: PgDBF, Another XBase to PostgreSQL converter
Date: 2008-07-24 23:38:12
Message-ID: AE6D7D6E-CCDF-4D5E-87E8-41256B1240FA@strauser.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

It'd been a couple of years since I wrote a program to convert some
random database to PostgreSQL, and it seemed like time to crank out
another one. The results, PgDBF, are available under the GPLv3 and
downloadable from http://honeypot.net/project/pgdbf .

Why yet another program to convert XBase databases in general (and
FoxPro in particular) to PostgreSQL? Because the other ones I found
were incomplete, complex, slow, or not available on Unix-like
systems. We needed something that could run hourly to keep our legacy
database in sync with our new production system, and the program we'd
been using (XBaseToPg: http://honeypot.net/project/xbasetopg) was a
hack on another program that was never meant to be abused that way.

Seriously, PgDBF is fast and simple. I profiled it, optimized,
profiled, optimized, and profiled again until I couldn't find anything
else to tweak. And yet its speed comes primarily through its
simplicity, so it should be very easy to maintain.

Give it a try. It runs on everything Unixy that I had available for
testing (including Linux x86, FreeBSD x86-64, and OS X PPC). I'm
pretty pleased with how this turned out.
--
Kirk Strauser

Browse pgsql-general by date

  From Date Subject
Next Message Klint Gore 2008-07-25 00:26:26 Re: [PERL DBI] Insertiing data across multiple tables
Previous Message SCassidy 2008-07-24 21:17:18 Re: [PERL DBI] Insertiing data across multiple tables