The translate() function in both PostgreSQL and YugabyteDB’s Postgres compatible YSQL API, does one-to-one translation of characters in a single operation. The […]
Read More
Reset Forgotten YSQL Admin User Password
Some 20 years ago I started a new job with a company in Pittsburgh as an Oracle DBA. The first task given […]
Read MoreEnable Storage Layer Logging to the YugabyteDB TServer Log
DocDB is the underlying document storage engine of YugabyteDB and is built on top of a highly customized and optimized version of RocksDB, […]
Read MoreShow Number of Rows Affected by an INSERT, UPDATE or DELETE
When you run a DML statement like an INSERT, UPDATE or DELETE, some number of rows are affected. Databases have various ways […]
Read MoreShow Number of Connections Per Node in YCQL from the Command Line
We saw in this previous tip how to display the number of YSQL connections per node from the command line. This is […]
Read More