According to the YugabyteDB documentation, the largest value that can be stored in an integer is 2,147,483,647. This is because for non-qualified […]
Read MoreBe Careful with the NOT IN Operator when NULLs are Present
In YSQL we can use the IN operator in the WHERE clause to check if a value matches any value in a […]
Read MoreUsing an Index with LIKE Operator Predicates in YSQL
The YSQL LIKE operator is used to match text values against a pattern using wildcards. If the search expression can be matched […]
Read MoreAudit Only a Particular User in YSQL
YugabyteDB YSQL has many cool built-in audit logging features. You can read about them on this doc page: Audit Logging For today’s tip […]
Read MoreChange the Format of Audit Log Entries for YSQL
YugabyteDB YSQL uses the PostgreSQL Audit Extension (pgAudit) to provide detailed session and/or object audit logging via YugabyteDB YB-TServer logging. Audit records […]
Read More