trdsql

CLI tool that can execute SQL queries on CSV, LTSV, JSON and TBLN. Can output to various formats. CLI tool that can execute SQL queries on CSV, LTSV, JSON and TBLN. It is a tool like q, textql and others. The difference from these tools is that the syntax of PostgreSQL or MySQL can be used. Please refer to godoc and _example for usage as a library. Download binary from the releases page(Linux/Windows/macOS). Pull the latest image from the Docker hub. The filename of -out filename option determines the output format(csv, ltsv, json, tbln, raw, md, at, vf, jsonl) and compression format(gzip, bz2, zstd,lz4, xz) by guess.

Features

JSON can contain structured types, but trdsql is stored as it is as JSON string
CSV format for output. (default)
Pull the latest image from the Docker hub
Download binary from the releases page(Linux/Windows/macOS)
Guess by output file name
ASCII Table & MarkDown output

Project Samples

Project Activity

See All Activity >

License

MIT License

Follow trdsql

trdsql Web Site

Other Useful Business Software

99.99% Uptime for MySQL and PostgreSQL Databases

Sub-second maintenance. 2x read/write performance. Built-in vector search for AI apps.

Cloud SQL Enterprise Plus delivers near-zero downtime with 35 days of point-in-time recovery. Supports MySQL, PostgreSQL, and SQL Server.

Try Free

Rate This Project

User Reviews

Be the first to post a review of trdsql!

Additional Project Details

Operating Systems

Linux, Mac, Windows

Programming Language

Related Categories

Go Frameworks

Registered

2023-02-03

Similar Business Software

ADO.NET Data Providers

dotConnect is an enhanced data connectivity solution built over ADO.NET architecture and a development framework with a number of innovative technologies. dotConnect includes high-performance data providers for the major databases and popular cloud applications and offers a complete solution for...

See Software
Webix

JavaScript UI library and framework for speeding up web development. JS Framework for cross-platform web Apps development 102 UI widgets and feature-rich CSS / HTML5 JavaScript controls. Save at least 3000+ development hours by using ready-made widgets and UI controls. Develop Web UI 30% faster....

See Software
Tekton

Tekton is a cloud-native solution for building CI/CD systems. It consists of Tekton Pipelines, which provides the building blocks, and of supporting components, such as Tekton CLI and Tekton Catalog, that make Tekton a complete ecosystem. Tekton standardizes CI/CD tooling and processes across...

See Software
Alpine.js

Alpine is a rugged, minimal tool for composing behavior directly in your markup. Think of it like jQuery for the modern web. Plop in a script tag and get going. Declare a new Alpine component and its data for a block of HTML. Dynamically set HTML attributes on an element. Prevent a block of...

See Software
Ruby on Rails

Over the past two decades, Rails has taken countless companies to millions of users and billions in market valuations. Over six thousand people have contributed code to Rails, and many more have served the community through evangelism, documentation, and bug reports. Rendering HTML templates,...

See Software
Helidon

Helidon is a cloud-native, open‑source set of Java libraries for writing microservices that run on a fast web core powered by Netty. Helidon Níma is the first Java microservices framework based on virtual threads. Helidon is designed to be simple to use, with tooling and examples to get you...

See Software