Prepared statements are great… until they suddenly aren’t. With the YugabyteDB JDBC Smart Driver (which inherits pgJDBC behavior), a prepared statement is […]
Read More
Taming Prepared Statement Re‑Planning with plan_cache_mode in YugabyteDB
Have you ever noticed a prepared statement in PostgreSQL (or YugabyteDB YSQL) that runs quickly at first but then, after a handful […]
Read MoreQuick Lookups with VALUES as a Table
Ever need to map codes to labels without creating a whole new table? In YugabyteDB, you can use the SQL VALUES clause […]
Read More