davidr

/David Rader

About David Rader

This author has not yet filled in any details.
So far David Rader has created 18 blog entries.

Mapping Oracle to PostgreSQL data types

A common first question during a database migration is "How do Oracle datatypes compare to PostgreSQL?" The simple answer is that they are very compatible, and map easily. The table below shows an Oracle to PostgreSQL data type comparison and mapping for the most common Oracle types. These basic data types just scratch the surface [...]

By | August 10th, 2017|Categories: Dave PostgreSQL|Tags: , , , |0 Comments

Autonomous transactions using pg_background

Transactions are an important feature in any database and PostgreSQL has them. We want to be "ACID Compliant" and ensure that all data is read and written in a consistent state. All changes in the transaction either commit or rollback together. You never change just one table, without also changing all the other related tables [...]

Migrating from MongoDB (back) to PostgreSQL

We helped a customer move from MongoDB back to PostgreSQL. It's an interesting story about some of the challenges of scaling a database platform and ways that PostgreSQL provides very reliable, robust, scalable data services. The Customer The customer is a software company that provides mobile enterprise security and threat protection. Their product provides security [...]

By | March 8th, 2017|Categories: Case Studies, Migration|Tags: , , |3 Comments

5 Tips to Prepare to Migrate to PostgreSQL

Migrating to PostgreSQL has many benefits - lower license costs, great community support, robust SQL support, powerful stored procedure languages, NoSQL key/value, document and full-text database capabilities, and many more. If you're moving from another relational database the migration can be fairly simple. Moving from a NoSQL database may require more application code changes but [...]

By | March 1st, 2017|Categories: Migration|Tags: , , |0 Comments

Don’t move your Oracle database to the cloud

Why move your Oracle database to the cloud? It just doesn't make sense. You are moving to the cloud for flexibility, for cost savings, for ease of changing your infrastructure. Does doubling your Oracle license fee for AWS or Azure usage sound like Oracle wants to let you have flexibility or cost savings?? (Hint: NO!!) [...]

By | February 7th, 2017|Categories: OpenSource|Tags: , , , , |0 Comments

How to: Pick a PostgreSQL Python driver

Using Postgres with python is easy and provides first class database capabilities for applications and data processing. When starting a new project, you need to choose which PostgreSQL python driver to use. The best choice depends on your deployment, python version, and background. Here's a quick guide to choosing between three popular python PostgreSQL drivers: [...]

By | January 10th, 2017|Categories: Dave PostgreSQL|Tags: , |8 Comments