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
Set GUC Parameter Within the Scope of a Stored Procedure
PostgreSQL setting parameters are often called GUC, short for the name of the ‘Grand Unified Configuration scheme’ project that introduced them. Since […]
Read MoreDOWNLOAD THE LATEST YSQL JDBC JAR FILE
The YugabyteDB JDBC smart driver is a JDBC driver for YSQL built on the PostgreSQL JDBC driver, with additional connection load balancing […]
Read MoreVerify Effective Transaction Isolation Level in YSQL
Transaction isolation is foundational to handling concurrent transactions in databases. The SQL-92 standard defines four levels of transaction isolation (in decreasing order […]
Read MoreAdd 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 More