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 MoreUsing an Emoji in Place of NULL in YSQL
The pset meta-command in ysqlsh can be used to display an alternative value for NULL, which shows up as blank by default. […]
Read MoreAvoid Upsert in YCQL
By default, inserts into a YCQL table overwrite data on primary key collisions. So INSERTs do an UPSERT. This an intended CQL […]
Read More