q icon indicating copy to clipboard operation
q copied to clipboard

q - Run SQL directly on delimited files and multi-file sqlite databases

Results 122 q issues
Sort by recently updated
recently updated
newest added

It's annoying to work with column names containing spaces because the backtick used for quoting is interpreted by the shell. It would be awesome if q was able to replace...

Steps to reproduce: ``` 1. git clone [email protected]:harelba/q.git 2. cd q/ 3. pip install -e . 4. cd ~ 5. q Traceback... ... ... No module named 'bin' ``` The...

I've just discover this utility and I am really impressed. It is so far the best utility I've found to play with csv. However, there is a small improvement which...

I may be missing something, but from my simple experiments so far this seems to work. If you'd be amenable to adding this, I'll be happy to add tests and...

want use cache feature on old centos 6.2 with glibc like 2.12. I had test q(3.1.6) with glibc 2.17 on CentOS 7.8. It works fine. so i have to scp...

![image](https://user-images.githubusercontent.com/25792424/155059995-7e63b46c-10dc-492c-ab8b-54021885b6f0.png) how can i slove it? os:ubuntu 20.04

CONTENT: ``` worthless C1 adjective worthwhile B2 adjective worthy C1 adjective would B1 modal verb ``` `q -t 'select count(distinct(c1)) from CEFR.txt where c2 = "C1"' ` result: 0

In case the source file is big, how about providing an option to enable temporary file based `sqlite`. I'm not sure if it is possible. Here are the related links....

:eyes: Some source code analysis tools can help to find opportunities for improving software components. :thought_balloon: I propose to [increase the usage of augmented assignment statements](https://docs.python.org/3/reference/simple_stmts.html#augmented-assignment-statements "Augmented assignment statements") accordingly....