pgdbf
pgdbf copied to clipboard
Possibility to export to CSV?
pgdbf
is so fast! I would love to use it to convert Visual FoxPro DBF files to CSV. Any ideas? Thanks in advance!
Have you tried importing to PostgreSQL and exporting to CSV? Is that fast enough?
@TravisDart I guess I instinctively ruled that out as an option due to the extra overhead. However, thinking about it more now, the extra overhead might actually be worth it for the additional benefits of exporting the data as JSON as well and the ability to query the data.
I'm thinking I might be able to create a docker image that exposes a REST API that consumes a DBF and associated files (perhaps as a tarball) as well as some options for export and returns the relevant data... Will need to brainstorm this further...
Otherwise it would be super awesome if
pgdbf
was able to export to CSV/JSON directly. Unfortunately I've never written any C before but I'll have a crack at it.