Applications that frequently open and close YSQL connections can generate more database work than the SQL being executed might suggest. Every fresh […]
Read MoreFrom CVE Finding to Fixed Release: Auditing Vulnerabilities in YugabyteDB and YBA
Enterprise vulnerability scanners are very good at producing lists of CVEs. The harder questions usually come next: ● Does this vulnerability actually […]
Read MoreBetter Patterns for Case-Insensitive Search in YSQL
Case-insensitive search is a common requirement for usernames, email addresses, product names, search boxes, and many other application fields. A previous YugabyteDB […]
Read MoreCheck for Self-Assignments in YSQL UPDATE Statements with pg_stat_statements
Most applications probably never issue an UPDATE that explicitly assigns a column back to itself. For example: UPDATE t SET v = […]
Read More