đź’ˇ 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 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