PostgreSQL

Proliferation of NUMERIC

More and more I'm seeing people use a NUMERIC for their primary keys. This is a direct result of people leveraging automated tools for their Oracle to PostgreSQL migration. Oracle's NUMBER data type is frequently used as the primary key for a table so the tools just map to a PostgreSQL NUMERIC and calls it [...]

By | March 20th, 2017|Categories: Jim PostgreSQL|Tags: , , , |4 Comments

Migrations: What applications should I migrate?

When you have made the decision to investigate migrating your database applications from one database platform to another, the next big question you will need to answer is ‘Which application(s)?’ It seems like an easy enough question but there are many variables involved in whether or not the migration will be smooth. Technically, any application [...]

By | March 9th, 2017|Categories: Migration, OpenSCG, PostgreSQL|Tags: , , |0 Comments

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: , , |1 Comment

Why Migrate?

“Why migrate to Postgres?” is a question that we used to hear a lot in the past. There used to be a number of different reasons to migrate including, take advantage of new technology, a change of staff skills, vendor consolidation caused friction and of course, cost. Nowadays, the main reason we hear for migrating [...]

By | March 8th, 2017|Categories: Migration, OpenSCG, OpenSource, PostgreSQL, Uncategorized|Tags: , , , |0 Comments

Successful database Migrations : Are they really possible?

We talk to a lot of clients who want to perform database migrations but just about all of them are skeptical that the project will be a success. There are a number of reasons for this, including: Fear Lack of time to take on project Belief that their usage isn’t easy convertible to a new [...]

By | March 2nd, 2017|Categories: OpenSCG, OpenSource, PostgreSQL, thoughts, Uncategorized|Tags: , , , , |0 Comments

PostGIS – How to create a Spatial Database with PGC Command Line

We are excited to announce that BigSQL distributions of PostGIS now come bundled with several popular community spatial extensions: postgis fuzzystrmatch postgis_tiger_geocoder postgis_topology ogr_fdw address_standardizer address_standardizer_data_us This is the only community distribution to offer PostGIS with these extensions across ALL platforms (Mac, Linux, and Windows)! So, for all you GeoGeeks using Linux / Mac - [...]

By | February 10th, 2017|Categories: Holly PostGIS|Tags: , , |1 Comment

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

Using pg_bulkload to load data to PostgreSQL

PostgreSQL by BigSQL is committed to making Postgres user and developer friendly. As part of this effort, we continue to extend the list of extensions we ship and support. Recently, we started supporting pg_bulkload, a high speed data loading utility for PostgreSQL. In this blog post, we will illustrate how to quickly install and use [...]

By | February 1st, 2017|Categories: Jobin PostgreSQL|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