OpenSource

/OpenSource

Relocatable PG RPMs

Relocatable PostgreSQL RPMs - You asked and we delivered! In our years of dealing with PostgreSQL users, one of the main gripes they have with PostgreSQL is not a missing feature or capability but rather it is the fact that the provided rpms are non relocatable rpms. The reasons for wanting relocatable rpms are many [...]

By | October 19th, 2016|BigSQL, Dave PostgreSQL, OpenSource|0 Comments

Why Open Source over Open Source Based?

The Postgres landscape has become very competitive in recent years as the database project has matured and grown exponentially in popularity. Since more and more users are deploying Postgres to support a wide variety of applications, there is a need for experts to help make sure those deployments are successful. This has led to the [...]

By | October 18th, 2016|OpenSource, PostgreSQL|1 Comment

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|Big Data, BigSQL, Global Development, Hadoop, OpenSCG, OpenSource|Comments Off on BigSQL Hadoop + Postgres now Available as a VM

Installing and Running BigSQL, the Hadoop and Postgres Bundle

This tutorial will show you how to install and run BigSQL. You can download the bundle from BigSQL.org and get started using Hadoop, Hive, Hbase, and PostgreSQL in less than ten minutes. The video below goes over how to: Complete the prerequisites (the commands used can be found here) Start the bundle Open the psql, hive, [...]

By | October 16th, 2013|BigSQL, Highlight, OpenSCG, OpenSource|Comments Off on Installing and Running BigSQL, the Hadoop and Postgres Bundle

Hadoop Tutorials Hive HBase Flume Scoop Thrift and More

Over the last several months the team at OpenSCG has created a number of Hadoop Tutorials covering key  projects in the Hadoop ecosystem including Hive, HBase, Flume, Scoop and Thrift.  These Tutorials are designed to quickly highlight the usage of Hadoop with working examples that can be quickly worked through and modified!  To help you find [...]

By | September 5th, 2013|Hadoop, OpenSCG, OpenSource|Comments Off on Hadoop Tutorials Hive HBase Flume Scoop Thrift and More

Hadoop Sqoop Tutorial HDFS Hive & Postgres

The Hadoop Sqoop Tutorial is the third in the series providing easy to follow examples of using a Hadoop cluster in conjunction with Postgres.  This tutorial will build on the Hadoop Hive Tutorial which should be considered a pre requisite if you want to run the examples provided. In this tutorial, we will create a Postgres table from public domain [...]

By | July 10th, 2013|Big Data, BigSQL, Hadoop, OpenSCG, OpenSource, PostgreSQL|Comments Off on Hadoop Sqoop Tutorial HDFS Hive & Postgres

Meetup: Leveraging Hadoop in your PostgreSQL Environment

Our very own Jim "Jimbo" Mlodgenski will be hosting a Meetup Thursday June 27th at 6pm to discuss: Leveraging Hadoop in your PostgreSQL Environment! The event will be graciously held at: Slader 199 Lafayette Street Suite 3B New York, NY To register click here Details.... There is buzz everywhere about Apache Hadoop and rightfully so. It's an [...]

By | June 19th, 2013|Big Data, BigSQL, FDW (Foreign Data Wrapper), Hadoop, OpenSCG, OpenSource, PostgreSQL|Comments Off on Meetup: Leveraging Hadoop in your PostgreSQL Environment

PostgreSQL FDW to Hadoop Hive Tutorial

PostgreSQL Foreign Data Wrapper to Hadoop Hive Tutorial 2 In our last tutorial, Hadoop Hive Tutorial – Zero to Results in 15 Minutes, we installed Postgres and Hadoop and ran some simple queries against a sample dataset directly against Hive tables.  In this tutorial we will create a FDW (Foreign Data Wrapper) in Postgres and access the [...]

By | May 30th, 2013|Big Data, BigSQL, FDW (Foreign Data Wrapper), Hadoop, OpenSCG, OpenSource, PostgreSQL|Comments Off on PostgreSQL FDW to Hadoop Hive Tutorial

Hadoop Hive Tutorial – Zero to Results in 15 Minutes

This Tutorial will walk through using Hadoop's Hive to access data stored in HDFS.  This is the first tutorial (more to follow) and covers installing Hadoop as part of BigSQL and running some simple queries. The Platform:  Linux (RHEL, CentOS or Ubuntu) or Mac OSX.  The Hadoop and Postgres Install was from www.BigSQL.org.  Takes about [...]

By | May 23rd, 2013|Big Data, BigSQL, Global Development, Hadoop, IT, OpenSCG, OpenSource|Comments Off on Hadoop Hive Tutorial – Zero to Results in 15 Minutes

Security Hardening PostgreSQL

Take a look at our doc on Hardening your PostgreSQL deployment.  We use these strategies internally and with our customers and it's a great way to make sure you're secure from top to bottom. http://openscg.com/2013/04/security-hardening-postgresql/

By | May 17th, 2013|OpenSCG, OpenSource, PostgreSQL|Comments Off on Security Hardening PostgreSQL