All topics
Nida Sahar5 min read
Nida Sahar4 min read
Database Performance Optimization
2 posts in Database Performance Optimization
PostgreSQL
PostgreSQL Cursor Tutorial in Java: How to Use JDBC CallableStatement for Large Data
Master PostgreSQL cursors in Java using JDBC and CallableStatement. Learn how to fetch large datasets efficiently with real-world examples and performance tips.
Nida Sahar5 min readPostgreSQL
From ORA to PG: A Casual Guide to Converting Stored Procedures
Changing to PostgreSQL (PG) from Oracle (ORA)? One of those things that can be annoying, but rewarding when done correctly, is converting stored processes. It's similar to untangling your earbuds. Don't worry if you're new to translating from PL/SQL to PL/pgSQL; I've got you covered. We'll discuss how to do it, what to look out for, and how to maintain your sanity.
Nida Sahar4 min read