4 ms·
Nice! 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
by dmlittle 7y ago
Nice! 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.