postgresql

January 16, 2019

Deploying Applications on IBM Cloud with Kubernetes and IBM Cloud Databases for PostgreSQL

Deploying a cloud-native application and integrating IBM Cloud Databases is easy using the IBM Cloud Kubernetes Service. In this tutorial, we’ll show you how to set up IBM Cloud Databases for PostgreSQL and deploy a Node.js application using the database with the IBM Cloud Kubernetes Service.

Continue reading

January 15, 2019

Using OpenStreetMap Data with IBM Cloud Databases for PostgreSQL

In this first part in a series dedicated to looking at geographical data, we're going to introduce you to OpenStreetMap data, import that data into an IBM Cloud Databases for PostgreSQL deployment, and make queries on some of the non-conventional data stored in hstore columns

Continue reading

January 8, 2019

Getting Started with pgRouting on IBM Cloud Databases for PostgreSQL Using Esri Shapefiles

We are going to look at how to upload an Esri shapefile of Seattle streets, layer on a set of locations throughout Seattle, and then find the shortest paths to those points using the street network.

Continue reading

January 3, 2019

Getting Started with pgRouting on IBM Cloud Databases for PostgreSQL

We're going to show you how PostgreSQL, PostGIS, and pgRouting on IBM Cloud Databases for PostgreSQL can get you started with complex geospatial queries.

Continue reading

December 13, 2018

Slack Chatbot with PostgreSQL Backend

Learn what it takes to replace a database service for an existing IBM Cloud solution tutorial. Build a serverless Slack chatbot backed by PostgreSQL.

Continue reading

December 10, 2018

An Introduction to PostgreSQL’s hstore

One of the highlights of PostgreSQL is its versatility, especially when you need a flexible data model. In this post, we'll explore hstore, PostgreSQL's simple key-value store, and take a look at how it works using a catalog of books.

Continue reading

November 28, 2018

Storing Network Addresses Using PostgreSQL

In this post, we're going to take a look at network address data types in PostgreSQL, namely the INET (Internet Protocol) and CIDR (Classless Internet Domain Routing) data types to store IPv4 and IPv6 addresses.

Continue reading

November 27, 2018

IBM Cloud Hyper Protect DBaaS Delivers Complete Data Confidentiality

IBM Cloud Hyper Protect DBaaS is the next evolution of databases in a scalable and security-rich cloud environment. It allows you to retain your data in a fully-encrypted database without the need for specialized skills.

Continue reading

November 14, 2018

PostgreSQL Tips: Template Databases

In this PostgreSQL Tip, we demystify PostgreSQL template databases and how and when you might use them. Template databases are really useful when you use the same database objects every time you create a new database.

Continue reading