db2 on cloud

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

April 26, 2018

Tutorial: GitHub Traffic Analytics with Cloud Functions and Cloud Foundry

In a new solution tutorial, I show you how to automatically retrieve and store GitHub traffic data the serverless way with IBM Cloud Functions and Db2. The data can then be analyzed via a Web app deployed to Cloud Foundry on IBM Cloud. The app is secured with App ID using OpenID Connect. The new service Dynamic Dashboard Embedded provides visualization of the views and clones of GitHub repositories.

Continue reading

February 20, 2018

Cloud Functions: Easy Database Setup the Serverless Way

A tutorial I wrote, featuring a database-backed Slack chatbot, is now live. It uses Db2 as database system to store event data. The client accessing the database is written in Node.js and is implement with IBM Cloud Functions in a serverless way. During the development of that tutorial I faced the question on how to perform the database setup. Should I guide users through the user interface to create a table and insert data? Should they install a Db2 client and execute a script locally? I solved the problem in a serverless fashion. Here are the details.

Continue reading

December 13, 2017

Db2 on Cloud offsite disaster recovery node is now in closed beta

Today, Db2 on Cloud already has excellent availability characteristics, with a 99.99% SLA and the ability to scale your database without app downtime, unlike other competitors in the market.

Continue reading

October 27, 2017

Use Db2 as Cloud SQL Database with Python

Over the Summer I learned that Python is top in the IEEE programming languages ranking. It is also my favorite language for quickly coding tools, web apps and analyzing data with notebooks (e.g., on IBM Data Science Experience). Did you know that IBM provides four (4) different Db2 drivers for Python? There is a driver with the native Db2 API, one that supports the official Python DBI (database interface), one for the popular SQLAlchemy Python SQL Toolkit, and for the Python-based Django Web Framework. In an older blog I showed you how to use SQLAlchemy with Db2. Today, I am going to demonstrate you how simple it is to create a SQL database-backed web app in the IBM Cloud, utilizing the native Db2 API.

Continue reading

August 25, 2017

Secure Your Db2 Data Base with Trusted Contexts

I recently introduced you to Cloud App Security. Now, you have that new cloud-based app. The data is going to be stored in DB2 (on or off the cloud). You want to protect the data, but that cloud app user needs read and write access to the database. You don't want to open the floodgates to the database for that user? Ok, here is a way to secure your Db2 data and still provide the required access. Even if that sounds impossible, trust me. And, I am going to put that "trust me" in context. Read on.

Continue reading

August 24, 2017

Db2 and Cloud Object Storage: Get Started

For a while, Db2 has built-in support to directly access Cloud Object Storage (COS) like Amazon S3 and IBM COS (Softlayer / IBM Bluemix IaaS). It allows to perform backups (and restores) as well as data load operations to and from the cloud. Phil Nelson wrote an excellent overview and introduction on the IDUG blog with his examples focused on S3. Thus, in the following I am going to mostly cover Db2 using the IBM Cloud Object Storage and fill in some additional details.

Continue reading

August 24, 2017

Scale databases on-demand with Db2 on Cloud

IBM Db2 on Cloud (formerly dashDB for Transactions) has released a scalable plan that allows customers to scale RAM/CPU and disk independently.

Continue reading

June 15, 2017

IBM dashDB for Transactions and DB2 on Cloud are being renamed

We're making a few changes to the names of our offerings. As a result, we’re making changes to the Service Descriptions. This will go into effect on June 20th.

Continue reading