ER-Mapping with OpenShift, Getting Started with pgModeler

ER-Mapping with OpenShift, Getting Started with pgModeler

Greetings Shifters! I am an unabashed PostgreSQL fanboi. I am also someone who likes to design databases visually (ER Diagrams), I can’t visualize anything beyond two tables and their relationships without pictures. I also really want tools that can do roundtripping with the database – meaning they can generate the tables (or SQL) for the database or given a database (or SQL) they can generate a diagram. Finally, it has to run on Fedora Linux since that is my Operating System of choice. Bonus points are awarded if the tool is FOSS.

I looked around for a new tool and I hit a gold mine – pgModeler! It not only meets all my criteria it a joy to use. Today’s post will just cover some of the cool parts and how to get pgModeler to work with OpenShift.

Read More...

Add Map Navigation to Your App With pgRouting on OpenShift

I am going to introduce you to another piece of AWESOME geospatial technology that let’s you compute travel routes on a network – pgRouting. We have it available by default with PostGIS on OpenShift. It adds the capability to take a routable network, a start location, an end location, and then compute the “least cost route” between the two points. There are actually quite a few concepts in that statement to so let’s unpack the statement some more.

Read More...

Get More Spatial in Your Database with PostGIS 2.1 on OpenShift

With the latest release of OpenShift Online (and in the nightlies for OpenShift origin), you can now use PostGIS 2.1 with PostgreSQL. PostGIS is a spatial extension to PostgreSQL that allows users to carry out high end spatial operations in your database. For those of us who love using spatial data, this is just a big a upgrade as our recent PostgreSQL 9.2 upgrade. With this release there have been some very important features added to PostGIS as well as a lot of performance improvements. In this post I will cover how to enable it, migrate your data from PostGIS 1.5, and then show some of the great new features.

Read More...

Time For a Spatial Power Up | OpenShift + PostGIS

Hi Ho Shifters!! I am not sure how many of you knew this but OpenShift comes with a whole lot of spatial programming goodness built right in. Today we are going to look at how to spatially enable your application using PostGIS (currently version 1.5.3)- the spatial blade for PostgreSQL. Have you ever wanted to […]

Read More...