YugabyteDB consists of 3 primary applications: yb-master(master), yb-tserver(tserver) and postgres. Yb-master and yb-tserver use the gFlags for managing configurations and feature flags. […]
Read MoreOverride SERIAL Column Default Value in YSQL
Columns that have a SERIAL data type are auto-incremented. YugabyteDB supports SMALLSERIAL, SERIAL, and BIGSERIAL which are short notation for sequences of […]
Read MoreChoose Whether Transaction Tablet Leaders Respect Preferred Zones
Being a distributed SQL database, YugabyteDB automatically splits the data in a table and distributes it across nodes. This is known as […]
Read MoreGenerate a Random Decimal Number between Two Values
In YSQL there is the familiar built-in function named RANDOM which generates a random value between 0 (inclusive) and 1 (exclusive). Although […]
Read MoreDisplay Query Results in a Crosstab-like Representation in YSQLSH
Pivoting a the rows of a query’s result set into columns is magically simple using YSQLSH, YugabyteDB’s YSQL command line interface. The […]
Read More