Blog

PostgreSQL Videos

With all of the new users to PostgreSQL, one of the things we wanted to do for PGConf NYC this year was to have a video showing the history of PostgreSQL. We ended up with a very professional video showing how the features have grown over the years and by the applause of the attendees delivered on our goals. You …

Read More

PostgreSQL Studio is now on Heroku

One of my main objectives when writing PostgreSQL Studio was to help new users learn PostgreSQL. One of the main drivers of new PostgreSQL users is the different cloud players with Heroku being one of the biggest so it only made sense to start there. I’ve gone through the process of making PostgreSQL Studio an add-on for Heroku so now …

Read More

Stinger Delivers Fast Hive SQL via YARN & TEZ

The latest BigSQL bundle now includes Stinger and Tez to dramatically improve performance and extend the SQL dialect. In the latest distribution of BigSQL Release 2, it is extremely easy to get started exploring Tez and Stinger in your own sandbox environment. Taking advantage of YARN, Stinger is now delivering on its three main goals of Speed, SQL Enhancememnts & …

Read More

PostgreSQL Studio 1.2 Released

I am happy to announce that version 1.2 of PostgreSQL Studio, an open source web interface for PostgreSQL, was released on February 23, 2014. This releases contains some new functionality mostly around improving SQL Worksheet as well as some bug fixes. The changes in this release are: Features Added Open and Save buttons to SQL Worksheet Moved the close button …

Read More

Low Power (and cost) ARM Servers Get Real

Lately I’ve been fiddling with the new Cubietruck boards. For about $100 you get: – Dual Core ARM A20/a7 CPU – 2 GB RAM – Full connections for 2.5″ sata drive – Gigabit Ethernet It all runs nicely off of a little 10-watt $10 power supply. Couple this with a $100 2.5″ Seagate 1 TB SSHD and you’ve got a …

Read More

tPostgres Features Sybase & SQL Server Compatibility

We are pleased to announce version 9.3.2 of tPostgres. Find out more at http://www.tpostgres.org The transformation of the tPostgres: Sybase & SQL Server Compatibility Project project is now complete. We are fully based on the PGTSQL open source PostgreSQL Extension and are fully woking on the very latest and greatest point release of PG (9.3.2). Additionally, we have done away …

Read More

Oozie- Hadoop Workflow Scheduler in BigSQL

Oozie Eight

This tutorial will show you how to create and Oozie Workflow using either BigSQL Hue or the Oozie command line tools, in the latest version of BigSQL. Oozie is a workflow scheduler that will allow you to manage Hadoop jobs. You can also create an Oozie workflow that incorporates shell scripts, map-reduce applications, and even Pig, Sqoop, and Hive jobs. This …

Read More

BigSQL Adds Cassandra to the Hadoop and PostgreSQL Bundle

Cassandraeye2

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 solutions, it was a natural …

Read More

Sqoop2 in BigSQL Hue

Huesqoop1

This tutorial will show you how to import PostgreSQL data into the Hadoop File System using the Sqoop 2 application within Hue. Hue, or the Hadoop User Experience, allows you to use Oozie, Hive, Pig, Postgres, Sqoop, Hbase, Zookeeper, and Hadoop from a browser. Since release three of the BigSQL Quick-start Virtual Machine comes with Hue already installed, I will be …

Read More

Sqoop 2, Importing from PostgreSQL to HDFS

This tutorial will show how to configure Sqoop 2, start the server and client, and import a table from Postgres to HDFS. The latest version of Sqoop is part of BigSQL release two, which you can download here. The first part of this tutorial involves creating the customer history Postgres table using BenchmarkSQL: $ . ./setENV.sh $ psql postgres=# CREATE USER benchmarksql …

Read More

Page 1 of 1312345»10...Last »
/* ]]> */