github.com/mithrandie/csvq@v1.18.1/docs/index.md (about)

     1  ---
     2  layout: default
     3  title: csvq - SQL-like query language for csv
     4  ---
     5  
     6  ## Overview
     7  
     8  Csvq is a command line tool to operate CSV files. 
     9  You can read, update, delete CSV records with SQL-like query.
    10  
    11  You can also execute multiple operations sequentially in managed transactions by passing a procedure or using the interactive shell.
    12  In the multiple operations, you can use variables, cursors, temporary tables, and other features. 
    13  
    14  ## Latest Release
    15  
    16  Version 1.18.1
    17  : Released on Mar 26, 2023
    18  
    19    <a class="waves-effect waves-light btn" href="https://github.com/mithrandie/csvq/releases/tag/v1.18.1">
    20      <i class="material-icons left">file_download</i>download
    21    </a>
    22  
    23  ## Intended Use
    24  Csvq is intended for one-time queries and routine processing described in source files on the amount of data that can be handled by spreadsheet applications.
    25  
    26  It is not suitable for handling very large data since all data is kept on memory when queries are executed.
    27  There is no indexing, calculation order optimization, etc., and the execution speed is not fast due to the inclusion of mechanisms for updating data and handling various other features.
    28  
    29  However, it can be run with a single executable binary, and you don't have to worry about troublesome dependencies during installation.
    30  You can not only write and run your own queries, but also share source files with co-workers on multiple platforms.
    31  
    32  This tool may be useful for those who want to handle data easily and roughly, without having to think about troublesome matters.
    33  
    34  ## Features
    35  
    36  * CSV File Operation
    37    * [Select Query]({{ '/reference/select-query.html' | relative_url }})
    38    * [Insert Query]({{ '/reference/insert-query.html' | relative_url }})
    39    * [Update Query]({{ '/reference/update-query.html' | relative_url }})
    40    * [Replace Query]({{ '/reference/replace-query.html' | relative_url }})
    41    * [Delete Query]({{ '/reference/delete-query.html' | relative_url }})
    42    * [Create Table Query]({{ '/reference/create-table-query.html' | relative_url }})
    43    * [Alter Table Query]({{ '/reference/alter-table-query.html' | relative_url }})
    44  * [Cursor]({{ '/reference/cursor.html' | relative_url }})
    45  * [Temporary Table]({{ '/reference/temporary-table.html' | relative_url }})
    46  * [Transaction Management]({{ '/reference/transaction.html' | relative_url }})
    47  * Support loading data from Standard Input
    48  * Support following file formats
    49    * [CSV](https://datatracker.ietf.org/doc/html/rfc4180)
    50    * TSV
    51    * [LTSV](http://ltsv.org)
    52    * Fixed-Length Format
    53    * [JSON](https://datatracker.ietf.org/doc/html/rfc8259)
    54    * [JSON Lines](https://jsonlines.org)
    55  * Support following file encodings
    56    * UTF-8
    57    * UTF-16
    58    * Shift_JIS
    59  
    60    > JSON and JSON Lines formats support only UTF-8.
    61  
    62  ## Installation
    63  
    64  [Installation - Reference Manual - csvq]({{ '/reference/install.html' | relative_url }})
    65  
    66  ## Command Usage
    67  
    68  [Command Usage - Reference Manual - csvq]({{ '/reference/command.html' | relative_url }})
    69  
    70  ## Reference Manual
    71  
    72  [Reference Manual - csvq]({{ '/reference.html' | relative_url }})
    73  
    74  ## Execute csvq statements in Go
    75  
    76  [csvq-driver](https://github.com/mithrandie/csvq-driver)
    77  
    78  ## Example of cooperation with other applications
    79  
    80  - [csvq emacs extension](https://github.com/mithrandie/csvq-emacs-extension)
    81  
    82  ## License
    83  
    84  csvq is released under [the MIT License]({{ '/license.html' | relative_url }})