1.9.1

• some command enhancements on tidb, mysql and pgsql
• misc fixes

1.9.0

• pgsql : many enhancements including desc, xplan, env autoplan/autoplanformat, misc scripts
• mysql : many enhancements including info, xplan, env autoplan/autoplanformat, misc scripts
• some other fixes and script enhancements

To connect to the database:

• for oracle, launch dbcli.bat or dbcli.sh
• for pgsql series including openGauss, launch pgsql_dbcli.bat or pgsql_dbcli.sh
• for mysql series including TiDB, launch mysql_dbcli.bat or mysql_dbcli.sh
• on Windows, start console.bat then goto File->New tab and choose which type of db to connect, default is oracle

1.8.6

• oracle: new script 'ora xplan'
• public: new command 'clip' to copy output into clipboard (unsupported in ssh terminal)
• oracle: new script 'show features'
• oracle: new script 'ora sqlset'
• oracle: new script 'sys listdir'
• oracle: new script 'ora spm/awrio'

• public: support JDK 9+
• update lib LuaJIT
• misc script changes and fixes

1.8.5

• new scripts adb list/view/delete/copy/move/unload/ddl/patch/switch/trace for Oracle Autonomous Database
• new settings set credential/bucket for Oracle Autonomous Database
• new scripts show userenv/acl/hwm and ora markhot
• supports <?|&>proxy=<host>:<port> as database connection string as HTTP/Socks5 proxy
• misc script enhancements and fixes

1.8.4

• oracle: new scripts ora gather/spa/idn
• oracle: new scripts show slowsegs
• oracle: new script sys xplan
• oracle: enhancements on ora stats/sta/actives
• oracle: downgrade lib ojdbc8.jar to 19.5 to support 11g
• oracle: other script enhancements, performance improvements and fixes
• public: performance optimize & bug fixes on lib JNLuaJIT
• public: misc fixes

1.8.3

• supports MacOS M1, relies on Java1.8 such as Azul release(https://www.azul.com/downloads/?package=jdk)
• update libs jnlua(bugfixes), lpeg(1.0.2), jna(5.1),jansi(2.4),LuaJIT, luv(1.43) to support M1
• new command 'expr' for math calculation
• misc fixes and script enhancements

1.8.2

• oracle: new scripts pdb metric,show iotwrite and exa unalign
• update libs luajit and luv
• misc fixes and script enhancements

1.8.1

• oracle: new script exa nsmtio
• oracle: new script ora awrextr/awrload
• mysql : new script ti usages/timing
• somes fixes and enhancements mainly for oracle

1.8

• upgrade libs: jansi => v2.3.3(jar name keeps unchanged), jna => v5.8, jline => v3.20, ConEmu => v210620, NuProcess => v2.0.2
• improves the command auto-completion
• supports \G to show print query result vertically
• many improvements for mysql database, including:
  • command auto-completion
  • support TiDB
  • command info [<schema>.]<object_name> [ddl] to show more detail/ddl of an object
  • command sets: ps, ti and list
  • scripts ps actives/topsql
  • scripts list buffstats/optenvs
  • scripts ti topsql/slows/cluster/locks/actives/qps
  • scripts sql obj/cols/search
  • shell script mysql_dbcli.sh to auto-switch to mysql platform
  • supports \g (similar to ;)
  • supports SSL login
  • help <SQL Command> to view Mysql offline document
  • enhancement on the SHOW command
  • rename some dbcli commands due to conflict with Mysql native client, those changes impact mysql module only:
    * set -> env
    * print -> pri, and prompt -> print
    * host -> system,
    * tee -> write, and spool -> tee

1.7.9

• new command ora lfs
• new command show autotask
• enhancement on extracting SQL Detail and SQL Monitor report in text format
• upgrade lib ConEmu to 210128
• misc fixes and small enhancements