YugabyteDB automatically splits user YSQL tables into multiple shards, called tablets, using either a hash– or range– based strategy. You can see the Tablets […]
Read More
Enable Upsert Mode in YSQL
In YugabyteDB‘s YSQL API, a Primary Key constraint is a means to uniquely identify a specific row in a table via one […]
Read MorePitfalls of Adding a PK to an Existing Table in YSQL
Although it’s possible to add a primary key constraint to an existing table with the ALTER TABLE ADD CONSTRAINT command, it’s best […]
Read MoreExecute DDL Security Statements in YCQL
In the YugabyteDB’s YCQL API, DDL security statements are instructions for managing and restricting operations on the database objects. Examples: Create, grant, […]
Read MoreReduce a Table’s VARCHAR Size in YSQL
There might come a time where you’ll want to shrink the size of a VARCHAR field in a table. Example: yugabyte=# d […]
Read More