Releases: hyee/dbcli
Releases · hyee/dbcli
1.9.1
1.9.0
- pgsql : many enhancements including
desc
,xplan
,env autoplan/autoplanforma
t, 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
, launchdbcli.bat
ordbcli.sh
- for
pgsql
series includingopenGauss
, launchpgsql_dbcli.bat
orpgsql_dbcli.sh
- for
mysql
series includingTiDB
, launchmysql_dbcli.bat
ormysql_dbcli.sh
- on
Windows
, startconsole.bat
then gotoFile
->New tab
and choose which type of db to connect, default isoracle
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
andora 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
to19.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
1.8.1
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
andlist
- 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 tomysql
platform - supports
\g
(similar to;
) - supports
SSL
login help <SQL Command>
to viewMysql
offline document- enhancement on the
SHOW
command - rename some
dbcli
commands due to conflict withMysql
native client, those changes impactmysql
module only:
*set
->env
*print
->pri
, andprompt
->print
*host
->system
,
*tee
->write
, andspool
->tee