PgDBF, Another XBase to PostgreSQL converter
От | Kirk Strauser |
---|---|
Тема | PgDBF, Another XBase to PostgreSQL converter |
Дата | |
Msg-id | AE6D7D6E-CCDF-4D5E-87E8-41256B1240FA@strauser.com обсуждение исходный текст |
Список | 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
В списке pgsql-general по дате отправления: