When working with query performance in YugabyteDB, the pg_stat_statements extension is your best friend. It collects execution statistics for all SQL statements, […]
Read MoreLoad-balance YSQL connections to YugabyteDB using vanilla C (libpq)
YugabyteDB provides cluster-aware Smart Drivers for Java, Go, and Node.js that automatically route queries to the right node and balance load with […]
Read MoreMigrating Exception Handling from Oracle to YugabyteDB
When migrating PL/SQL code from Oracle to YugabyteDB’s PostgreSQL-compatible YSQL layer, one of the trickiest differences is exception handling. Oracle has its […]
Read MoreOrphaned Indexes: Oracle vs. YugabyteDB
If you’re migrating from Oracle to YugabyteDB, you may have run across the concept of orphaned indexes. In Oracle, there are views […]
Read MoreMigrating Oracle Cursors to YugabyteDB
Oracle developers often rely on explicit cursors to loop through result sets or to parameterize queries inside PL/SQL procedures. When migrating to […]
Read More