Database and Migration Insights · Scour

Same SQL, Different Results: A Subtle Oracle vs PostgreSQL Migration Bug

databaserookies.wordpress.com·2w·

Discuss: Hacker News

PostgreSQL Table Rename and Views – An OID Story

databaserookies.wordpress.com·5w

PostgreSQL Partition Pruning: The Role of Function Volatility

databaserookies.wordpress.com·14w

Exploring PostgreSQL 18: A Developer’s Guide to New Features – Part 1: The COPY Command Gets More User-Friendly

databaserookies.wordpress.com·19w

PostgreSQL Case-Insensitive Search: Handling LIKE with Nondeterministic Collations

databaserookies.wordpress.com·23w

PostgreSQL 18 Beta Preview – Export or Amend Statistics with Ease

databaserookies.wordpress.com·40w

Understanding Volatility in PL/pgSQL Functions: A Real-World Lesson

databaserookies.wordpress.com·65w

PL/pgSQL Secrets: How Conditional Expressions Are Parsed and Evaluated Under the Hood.

databaserookies.wordpress.com·67w

How to Connect to PostgreSQL Database Through AWS SSM Using pgAdmin or DBeaver.

databaserookies.wordpress.com·72w

Exploring PostgreSQL 17: A Developer’s Guide to New Features – Part 7: pg_maintain Predefined Role for Maintenance.

databaserookies.wordpress.com·72w

Exploring PostgreSQL 17: A Developer’s Guide to New Features – Part 6: Login Event Trigger

databaserookies.wordpress.com·76w

Exploring PostgreSQL 17: A Developer’s Guide to New Features – Part 5 : Correlated IN Clause Transformation

databaserookies.wordpress.com·76w

Exploring PostgreSQL 17: A Developer’s Guide to New Features – Part 4: Enhanced Merge Command.

databaserookies.wordpress.com·79w

Simplify PostgreSQL Execution Plan Analysis with pg_sqltxplain.

databaserookies.wordpress.com·80w

Exploring PostgreSQL 17: A Developer’s Guide to New Features – Part 3: The COPY Command Gets More User-Friendly

databaserookies.wordpress.com·82w