DuckDB is incredible for high-speed, local OLAP analytics. It is lightweight, fast, embeddable, and designed for analytical queries. It also includes a […]
Read More
Install UUIDv7 Today in YugabyteDB (No Need to Wait for PostgreSQL 18)
🧠Introduction With PostgreSQL 18 introducing native uuidv7(), time-ordered UUIDs are finally going mainstream. But if you’re running YugabyteDB (or older PostgreSQL […]
Read MoreHow to Emulate PostgreSQL pgstattuple in YugabyteDB
If you come from PostgreSQL, pgstattuple is one of those extensions that feels like it should be part of your regular toolbox. […]
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 More