blob: 44ee9b853908d4e8bc6713306d758072c9cec5a2 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
|
# q - Treating Text as a Database
## Change log
**Sat Jun 14 2014 Harel Ben-Attia <harelba@gmail.com> 1.4.0-1**
- 2.5x Speed improvement due to better bulk loading
- Output header support
- Additional control over query and output encodings
- Solved the following bugs/pull-requests:
- [#52](../../issues/52) - Bulk insert for better performance
- [#55](../../issues/55) - Use UUID to ensure temporary table names don't clash
- [#53](../../issues/53) - Allow easier tab-delimited output
- [#51](../../issues/51) - Ensure that generated temp tables are uniquely named
- [#50](../../issues/50) - Copyright peculiarities
- [#49](../../issues/49) - Add option to output fieldnames as headers
- [#48](../../issues/48) - PEP 8
- [#47](../../issues/47) - Prevent regexp from failing when field value is null
- [#41](../../issues/41) - Fix project folder structure
- [#32](../../issues/32) - Remove duplicated definitions, and PEP8-ing (tabs to spaces, etc.)
- [#29](../../issues/29) - RPM: Source0 should be a URL
- [#54](../../issues/54) - Fix query encoding (data encoding works well)
**Thu Mar 03 2014 Harel Ben-Attia <harelba@gmail.com> 1.3.0-1**
- Added column name and type detection (Use -A to see name/type analysis for the specified input)
- Added support for multiple parsing modes - Relaxed, Strict and Fluffy (old, backward compatible behavior)
- Fixed tab delimition parameter problem
- More improvements to error reporting
- Added a test suite, in preparation for refactoring
- Solves the following bugs/pull-requests:
- [#7](../../issues/7) - Dynamic column count support
- [#8](../../issues/8) - Column name inference from input containing a header row
- [#9](../../issues/9) - Automatic column type inference using sample data
- [#30](../../issues/30) - Header lines option does nothing
- [#33](../../issues/33) - Last column should allow for spaces?
- [#35](../../issues/35) - Add q.bat
- [#38](../../issues/38) - Problem with whitespace delimiter
- [#43](../../issues/43) - using the -t flag stopped the header flag from working
- [#44](../../issues/44) - Space in column name on TAB separated values break q
- Breaking changes:
- Changed -H behavior so it's now a flag an not a parameter (1 line always)
- Removed support for multi-char delimiters
**Sat Feb 22 2014 Harel Ben-Attia <harelba@gmail.com> 1.2.0-1**
- Support for quoted fields in CSVs
- Some bug fixes
- Improved error reporting
**Thu Feb 20 2014 Harel Ben-Attia <harelba@gmail.com> 1.1.7-1**
- Better error reporting
- Fixed python invocation for non stanard locations
- Added man page
**Tue Jan 7 2014 Harel Ben-Attia <harelba@gmail.com> 1.0.0-1**
- Initial version - tag was needed for homebrew formula
## Contact
Any feedback/suggestions/complaints regarding this tool would be much appreciated. Contributions are most welcome as well, of course.
Harel Ben-Attia, harelba@gmail.com, [@harelba](https://twitter.com/harelba) on Twitter
|
