gsqlcmd Version History

Version 6.12, April 30, 2024

Bug fixes:

• Fixed issues with MySqlConnector and Npgsql data providers.

Version 6.11, April 29, 2024

Improvements:

• gsqlcmd supports curl header parameters like -H "header: value".

Version 6.10, October 10, 2023

Improvements:

• Updated providers: MySqlConnector, Npgsql, Oracle.ManagedDataAccess, and System.Data.SQLite.

Bug fixes:

• gsqlcmd does not read an SQL query from a file in the /table option.

Version 6.9, July 12, 2023

Bug fixes:

• gsqlcmd ignores the /cookie and /cookieFile options.
• The registration wizard does not display the names of the available languages.

Version 6.8, April 10, 2023

New features:

• gsqlcmd has a new mode to generate JavaScript and TypeScript seed files for Knex: make /knex
  The mode is similar to "make /insert"; however, it generates seed files instead of SQL commands.
  You may use the "knex" synonym instead of the "make /knex" command.
  You may use a new option, /truncate, to generate the truncate() method instead of delete().
  To generate TypeScript files, specify the *.ts file extension.
  To generate JavaScript files, specify the *.js file extension.

Improvements:

• gsqlcmd allows specifying MySQL objects without schemas. It uses the active connection database name in this case.

Version 6.7, February 21, 2023

Improvements:

• gsqlcmd uses the MySql.Data.MySqlClient data provider installed on the system.
  Prior, gsqlcmd used the provider shipped with the application.
  This solution allows installing and using the newest version of the provider:
  https://dev.mysql.com/downloads/connector/net/
• gsqlcmd dynamically replaces the missing MySql.Data.MySqlClient data provider with the built-in MySqlConnector provider.
• gsqlcmd reopens Snowflake connections automatically when tokens expire.

Bug fixes:

• gsqlcmd throws various exceptions when connecting to MySQL 8 using the MySql.Data.MySqlClient.

Version 6.6, January 23, 2023

Improvements:

• Updated .NET and .NET Framework data providers for Snowflake
• Updated the registration wizards (RegisterProduct for Windows and register for Linux)
• Updated AutoUpdate, dbsetup.exe, grx.exe utilities

Bug fixes:

• gsqlcmd removes leading and trailing spaces in CSV output.
• gsqlcmd may lose decimal precision when outputting data from databases to CSV.

Version 6.5, December 13, 2022

New features:

• gsqlcmd is available for .NET 6.0 for Linux and Windows.
• The gsqlcmd examples are released under the MIT license.

Version 6.4, October 19, 2022

Bug fixes:

• gsqlcmd formats decimal values in CSV format like 6E+09.00.

Version 6.3, October 13, 2022

Bug fixes:

• gsqlcmd formats integer values with two dots, such as 1..00.

Version 6.2, October 5, 2022

Breaking changes:

• gsqlcmd rounds output to four or two decimal places if it does not result in loss of precision.
  To disable the new mode, use the /noround option.

Bug fixes:

• gsqlcmd formats numeric values as text in some cases.
• The /DateTimeFormat option ignores date-only formats.

Version 6.1, August 17, 2022

Bug fixes:

• CSV based SQL commands contain an empty string value instead of NULL in the first line for empty string columns.
• gsqlcmd sometimes incorrectly defines quotes for CSV files in the output FMT file.

Version 6.0, July 5, 2022

A new major release has three new big features:

• gsqlcmd natively supports the Basic, Windows, Forms, OAuth1, OAuth2 authorization methods, contains a complete set of the required options, and allows acquiring the authorization interactively.
• SELECT queries from files and URLs support WHERE and ORDER BY clauses.
• An auto-update tool allows checking and installing software updates.

Changes in End-User License Agreement:

gsqlcmd includes an updated End-User License Agreement.

The most important change:

"Consent to Be Included in the Client List: By purchasing the software on behalf of your company, you implicitly consent to the listing of your company name as our customer. You can revoke this consent at any time by submitting a request."

New features:

• gsqlcmd includes the AutoUpdate tool to check and install gsqlcmd updates.
  gsqlcmd checks updates according to a customized scheduler.
  You can run the update tool manually using the AutoUpdate mode.
• gsqlcmd supports WHERE and ORDER BY clauses in SELECT queries from files and URLs.
• gsqlcmd uses the convert mode by default for inline SELECT queries from files and URLs.
• gsqlcmd supports the following authorization schemas with the Auth option: Auto, None, Basic, Windows, Forms, OAuth1, OAuth2, Custom.
  Use a new /interactive option to acquire authorization credentials in the interactive mode.
• gsqlcmd has new OAuth2-specific modes and options.
  Modes: get-authcode, get-token, refresh-token, and revoke-token.
  Options: /authorizationUrlFormat, /getTokenUrlFormat, /getTokenBodyFormat, /refreshTokenUrlFormat, /refreshTokenBodyFormat, /revokeTokenUrlFormat, /revokeTokenBodyFormat, /authorizationUrl, /getTokenUrl, /refreshTokenUrl, /revokeTokenUrl, /code, /validTo.
• gsqlcmd has new OAuth1-specific modes and options.
  Modes: get-authcode, get-token, and refresh-token.
  Options: /consumerKey, /consumerSecret, /callback, /requestTokenUrl, /authorizationUrl, /accessTokenUrl, /oauthToken, /oauthTokenSecret, /oauthSessionHandle, /oauthExpiresIn, /validTo.
• gsqlcmd supports user-defined options used in OAuth1 and OAuth2 authorization.
  For example, you can set values of the accounts-server option acquired from ZohoCRM to use the values in the /get_token_url_format and /refresh_token_url_format options.
• gsqlcmd has new /cookie and /cookieFile options especially useful with the Forms authorization.
• gsqlcmd has new /urlParameters and /authorizationHeader options used with the custom authorization.
  gsqlcmd adds URL parameters to a URL and sets the authorization header of the web requests.
  You can achieve the same result specifying an initial URL with the parameters and the header like /header=Authorization: <AuthorizationHeader>.
• gsqlcmd has a new /tokenFields option that explicitly allows specifying fields to save in the /tokenJson file.
• gsqlcmd has a new /serviceJson option designed to load service configurations from JSON or plain text files.
  You can split client, service, and token options across the files like /clientJson=client.json /serviceJson=service.json /tokenJson=token.json
• gsqlcmd has a new /acceptEncoding option with the default value: gzip, deflate.
• gsqlcmd reads the default values of the Accept and UserAgent headers from the gsqlcmd.exe.config file.
• Plain text option files can contain line comments starting with the # character.
• gsqlcmd shows the shortest help by default. Use /? to get more help and the help mode to get the full help.

Bug fixes:

• gsqlcmd outputs the last put options only from Yahoo Finance.