GreenPlum and DBFit

Just a quick little stub of a post to track progress using the DBFit Test Driven Database Development Tool with our GreenPlum installation. DBFit seemed like a great option since it will theoretically support both GreenPlum and SQL Server.   I ran through the getting started documentation on the DBFit site fairly quickly and had the initial… Continue reading GreenPlum and DBFit

Postgres/Greenplum Get The Last Two Values In A Delimited String

Yuck. This works and I'm recording it here in case I need it again but yuck. Here's the scenario: there is a column in a database with a delimited string. The number of delimited values can vary. SOmetimes there will be one delimited value, sometimes there will be twenty. For this specific case I needed… Continue reading Postgres/Greenplum Get The Last Two Values In A Delimited String

Convert CamelCase to Underscores using SED and tr: GreenPlum MPP Refactor

All of our SQL Server databases use CamelCase as the naming convention. Unfortunately, GreenPlum MPP does not support CamelCase (without the use of quotes that is). Since I was transitioning a table from SQL Server to GreenPlum MPP and because I'm becoming a bash wizard (ha!) I wondered if there was a simple way to… Continue reading Convert CamelCase to Underscores using SED and tr: GreenPlum MPP Refactor

GreenPlum MPP Tool Review: Navicat For Postgres

I've spent a few hours so far working with Navicat for Postgres connected to our GreenPlum MPP (Massively Parallel Processing Database). (pgAdmin continues to iritate me but it'll be hard for a competitor to supplant the free incumbent). There is definitely some solid functionality here. Pros: Performance - The UI seems to be balzingly fast… Continue reading GreenPlum MPP Tool Review: Navicat For Postgres

SQL Server To GreenPlum MPP/Postgres Transition

I'm working with a team building a data warehouse using Pivotal's GreenPlum MPP (Massively Parallel Processing) database which is based on PostgreSQL. Although, all the data modeling basics transition easily from RDBMS to RDBMS there's a bit of a learning curve switching tools and syntax. Listed below are some of the items I've noted during the… Continue reading SQL Server To GreenPlum MPP/Postgres Transition