Beyond ora2pg: A Better Way to Migrate from Oracle to Postgres
Migrating schemas and data from Oracle DB to Postgres Pro Enterprise is a notoriously rocky road, full of countless pitfalls for administrators and developers.
Interestingly, Postgres Pro Enterprise includes extended features specifically designed to mimic Oracle's mechanisms and smooth out this very process.
However, the widely-used open-source utility ora2pg doesn't support them. This gap led to the creation of ora2pgpro, a tool built to leverage these unique features for a more seamless transition.
Let's explore the specific migration challenges and see what makes this new tool a better fit for the task.
Migrating schemas and data from Oracle DB to Postgres Pro Enterprise is a notoriously rocky road, full of countless pitfalls for administrators and developers.
Interestingly, Postgres Pro Enterprise includes extended features specifically designed to mimic Oracle's mechanisms and smooth out this very process.
However, the widely-used open-source utility ora2pg doesn't support them. This gap led to the creation of ora2pgpro, a tool built to leverage these unique features for a more seamless transition.
Let's explore the specific migration challenges and see what makes this new tool a better fit for the task.
A Guide to the UX Researcher's Role
UX research is the essential foundation of great user experience design. It moves beyond assumptions to systematically study a product's target audience and understand what they truly need.
The process involves collecting and analyzing data about user behavior, their expectations, and how they interact with a digital product to find paths for improvement.
This guide covers the key skills and daily responsibilities of a UX researcher, offering a clear path for recent graduates and those looking to break into the field.
Let's explore the skills that define a great UX researcher and the first steps to start a career in this critical discipline.
UX research is the essential foundation of great user experience design. It moves beyond assumptions to systematically study a product's target audience and understand what they truly need.
The process involves collecting and analyzing data about user behavior, their expectations, and how they interact with a digital product to find paths for improvement.
This guide covers the key skills and daily responsibilities of a UX researcher, offering a clear path for recent graduates and those looking to break into the field.
Let's explore the skills that define a great UX researcher and the first steps to start a career in this critical discipline.
PostgreSQL 18: Part 5 or CommitFest 2025-03
PostgreSQL 18 has been officially out for a month, but the feature autopsy is just now concluding. This is the grand finale of our review series, and it tackles the final boss: the March 2025 CommitFest. This last development sprint is traditionally the biggest, the one where all the juiciest features get crammed in right before the gates close.
This review is a big one, precisely because the patch itself was massive. This isn't just a minor update digest; it's a deep look at the richest part of the new release. Let's dig into the most powerful new toys and capabilities that made the final cut.
PostgreSQL 18 has been officially out for a month, but the feature autopsy is just now concluding. This is the grand finale of our review series, and it tackles the final boss: the March 2025 CommitFest. This last development sprint is traditionally the biggest, the one where all the juiciest features get crammed in right before the gates close.
This review is a big one, precisely because the patch itself was massive. This isn't just a minor update digest; it's a deep look at the richest part of the new release. Let's dig into the most powerful new toys and capabilities that made the final cut.
Shardman: а quick guide for the architect
The myth of the magical fast=true parameter is still alive and well. In the world of distributed databases, it has a new contender: distributed=true. Spoiler: neither will save you. This isn't a game you win by flipping a switch; it’s a game that demands you rethink your entire schema, sharding keys, sequences, and queries.
This is a clear-eyed guide to the real trade-offs. We’ll walk through every corner — from colocated tables and CDC to topologies and foreign key constraints — to find out where performance actually improves, where it gets much more expensive, and how to deal with the fallout.
The myth of the magical fast=true parameter is still alive and well. In the world of distributed databases, it has a new contender: distributed=true. Spoiler: neither will save you. This isn't a game you win by flipping a switch; it’s a game that demands you rethink your entire schema, sharding keys, sequences, and queries.
This is a clear-eyed guide to the real trade-offs. We’ll walk through every corner — from colocated tables and CDC to topologies and foreign key constraints — to find out where performance actually improves, where it gets much more expensive, and how to deal with the fallout.
👍1
OAuth 2.0 authorization in PostgreSQL using Keycloak as an example
Support for the OAuth 2.0 Device Authorization Flow has landed in Tantor Postgres 17.5.0 (and is heading for PostgreSQL 18). This means you can finally play the "log in via Keycloak" game directly with your database, offering a modern and secure access method that's perfect for cloud environments and microservice architectures.
This guide walks through the entire setup, showing how to get this new feature talking to Keycloak. We'll follow the full path — configuring the identity provider, preparing PostgreSQL, writing an OAuth token validator, and verifying the whole thing works from psql using the Device Flow.
Support for the OAuth 2.0 Device Authorization Flow has landed in Tantor Postgres 17.5.0 (and is heading for PostgreSQL 18). This means you can finally play the "log in via Keycloak" game directly with your database, offering a modern and secure access method that's perfect for cloud environments and microservice architectures.
This guide walks through the entire setup, showing how to get this new feature talking to Keycloak. We'll follow the full path — configuring the identity provider, preparing PostgreSQL, writing an OAuth token validator, and verifying the whole thing works from psql using the Device Flow.
How we boosted SQL query accuracy by 33% with LLMs
An LLM-based SQL generator seems like an obvious win. Just hook up a powerful model's API, grant it database access, and... fire your human analyst? This isn't some simple "replace the human" game. In reality, no company in its right mind will pipe sensitive data into an external API from OpenAI or Anthropic.
So, self-host? Good luck. Open-source models often choke on complex schemas or specific dialects like PostgreSQL 17, and training them is a costly nightmare. This whole "just use an LLM" idea is a non-trivial challenge. We dove into this mess and found a way to boost accuracy by 33%. Let's explore how to actually tackle this problem.
An LLM-based SQL generator seems like an obvious win. Just hook up a powerful model's API, grant it database access, and... fire your human analyst? This isn't some simple "replace the human" game. In reality, no company in its right mind will pipe sensitive data into an external API from OpenAI or Anthropic.
So, self-host? Good luck. Open-source models often choke on complex schemas or specific dialects like PostgreSQL 17, and training them is a costly nightmare. This whole "just use an LLM" idea is a non-trivial challenge. We dove into this mess and found a way to boost accuracy by 33%. Let's explore how to actually tackle this problem.
Privacy on Mobile: a practitioner’s checklist
Privacy has always been a high-stakes game, but the AI wave and our data-hungry economy have turned our phones into the main playing field. Every digital crumb is an asset. While some users are savvy, relying solely on "user awareness" is a losing strategy. The first line of defense isn't the user; it's the developer.
This isn't just another compliance lecture. It's a practitioner's mental model for how to frame decisions around privacy from the ground up. Let's dive into the concrete checklists and practical examples that help build that defense.
Privacy has always been a high-stakes game, but the AI wave and our data-hungry economy have turned our phones into the main playing field. Every digital crumb is an asset. While some users are savvy, relying solely on "user awareness" is a losing strategy. The first line of defense isn't the user; it's the developer.
This isn't just another compliance lecture. It's a practitioner's mental model for how to frame decisions around privacy from the ground up. Let's dive into the concrete checklists and practical examples that help build that defense.