sq is a command line tool that provides jq-style access to structured data sources: SQL databases, or document formats like CSV or Excel. It is the lovechild of sql+jq.
Last Releases
- v0.48.5Fixed #446: A bufio.ErrTooLong was being returned by bufio.Scanner, when splitting lines from input that was too long (larger than bufio.MaxScanTokenSize, i.e. 64KB). This meant that sq wasn’t able to parse large JSON files, amongst other problems. The maximum buffer size is now configurable via the new tuning.scan-buffer-limit option. Note that the buffer will start… Read more: v0.48.5
- v0.48.4Changed Updated Go dependencies (was failing some security vulnerability scans). Source: https://github.com/neilotoole/sq/releases/tag/v0.48.4
- v0.48.3Small bugfix release. Fixed #415: The JSON ingester could fail due to a bug when a JSON blob landed on the edge of a buffer. The JSON ingester wasn’t able to handle the case where a post-sampling JSON field had a different kind from the kind determined by the sampling process. For example, let’s say… Read more: v0.48.3
-
Common Issues When Installing Sq Locally: Troubleshooting and Solutions
Local installations of data tools like Sq empower developers to test, configure, and deploy processes in a controlled environment. However, the setup process for Sq can sometimes be challenging due to configuration dependencies, compatibility issues, and various environment-specific requirements. This guide identifies common issues and provides actionable solutions based on expert insights from Stack Overflow…
-
How to Install Sq Locally
Installing data tools locally is invaluable for developers and data engineers who need to test, develop, and troubleshoot without relying on cloud resources. Local setups allow for rapid iteration, experimentation, and offline work—advantages particularly useful for exploring new tools in a controlled environment. This guide covers installing Sq, a versatile data processing tool, using popular…