We learned in a previous tip that the YB_TABLE_PROPERTIES function can be used to display the number of tablets for a YSQL […]
Read More
Display the Number of Tablets for a YCQL Table
Yugabyte Cloud Query Language (YCQL) is a semi-relational SQL API that is best fit for internet-scale OLTP and HTAP applications needing massive […]
Read MoreReset YCQL Password as a Non-Authenticated User
If you try to reset a user password as a non-authenticated user in YCQL, you’ll get an error – even if logged […]
Read MoreMaintain a History of YSQL Commands
ysqlsh is a shell for interacting with the YugabyteDB YSQL API. By default, the commands that you type are kept in a […]
Read MoreBetter Performance on JSONB Data Value Search with a GIN Index
YSQL supports the JSON and JSONB data types which both can store JSON (JavaScript Object Notation) data. JSON stores an exact copy […]
Read More