YugabyteDB is a transactional database that supports distributed transactions. A transaction is a sequence of operations performed as a single logical unit […]
Read More
Using the Translate Function in YSQL
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 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