OpenShift Developer Spotlight: Rajiv Subramanian M

OpenShift Developer Spotlight: Rajiv Subramanian M

This week’s developer spotlight features Rajiv Subramanian M. Rajiv created WaterFlows Web App, a free Notes App on OpenShift using PostgresSQL, Django, HTML5, jQuery, and Bootstrap. Write down your ideas, things you like, things you hear, and things you see. Save your ideas and notes of any type (coding, articles, image/video gallery, ASCII Art). The Notes app is also useful as music reference for music studies. It comes with a music notation converter too.

Read More...

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...

Cloud Connections: How to Use OpenShift with External Databases

The OpenShift Platform as a Service (PaaS) makes it easy to spin up a database alongside your hosted web application, but you can also choose to use the platform with your existing storage solution. In this blog post, I will demonstrate how to call out to databases that reside off the PaaS. The focus will be on PostgreSQL, MySQL, MongoDB and Oracle databases, but the same technique can be used for a host of other DBs.

Read More...

More Online Features for April 2014

I wasn’t kidding when I said, “with spring comes along new features for Openshift”. And so here I am back for Part 2 of yet another release of Openshift Online. We have a few new features to show you so lets get started shall we. Openshift Marketplace Earlier this month we announced at our Red […]

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...