In YSQL the column constraint GENERATED ALWAYS AS IDENTITY allows you to automatically assign a unique number to a column. Example: yugabyte=# […]
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 MoreYet Another Way to View the Postgres/YugabyteDB Version in YSQL
We learned in several earlier tips how to display the version of YugabyteDB. Example: Display YugabyteDB Version For fun, here are few […]
Read MoreCreate a Secondary Index on a Collection in YCQL
YCQL supports collection data types to specify columns for data objects that can contain more than one value. These include the following data […]
Read MoreMore Secure Method to Avoid Typing Your Password in YSQL
The YugabyteDB SQL shell ysqlsh provides a CLI for interacting with YugabyteDB using YSQL. There is not a flag available on the command […]
Read More