There are a lot of configuration parameters in YSQL that affect the behavior of the Yugabyte database system. The SHOW command in […]
Read More
Repeatedly 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 MoreDisplay Session Count on Each Node of a YSQL Database
As highlighted in Distributed PostgreSQL on a Google Spanner Architecture – Query Layer, YSQL reuses the open source PostgreSQL query layer (written in […]
Read More