Harelba Q Versions Save

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

1.5.0

9 years ago
  • Full input/output support for double-quoting fields with delimiters
  • Multiple query support in one command line, reusing previously loaded data in subsequent queries
  • Support literal SELECT statements (e.g. SELECT 5+12.5/3)
  • Full code restructuring (Internally working now using a full python API which will become public in the next version)
  • Added sha1 function. You can use 'select sha1(c3) from ...'
  • Solved the following bugs/pull-requests:
    • #10 - Reuse of previously loaded data when running multiple queries in one command line
    • #64 - Full support for literal SELECT statements without a table (e.g. SELECT 5+12.5)
    • #56 - Proper double quote handling, including multiline fields, for both input and output according to csv standards
    • #69 - Added warning suppression when the user provides a specific column count
    • #40 - Code restructuring cleaning, creating a full python API (will be published in the next version)
    • #60 - Fixed RPM packaging
    • #68 - UTF-8 with BOM files cause column naming issues
    • #63 - Unicode string support in regexp function