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

usql v0.5.0

Compatibility fixes! Now almost equal to psql for the major features (variables, passwords, etc), and some major code organization/documentation overhauls. Included in this release:

• Variables working
• Parameters to backslash commands now correctly evaluated
• Added \password command (for PostgreSQL, MySQL, Oracle, and SQL Server drivers)
• Added \set, \unset, \prompt commands for working with variables
• Fixed \gset and \gexec commands
• Fixed \! command
• Added -1 / --single-transaction command line option
• Added \begin, \commit and \rollback commands for working with transactions
• Fixed logic for ~ in paths
• Added support for a .usqlpass file, similar to PostgreSQL's .pgpass. Please see contrib/usqlpass for example file
• Various code and documentation cleanup
• Minor logic/bug fixes for command execution

Plus more. Stay tuned for more -- Google Spanner is coming Very Soon™

usql v0.4.0

Significant updates to meta command handling, including improved help / support as well as a massive retooling of how drivers are built/supported.

• .usqlrc support
• Now prompts for a password on connect, as well as psql compatible -w and -W cli options
• \i and \ir and their \include and \include_relative variant meta commands have been fixed
• Better meta command help
• Issues with database URLs fixed
• Output issues on Windows fixed
• Standardized/better driver error messages
• Additional psql compatibility command line options, meta commands
• Drivers can now be included using go build -tags <driver> or, alternatively, excluded using go build -tags no_<driver>
• Additional build tags all and most added (most is same as all, but excludes the cgo drivers odbc and oracle)

usql v0.3.0

Another general release, adding:

• Support for more databases (mymymsql, pgx, others)
• New meta command \connect_dsn to directly type a DSN
• Other meta commands
• Proper handling of file paths for Unix domain sockets for postgres and mysql drivers

Plus much much more!