charlesg@openscg.com

/Charles Gerth

About Charles Gerth

This author has not yet filled in any details.
So far Charles Gerth has created 26 blog entries.

Jan Wieck joins the team!

East Brunswick, NJ, April 21, 2016 OpenSCG, a leading provider of subscriptions and services for PostgreSQL, announced today that Jan Wieck has joined its team of top-tier PostgreSQL talent as Senior Database Architect. Wieck is a long time contributor to the PostgreSQL Global Development Group, and has authored many key Postgres technologies over the years, [...]

By | May 10th, 2016|Categories: Uncategorized|0 Comments

FTP I/O from PostgreSQL

PostgreSQL applications at times need to communicate with external servers using FTP. Oracle has the UTL_TCP package that is very useful for PL/SQL applications. PostgreSQL doesn’t have an equivalent package, but it does have something really powerful … the ability to write functions in various scripting languages. PostgreSQL has four languages that are part of [...]

By | August 21st, 2014|Categories: PostgreSQL, tip|Comments Off on FTP I/O from PostgreSQL

Hierarchical Queries using PostgreSQL

One of the major hurdles faced when converting Oracle’s PL/SQL code to any other database is to find the equivalent of START WITH and CONNECT BY PRIOR. This SQL in Oracle provides a very powerful way of writing hierarchical queries, something that comes in really handy when dealing with hierarchical data – this is fairly [...]

By | August 15th, 2014|Categories: PostgreSQL, tip|Comments Off on Hierarchical Queries using PostgreSQL

BigSQL Adds Cassandra to the Hadoop and PostgreSQL Bundle

The BigSQL developer's bundle has added a significant new component: Cassandra 2.0.4.  All of the bundles and VM's now allow developers to get up and running with the latest Hadoop ecosystem and Cassandra.   Join our free Beta program now!   As a significant number of our clients are leveraging Cassandra for Highly Available Multi Partition [...]

By | January 16th, 2014|Categories: Big Data, BigSQL, FDW (Foreign Data Wrapper), Hadoop, OpenSCG, PostgreSQL|Comments Off on BigSQL Adds Cassandra to the Hadoop and PostgreSQL Bundle

BigSQL Hadoop + Postgres now Available as a VM

With the continued success of the BigSQL developer's bundle, we are proud to announce the availability of a new VM image with BigSQL preinstalled.  Primarily created to provide our Windows friends access to the technology bundle, the Image is based on CentOS 6.4 Desktop including many tools to begin exploring today.  Join our free Beta [...]

By | November 20th, 2013|Categories: Big Data, BigSQL, Hadoop, OpenSCG, OpenSource|Tags: |Comments Off on BigSQL Hadoop + Postgres now Available as a VM

Open letter to my friends at EnterpriseDB

With the recent announcement from Amazon that PostgreSQL will be available as a standard RDS option,  I feel compelled to ask you to consider what would happen if you open sourced Postgres Plus Advanced Server.... Here's one plausible scenario to consider... 1) Postgres usage and adoption rates will excel a rate not seen to date. [...]

By | November 14th, 2013|Categories: PostgreSQL|Comments Off on Open letter to my friends at EnterpriseDB

Tutorial on running Crystal Reports with BigSQL in Eclipse

1. Pre Requsites to run this tutorial: a) BigSQL Tutorial The BigSQL tutorial is required to be followed till the first three steps from the following link http://www.bigsql.org/se/tutorial.jsp Step 1 : Creating example.customer_history in HIVE and loading values. Step 2 : Creating example.customer_history as foreign table in Postgres Step 3 : Verifying example.customer_history b) Eclipse [...]

By | October 4th, 2013|Categories: BigSQL, Hadoop|Tags: , , , , , , |Comments Off on Tutorial on running Crystal Reports with BigSQL in Eclipse

Hadoop and Pentaho Tutorial Video

In this Video sample web log data is ingested into Hadoop HDFS, processed with a number of pig jobs and analyzed with Pentaho.  All completed in lightning time using BigSQL.  Interested in getting Big Data results?  Try our Hadoop Jumpstart! [youtube url="http://www.youtube.com/watch?v=eSEe_33pImA&feature=youtu.be" autohide="1" rel="0" showsearch="0"]

By | September 26th, 2013|Categories: Uncategorized|Comments Off on Hadoop and Pentaho Tutorial Video

JasperReports with Hadoop – Tutorial

This tutorial covers step by step instruction on running Jasper Reports with Hadoop using Jaspersoft Studio easy and simple to use environment . Also, publishing the created sample report with Jasperserver that is connected to Jaspersoft Studio . 1. Prerequisites a) BigSQL Tutorial is required to be followed till Step 3 http://www.bigsql.org/se/tutorial.jsp Step 1 : Creating example.customer_history [...]

By | September 25th, 2013|Categories: Big Data, BigSQL, Hadoop, OpenSCG|Tags: , , , , , |Comments Off on JasperReports with Hadoop – Tutorial

Tutorial – Run BIRT against Hadoop

This tutorial covers setting up of BIRT (Business Intelligence Reporting Tool) to run against Hadoop. BIRT is a relatively simple and yet powerful analytics tool and the tutorial will help you harness the power against Hadoop. 1. Pre-Requisites BigSQL Tutorial The BigSQL Tutorial (http://www.bigsql.org/se/tutorial.jsp) needs to be followed till step 3 Step 1 : Creating example.customer_history [...]