In YugabyteDB’s YSQL api, securing columns from users or providing access to only a limited set of columns can be implemented via […]
Read More
Add a Unique Key to a Materialized View
Materialized views in YSQL are relations that persist the results of a query. They can be created using the CREATE MATERIALIZED VIEW […]
Read MoreUpdate Current Rows When Adding a Column with a Default
A table column in YSQL can have a default value. If an INSERT statement does not specify a value for the column, […]
Read MoreEnforce Uniqueness Across Partitions (Option 1)
Partitioning is another term for physically dividing large tables in YugabyteDB into smaller, more manageable tables to improve performance. Because partitioned tables […]
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 More