Trdsql is a command-line python application that execute SQL queries on flat data files like CSV, TSV, LTSV, TBLN and JSON files. It also allows exporting the outputs in several formats.

The application is written in Go language which known for speed and performance.

The reason why did we choose to write about trdSQL is that we used it in some tasks. It is proven to be a useful and reliable tool.

The trdsql supports both MySQL and PostgreSQL queries. It also can execute SQL queries from .sql files.

trdsql -q test.sql

The Trdsql tool is an advanced alternative for "q" which built with Python, and "textql" which allow executing SQL queries against structured CSV and TSV files. It supports more files format, different output options and process compressed and multiple files.

Highlights

  1. Supports multiple file formats
  2. Supports multiple output formats
  3. Multiple file inputs (not possible to mix different formats)
  4. Process compressed files: gzip, bz2, zstd, lz4, xz
  5. Compress output files
  6. Join table
  7. Join csv files
  8. Switch query driver (MySQL and PostgreSQL)
  9. Configuration file config.json
  10. It Can be used as Go language library.
  11. Process large files

Supported file formats

  1. CSV (Comma Separated Values)
  2. TSV (Tab Separated Values)
  3. LTSV (Labeled Tab-separated Values)
  4. JSON
  5. JSONL
  6. TBLN

Output formats

  1. Raw output
  2. ASCII Table output
  3. Markdown output
  4. The vertical format output

Install

The trdsql has different installation options

  1. Building the source with Go (requires go 1.13 or higher)
  2. Download and install binary releases for Linux, Windows and macOS from here.
  3. Use it within Docker container docker pull noborus/trdsql

License

The library is released as an open-source package under MIT license.

Resources

  1. https://github.com/noborus/trdsql
  2. https://github.com/harelba/q
  3. https://github.com/dinedal/textql

Medis: Medis is a beautiful, easy-to-use Mac database management application for Redis. (Free app)

Medis is a beautiful, easy-to-use Redis management application built on the modern web with Electron, React, and Redux. It's powered by many awesome Node.js modules, especially ioredis and ssh2. Features * Keys viewing/editing * SSH Tunnel for connecting with remote servers * Terminal for executing custom commands * Config viewing/editing * JSON/

Tad: Application for viewing and analyzing tabular data such as CSV files (Free app)

The Tad desktop application enables you to quickly view and explore tabular data in several of the most popular tabular data file formats: CSV, Parquet, and SQLite and DuckDb database files. Internally, the application is powered by an in-memory instance of DuckDb, a fast, embeddable database engine optimized for analytic

Bdash: Simple SQL Client for lightweight data analysis. (Free program)

Simple SQL Client for lightweight data analysis. Supported Databases * MySQL * PostgreSQL * Amazon Redshift * SQLite * Google BigQuery * Treasure Data * Amazon Athena Features * Run SQL queries * Save SQL queries * Draw charts * Share results Platforms macOS (Intel & Silicon) Windows, Lin

Mastering Data Manipulation with Python: A Comprehensive Guide to Reading and Writing Text, CSV, and JSON Files

In the ever-expanding world of data-driven decision-making, Python is a powerful tool, providing developers and data enthusiasts with many libraries and functions for manipulating data files. One of the most fundamental tasks in data handling involves reading and writing files, and Python offers a versatile and efficient way to tackle

Open Metadata: Discover, Manage and Collaborate on your Data

OpenMetaData is a comprehensive platform that offers a range of functionalities, including data discovery, data lineage, data quality, observability, governance, and team collaboration. It is an open-source project that has gained immense popularity among companies across various industry verticals, thanks to its vibrant community and adoption. OpenMetaData is built on

Swiple: Open-source Automated Data Monitoring

The data quality automation plugin for data teams. Experience data quality observability in your ELT/ETL pipeline that would usually take a year to build, in just a few hours.

DQO: Open-source Data Quality Operations Center

DQO is a powerful DataOps friendly data quality monitoring tool that is designed to help you monitor and maintain the quality of your data. With DQO, you get access to a wide range of customizable data quality checks and data quality dashboards that make it easy to keep an eye

formsflow.ai: Low-code Workflow RAD Platform for Enterprise

formsflow.ai is a low-code platform that helps build powerful business applications, quickly. It integrates open-source tools like form.io for forms, Camunda for workflows, Keycloak for security, and Redash for data analytics into a seamless and unified platform. Best of all, it's free!

Helical Insight CE: Open-source Business Intelligence (BI) Framework

Helical Insight is a revolutionary open-source business intelligence framework that can help you gain insights from one or multiple data sources, making it a versatile tool for your business needs. It offers a wide range of features that you would expect from any BI tool, be it open source or

22 Open-source Business Intelligence (BI) Dashboards

Business Intelligence, commonly known as BI, is the process of collecting, analyzing, and presenting data to make informed business decisions. BI helps organizations to transform their raw data into meaningful insights that can drive their business strategies. BI provides a range of advantages to organizations, including improved decision-making, increased efficiency,