🎯 Why this Tip? Blockchain and Distributed Ledger Technologies (DLTs) have exploded into mainstream discussions… even in enterprise data engineering. Even though […]
Read MoreXML in, JSONB out: Best-Effort XML → JSONB in YugabyteDB YSQL
Most modern apps want to store semi-structured data as JSON/JSONB, but a lot of legacy or external systems still speak XML. YugabyteDB […]
Read MoreWorking Around the Missing xml Data Type in YugabyteDB
PostgreSQL includes a native xml data type and a rich set of XML/XPath functions (XMLEXISTS, xpath, xpath_exists, XMLSERIALIZE, XMLTABLE, etc.). YugabyteDB does […]
Read MoreAutomatically keeping table statistics up to date for better query plans
🌟 Introduction In a distributed SQL engine such as YugabyteDB, query performance hinges on the optimizer’s ability to choose the right execution […]
Read More