David Ongaro

Results 56 comments of David Ongaro

I don't really know about CTEs but it seems their usecase which can not be achieved with subqueries is in recursive queries. If you don't need recursive queries you should...

I think the "UNIX" way would be to use the `LC_NUMERIC` environment variable? Python also has an API to access the corressponding settings: https://docs.python.org/2/library/locale.html#locale.localeconv. But maybe q should provide an...

You know `q` but don't know about `jq`!? ``` curl -s https://api.github.com/repos/harelba/q/releases/latest \ | jq -r '.assets[].browser_download_url | scan(".*deb$")' \ | wget -qi - ``` Seems simpler and less fragile.

I guess it's more a limitation of the CSV "standard" than of q? I don't think there is a common way of telling if a string value is supposed to...

@contentfree They are working, but depending on your shell you have to quote or escape them correctly (e.g. see https://github.com/harelba/q/issues/94#issuecomment-273985876)

> Single quotes for the query and double quotes for the filename-with-spaces didn't work. Still breaks on spaces in the filename. I'll double check tomorrow that my version is the...

Isn't that critique rather misdirected? To my understanding `q` is build on sqlite3, the python part is "merely" a wrapper. At the same time `q` doesn't try to do everything...

Did you overlook the `-O`/`--output-header` option?

The ticket rename still doesn't reflect what you mean, because paths starting with `~` are in fact absolute. (They only depend on the user you're logged in, not on what...

The solution is not `q` specific but works in general in UNIX like systems. Just combine with another tool, here `tr`: ``` $ echo "x,1;y,2;z,3" | tr ';' '\n' |...