usql v0.9.1

Point release: bug fixes and fully static builds.

• Updated all drivers to latest versions
• Fixed column alignment issues with the mysql driver
• Fixed logic to prevent panics in certain situations
• build-release.sh script updated to support fully
• Converted environment variable TIME_FORMAT to \pset time <format> variable, and fixed formatting issues

usql v0.9.0

New major features:

• Enabled autocomplete for \ commands (including files for \i, DSNs for \c, fields for \pset) and context-based completion for SELECT, UPDATE, INSERT, DELETE queries and variables
• Added a \copy command to copy data between different databases (local files are not supported yet)
• Added a \crosstab command
• Added a \G exec command that outputs in a vertical format (ala mysql)
• Added a \watch command
• PAGER support
• Added \o and \qecho commands to send output to files or pipe to other system commands
• Added the optional FILE argument to \g and \gx to send their output to a file or pipe to other system commands; the commands also support passing formatting options
• Support the unaligned, tuples_only, html and asciidoc output formats
• Context propagation and cancellation (CTRL+C) for in-flight queries

New Database Support:

• Netezza
• csvq - supports CSV, TSV, JSON and other flat files

Other fixes/improvements:

• Added a -G for vertical output (see \G above)
• Added a -q flag and associated QUIET environment variable to enable quiet output
• Implement the auto option for the \x command
• Fixed issues with escaped and other special characters when \set-ting variables
• The \begin transaction command now supports all of Go's transaction isolation levels, and read-only support
• \d updated to print relations, foreign keys, and other constraints for tables
• The \d* commands now provide more information and work better with some databases; they also do a better job of hiding system objects by default
• \d command support for the Snowflake database
• Now sets the ROW_COUNT variable for DML queries
• Fixes table titles

Notes:

• CONTRIBUTING.md has been updated with details on implementing \d* / autocomplete for other databases

usql v0.8.2

General release with:

• Bug fixes
• Native Go driver for Oracle now included by default (previous driver still available as godror)
• Added support for a number of experimental databases
• Minor enhancements to table output to better mimic psql
• Initial \d* and other meta/introspection commands

usql v0.7.8

Maintenance release:

• Updates driver dependencies
• Fixes propagation of statement configuration based on the driver for included scripts (\i, \ir, -f)

usql v0.7.7

Minor update from previous release, updating to fixed Vertica driver.

usql v0.7.6

Addition of Vertica database and updates to latest drivers/package dependencies.

usql v0.7.5

No substantial feature updates from previous v0.7.x builds; maintenance release, primarily updating third-party package dependencies.

usql v0.7.1

Point release, updates database dependencies, and fixes some minor issues.

usql v0.7.0

Release v0.7.0 fixes issues with syntax highlighting, initial support for Cassandra databases via CQL, and general code cleanup. The major changes:

• Cassandra (CQL) support
• Syntax highlighting fixes
• Added -v / --set command line parameter (compatibility with psql)
• Added "batch query" support for databases (ql + cql)
• Fixed issues with query prefix detection / parsing
• Switched from dep to vgo for dependency management

To install using the binary release:

• Download the archive (.zip or .bz2) for your platform (Windows, OSX, Linux)
• Extract usql from the downloaded archive and place somewhere in $PATH

To install on OSX via Homebrew:

# add tap
$ brew tap xo/xo

# install usql with "most" drivers
$ brew install usql

# install usql with oracle and odbc support
$ brew install --with-oracle --with-odbc usql

usql v0.6.0

Release v0.6.0 has some minor feature additions (syntax highlighting), and general code cleanup. A list of the major changes:

• Syntax highlighting
• Better compatibility with psql commands
• Homebrew support

To install on OSX via Homebrew:

# add tap
$ brew tap xo/xo

# install usql with "most" drivers
$ brew install usql

# install usql with oracle and odbc support
$ brew install --with-oracle --with-odbc usql