💡 TL;DR PostgreSQL allows NaN in NUMERIC. YugabyteDB currently does not. The best solution is to model “NaN” explicitly in your schema, […]
Read More
Export 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 MoreHow to Replace ST_SetSRID(ST_MakePoint(…),4326) from PostgreSQL/PostGIS in YugabyteDB (Without PostGIS)
Inroduction Many PostgreSQL applications that use PostGIS construct geographic points like this: ST_SetSRID(ST_MakePoint(lon, lat), 4326) This pattern is extremely common in location-based […]
Read MoreDesigning the Best Index for a Query in YugabyteDB
Across this indexing series, we improved the same query step by step. We started with a simple index on tenant_id. Then we: […]
Read More