Recent searches
Search options
Looking forward to #DFD2025. What #FLOSS tools do you use to read #CSV files? Any FOSS #ETL tools to copy CSVs to/from databases? Is there a #Free, #OpenSource ODBC driver for connecting to CSV files?
#AskFedi #AskFediverse #DFF
Seher Taak 
@dff I am using Visidata regularly. Also go-awk can be recommended since it has an csv input mode.
@dff i like R and magrittr a lot and dplyr is really good for abstracting database specifics while manipulating data declaratively. not familiar with ODBC
@dff I came across a review of such software the other day by the venerable @jhpot: https://flipboard.com/@lifehacker/all-the-latest-tech-news-reviews-hacks-v5n1o0l4z/-/a-dlz41v6qSG-VCk3bo8-9Ow%3Aa%3A1938850876-%2F0
@dff I'm currently adding CSV support to an ETL tool I'm writing. I decided to use ODBC and a CSV/text driver to access the CSV files because it lets me treat the CSV files very similar to how I treat the databases I connect with. I've tried both unixODBC and iODBC with my programs. Windows comes with ODBC support and a text driver. Looking for a CSV driver for Linux and AIX now.
@dff Searching the #unixODBC site, it looks like there was a text/#csv #ODBC driver called #SQI with LGPL license. I'm not seeing the code in the latest version of unixODBC even though the driver is listed at their site. However, much older versions of unixODBC had a txt subdirectory under Drivers with the code. Wonder if anyone's using this driver and how hard it would be to get it built and working. #AskFedi #AskFediverse