3 ms·

I suggest another approach: textql -query "select count(*) from persons.csv" ...because csv files are basically tables. This would also allow you to do joins

I suggest another approach: textql -query "select count(*) from persons.csv" ...because csv files are basically tables. This would also allow you to do joins on multiple files: textql -query "select p.name, c.name from persons.csv p inner join companies.csv c on p.companyid = c.id"

dinedal 13y ago
Author here: I like this idea! I will consider it, but a problem is that '.' is not allowed as a table name, without escaping brackets. May have to drop file-ext for it to work.
dinedal 13y ago
https://github.com/dinedal/textql/issues/6 https://github.com/dinedal/textql/issues/6