đź’ˇ What You’ll Learn â—Ź How Instant Database Cloning works internally (zero-copy + copy-on-write) â—Ź How to recover from a DROP TABLE […]
Read MoreHow to Show Leader and Replica Counts Per Node in YugabyteDB Using Pure SQL
When working with YugabyteDB, it is often useful to see how tablets are distributed across nodes. Two especially helpful questions are: â—Ź […]
Read MoreHandling NaN in NUMERIC Columns (Postgres vs YugabyteDB)
đź’ˇ TL;DR PostgreSQL allows NaN in NUMERIC. YugabyteDB currently does not. The best solution is to model “NaN” explicitly in your schema, […]
Read MoreExport YugabyteDB CREATE TABLE DDL Using Pure SQL (Including SPLIT AT and SPLIT INTO)
Intro To export schema from YugabyteDB, the most common approach is to use the ysql_dump utility: ysql_dump –include-yb-metadata This produces DDL that […]
Read More