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
Using 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 MoreList Tablet Details for a YCQL Table From the Command Line
YugabyteDB automatically splits YCQL user tables into multiple shards, called tablets, using a hash based strategy. You can see the tablets for a table via the […]
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