BigSQL

/Tag:BigSQL

BIG NEWS from BigSQL: Introducing pgDevOps!

To help our colleagues at OpenSCG provide better service to our clients, BigSQL developed pgDevOps - a one stop shop to provision, develop, and monitor PostgreSQL databases. And now... we are making pgDevOps available to the PostgreSQL community! How Does pgDevOps Help? Install and Provision: Package Manager: One-click installs of PostgreSQL [...]

By | March 30th, 2017|Categories: BigSQL, Holly PostgreSQL, OpenSource|Tags: , , , , , , |0 Comments

Importing Shapefiles into PostGIS with shp2pgsql

Geojson may be catching up, but by and far the most popular data format for sharing geospatial data is (and has been since the early 1990's) the shapefile. Although a shapefile is a simple way to share data that can be easily consumed by almost any GIS system, it comes with many limitations and is [...]

By | March 23rd, 2017|Categories: Holly PostGIS, Holly PostgreSQL|Tags: , , |1 Comment

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

pg_repack in Postgres by BigSQL

Many DBAs agree that one of the most useful extension in their arsenal is pg_repack. Pg_repack addresses a serious shortcoming in Postgres: doing VACUUM FULL online. Due to the way Postgres handles the MVCC, tables and indexes become bloated. Dead tuples are addressed by AUTOVACUUM and space will be marked free. In many situations a [...]

By | January 9th, 2017|Categories: Jobin PostgreSQL|Tags: , , , |0 Comments

Integrating Cassandra, Spark, PostgreSQL and Hadoop as a Hybrid Data Platform – Part 3

In a previous blog post we talked about the technical details behind the new CassandraFDW that enables PostgreSQL to connect to a Cassandra cluster. This provides PostgreSQL users the ability to easily read and write data to a very popular open source multi-master database that can support writes in multiple data centers. This means if [...]

Two great things that taste great together: PostGIS and PostgreSQL

In my past life as a geospatial DBA, I had to navigate users and managers who belonged to different database teams (PostgreSQL, MySQL, SQL Server, Oracle, etc). When I was lucky enough to work in a shop that supported open source solutions, I was often asked by members of team MySQL, “Why should we use PostgreSQL [...]

By | October 17th, 2016|Categories: Holly PostGIS|Tags: , , |1 Comment

Holy Easy PostgreSQL deployment

Holy Easy PostgreSQL deployment! In case you missed it, the BigSQL team released an awesome package manager for installing and configuring PostgreSQL and many related, useful components. The package manager can be found here: https://www.bigsql.org/package-manager.jsp. Playfully named pgc, for ‘pretty good command line’, pgc is a utility similar to yum or apt-get that allows you [...]

By | October 14th, 2016|Categories: BigSQL, Dave PostgreSQL, OpenSCG|Tags: , , , |0 Comments

Why are you still paying for your GIS when you can get it for free?

If you haven’t switched to open source solutions (FREE!), then you have probably fallen for some common misconceptions/myths: MYTH: Open source tools are buggy. Does software have bugs? Of course. It was made by humans! But open source has the benefit of a strong community that can crowdsource fixes because the code base is not [...]

By | October 4th, 2016|Categories: Holly PostGIS|Tags: , , , , , |0 Comments

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

NYC PGDAY BigSQL Presentation

At NYC PGDAY 2013 Denis Lussier presented BigSQL = Postgres + Hadoop. Denis' BigSQL presentation focused on leveraging both PostgreSQL and Hadoop to create a data platform to meet today's expanding enterprise data needs. The presentation does a great job of detailing the Open Source components included in OpenSCG's developer bundles with an explanation of each component's value [...]

By | March 26th, 2013|Categories: Big Data, BigSQL, conference|Tags: , , |Comments Off on NYC PGDAY BigSQL Presentation