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 MoreReset 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 MoreTurn Off YugabyteDB TServer INFO Message Logging
The YB-TServer service performs the actual input-output for end-user requests. It handles Data Manipulation Language (DML) statements such as INSERT, UPDATE, DELETE, and SELECT. YB-TServer actions […]
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 More