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 MoreYugabyteDB Gets FTL Transactions!
YugabyteDB supports a rich set of multi-region deployment topologies. The predominant deployments include: Default synchronous replication across regions Geo-partitioning to pin data to different […]
Read MoreREMOVE CONSECUTIVE REPEATED CHARACTERS FROM A STRING
A regular expression is a character sequence that is an abbreviated definition of a set of strings (a regular set). Regular Expressions have […]
Read MoreRestart an IDENTITY Column When Truncating a Table
In YSQL the column constraint GENERATED ALWAYS AS IDENTITY allows you to automatically assign a unique number to a column. Example: yugabyte=# […]
Read MoreBetter Performance on JSONB Data Value Search with a GIN Index
YSQL supports the JSON and JSONB data types which both can store JSON (JavaScript Object Notation) data. JSON stores an exact copy […]
Read More