{"repo":"OndraZizka/csv-cruncher","free":true,"listed":false,"github":"https://github.com/OndraZizka/csv-cruncher","clone":"git clone https://github.com/OndraZizka/csv-cruncher.git","description":"Treats CSV and JSON files as SQL tables, and exports SQL SELECTs back to CSV or JSON.","language":"Kotlin","stars":59,"topics":["sql","csv","json","tool","etl","etl-automation","hsqldb","command","command-line-tool"],"license":null,"category":"databases-storage","readme_excerpt":"CSV + JSON Cruncher - query and process your CSV and JSON files using SQL. =================================================================== A tool which treats CSV and JSON files as SQL tables, performs SQL SELECT queries on them, and stores the result into CSV and JSON files. Many tools and systems can export their data to CSV . Typical work with these data is importing them into some spreadsheet like Excel and process them manually. Web services typically produce results as JSON arrays of objects. Reviewing them in JSON format is not too human friendly, and processing them using jq is quite complicated. With CsvCruncher, you can automate this processing by writing SQL queries, which produce another CSV or JSON as a result. The SQL operations can be quite powerful – just consider what everything you have at hand: Simple selects - ordering, filtering, grouping, aggregating, etc. Joins - use multiple CSV files and use their relations Subselects (pre-computing certain data for another select) Self-joins (same input file used multiple times) Recursive queries Triggers User-defined functions (PL/SQL-based and Java-based) XML and JSON processing Time and date functions Statistical agregate functions ...and more. All this is backed by HyperSQL database. See it's rich SQL syntax and features documentation. On top of that, CsvCruncher can: Convert CSV to JSON Convert JSON to CSV without any schema Aggregate input files in a directory structure (concatenate, intersect, merge, dedup","default_branch":null,"files":null,"tree":[],"storefront":"/r/OndraZizka","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/OndraZizka/csv-cruncher/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}