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