Large Scale PostgreSQL Deployment Whitepaper
Download Now >>

Oracle to PostgreSQL Migrations

Migrating from an Oracle database to PostgreSQL frequently gives organizations benefits that range from lowered costs to a better technical architecture. The OpenSCG Migration Factory speeds the process while reducing risk.

This white paper explores the process for migrating an application from an Oracle database to PostgreSQL. It is intended for people who have already made the wise choice of moving to PostgreSQL and are exploring what is involved in a migration project.

Large Scale PostgreSQL Deployment Whitepaper
Download Now >>

PostgreSQL Data Types Whitepaper

The philosophy of PostgreSQL is a bit different than Oracle. In Oracle, the base data types are fairly basic and put the responsibility on the developer to handle the logic of the data. PostgreSQL optimizes at the lower level data types for common business problems freeing up developer time and effort for more important things.

This paper will delve into PostgreSQL’s built-in data types and talk about when and how to use them most effectively to avoid common pitfalls and mistakes Oracle developers often make using PostgreSQL.

Large Scale PostgreSQL Deployment Whitepaper
Download Now >>

Large Scale PostgreSQL Deployment Case Study

This whitepaper has been designed to deliver valuable information for developers, database architects, or technical staff responsible for managing a large number of PostgreSQL database instances spread across multiple continents, coasts, data-centers and clouds.

PostgreSQL Security Guidelines Whitepaper
Download Now >>

PostgreSQL Security Guidelines Case Study

Security Hardening PostgreSQL

Recent PostgreSQL security updates are a reminder of the importance of staying up to date with critical software patches. OpenSCG continually updates our open source distributions to ensure software security. However, applying critical patches is just one of the many tasks to perform when securing and hardening your database platforms.