q
q copied to clipboard
harelba
q - Run SQL directly on delimited files and multi-file sqlite databases
Hello! I'm an avid user of q but have recently run into the following issue: When I'm using q on Windows 11 within PowerShell 7.2.9, special characters like Ä, ä,...
If one adjusts an output column width using -f (format) then -b (beautify) does not make the same adjustment with the -O header row as it does with the data...
Hello, If I want to use this library in Github Actions, how do I install it? Is it supported right now? Thank you
When I run q.exe: ``` The code execution cannot proceed because python38.dll was not found. Reinstalling the program may fix this problem. ``` I expected it to run without requiring...
When working with csv files in a folder that contains the equals sign "=", there is a failure. This change replaces the equal sign with the text.
q.py:535: DeprecationWarning: The default datetime adapter is deprecated as of Python 3.12; see the sqlite3 documentation for suggested replacement recipes `r = self.cursor.execute(q,params)`
q.py:1624: DeprecationWarning: datetime.datetime.utcnow() is deprecated and scheduled for removal in a future version. Use timezone-aware objects to represent datetimes in UTC: datetime.datetime.now(datetime.UTC). now = datetime.datetime.utcnow().isoformat() Python 3,12
Hi, it is a very nice tool for me. But some of file lines of json string, any plan to support json format file ? For example: ``` {"time": "2006-01-02...
It seems like [DuckDB](https://duckdb.org) can also work as an ad-hoc csv analysis tool. ``` $ cat > q.csv a,b 1,2 3,4 5,6 $ duckdb -csv -c 'select a,b,a*b from q.csv...
