Migrating from Oracle to open-source databases has traditionally been a complex, costly endeavor. Enter IvorySQL: an open-source, drop-in replacement for PostgreSQL that bridges the gap. Built on the robust foundation of PostgreSQL, IvorySQL introduces full Oracle compatibility while preserving 100%… Read More »Exploring the Architecture of PostgreSQL based IvorySQL
On November 27, 2025, commit 0ca3b16 landed in the PostgreSQL master branch. Authored by Cary Huang (Highgo) and David Rowley (Microsoft), it introduces Parallel TID Range Scans. For most application developers, this won’t change how you write queries. But for… Read More »Speeding up large table scans with Parallel TID Ranges in PostgreSQL 19
We’ve All Been There It’s Friday afternoon. Your manager asks: “Can we replicate data from our Oracle database to PostgreSQL? I need to know by Monday.” Sure, no problem. You’ve done this before. You start listing what you need: By… Read More »Testing Heterogeneous CDC? Skip the Setup Pain with One-Command Deployment
Introduction PostgreSQL Extension Day 2025 made its successful debut on May 12, 2025, just one day before the start of pgconf.dev 2025. This focused one-day event brought together the community around a single theme: the PostgreSQL extension ecosystem. From innovative… Read More »Postgres Extensions Day 2025 Kicks Off with a Successful Debut in Montréal
Introduction pgconf.dev 2025 just wrapped up in Montreal, Canada, following its successful debut in Vancouver last year—and once again, it delivered a fantastic mix of deep technical content and strong community social activities. As always, the focus was on both… Read More »pgconf.dev 2025 Wraps Up with Great Success in Montreal
Why Bridge Java with C in the First Place? Bridging Java and C combines the strengths of both languages. A C application may rely on Java for modern libraries, cloud APIs, or UI and web capabilities, while a Java app… Read More »Extending PostgreSQL with Java: Overcoming Integration Challenges
Introduction PostgreSQL has become a go-to database for analytics, reporting, and modern application development, thanks to its extensibility, powerful indexing, and advanced features like JSONB, GIS, and vector processing. However, many organizations still rely on traditional relational databases like MySQL,… Read More »Logical Replication from MySQL, SQL Server and Oracle to PostgreSQL?