mysql

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

January 17, 2018

How To Install Linux, Apache, MySQL, PHP (LAMP) stack on Ubuntu 16.04

A LAMP stack is a group of open source software that is typically installed together to enable a server to host dynamic websites and web apps. This term is actually an acronym which represents the Linux operating system, with the Apache web server. The site data is stored in a MySQL database, and dynamic content is processed by PHP.

Continue reading

January 9, 2018

Use Virtual Servers to build highly available and scalable web app

IBM Cloud infrastructure services offer a collection of infrastructure services like compute, storage, network, security, VMware and more. With this in place, let's explore what it takes to build a highly available and scalable web application on IBM Cloud.

Continue reading

December 30, 2016

Compose for MySQL and Compose for ScyllaDB: the new Compose databases on Bluemix

Bluemix users have been opening up the catalog to the benefits of hosted and managed Compose for MongoDB, Redis, Elasticsearch, PostgreSQL, RethinkDB, etcd and RabbitMQ. Now there are two more databases to add to that list: Compose for MySQL and ScyllaDB.

Continue reading

January 15, 2016

Deploying a CRUD PHP application to Bluemix

PHP developers still spend a lot of time configuring systems and servers to get a PHP application up and running. PHP developers usually go through this lifecycle every time starting a project. Luckily, Bluemix services and runtimes take all this grunt work out of creating web applications.

Continue reading

September 14, 2015

Using StrongLoop to create a Node.js MySQL application

The recently published tutorial Getting Started with Bluemix and StrongLoop presents videos summarizing the strengths of each product and demonstrating a sample application; the tutorial Getting Started with Node.js LoopBack Framework and IBM Cloudant examines how to leverage IBM Cloudant as a backend data store with the LoopBack framework and StrongLoop Arc tools. Continuing with same theme as the previous tutorials, this brief tutorial shows the steps of integrating data from a MySQL database with Node.js using the StrongLoop API. We make no assumptions about tooling other than the command line!

Continue reading

August 11, 2015

Build a PHP MySQL application and database

Alright, you asked for it! You got it. A very simple PHP application on Bluemix that talks to a MySQL database. No bells and whistles. It's perfect for a new developer.

Continue reading

April 20, 2015

Best of Bluemix: DevOps, Node.js, PHP, MySQL and calories

This post calls your attention to some of the Bluemix tutorials, videos, quick-starts and other useful content being published on developerWorks. This week features DevOps Services at hackathons, a mobile-friendly calorie counter on IBM Bluemix with PHP/MySQL, and a video of LiveEdit development with Node.js apps.

Continue reading

April 17, 2015

Securing Destinations with TLS in Bluemix Secure Gateway

In our previous tutorial, we showed how you can connect to an on-premises MySQL database using the Secure Gateway Service. We created a destination with No TLS. While this is acceptable for public destinations, we may want to secure our destination so that only we can access it. In this tutorial, we will set up a destination with TLS: Mutual Auth so that a private key and certificate are required to connect to our destination.

Continue reading