3 ms·
I made this because it came up too often that I had to process CSVs. I would write a quick ruby script for that, but ruby isn't really ideal for doing stuff lik
by jolmg 7y ago
I made this because it came up too often that I had to process CSVs. I would write a quick ruby script for that, but ruby isn't really ideal for doing stuff like joins and other things, so I wrote this.
- dmlittle 7y agoNice! As I was reading the title I thought to myself how this could easily be done by importing the CSV to SQLite and querying against it. This is exactly what you did but with a really clean and easy to use interface. This is awesome.
- jolmg 7y agoThanks. I haven't checked, but I'm hoping it would be simple to add support for using PostgreSQL and/or MariaDB/MySQL since I found that Sqlite doesn't support some constructs of SQL (I can't remember what they were). The big advantage of sqlite is the lack of static types for columns. I can just add numbers without explicitely typing a column as being numeric.
- theonemind 7y agoIt doesn't do right joins or full outer joins. It can do left joins and inner joins.
- oftenwrong 7y agoIf you have numbers in a text column you can simply cast it to a numeric type.