The transactions property of the CREATE TABLE command in YCQL specifies if distributed transactions are enabled in the table. This property defaults to […]
Read MoreYSQL Function to Determine Data Type of Text
YSQL inherits from Postgres the built-in function pg_typeof function which returns the OID of the data type of the value that is […]
Read MoreGlobal Variables in YSQL
There are a lot of configuration parameters in YSQL that affect the behavior of the Yugabyte database system. The SHOW command in […]
Read MoreRepeatedly Run a Query Every X Seconds
The YSQLSH client includes a watch meta-command that repeatedly executes a query every n seconds. This is a handy feature if you […]
Read MoreColumn Level Public-Key Encryption in YSQL
The YugabyteDB YSQL API supports column-level encryption via the Postgres extension called pgcrypto. The pgcrypto module in PostgreSQL is a powerful tool […]
Read More