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 MoreLists Functions Created by an Extension
We learned in a previous tip that we can ENABLE ORACLE’S COMPATIBILITY FUNCTIONS AND PACKAGES IN YSQL. That’s awesome! But what are […]
Read More