Case-insensitive search is a common requirement for usernames, email addresses, product names, search boxes, and many other application fields. A previous YugabyteDB […]
Read More
Check 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 MorePreserve Custom System ACLs Across a PG11-to-PG15 YSQL Upgrade
A YSQL major-version upgrade is different from a normal YugabyteDB software upgrade. Moving from a PostgreSQL 11-based YugabyteDB release, such as the […]
Read MoreImplement Range Overlap Searches and EXCLUDE-Style Rules Without GiST
PostgreSQL provides an elegant way to handle problems such as overlapping reservations, duplicate-event windows, or effective-date ranges. A typical design uses a […]
Read More