compose-postgresql-helloworld-nodejs is a sample Bluemix application which shows you how to connect to an IBM Compose for PostgreSQL for Bluemix service using Node.js.

1. If you do not already have a Bluemix account, sign up here

2. Download and install the Cloud Foundry CLI tool

3. Clone the app to your local environment from your terminal using the following command:

git clone https://github.com/IBM-Bluemix/compose-postgresql-helloworld-nodejs.git

4. cd into this newly created directory

5. Open the manifest.yml file and change the host value to something unique.

The host you choose will determinate the subdomain of your application's URL: <host>.mybluemix.net

6. Connect to Bluemix in the command line tool and follow the prompts to log in.

$ cf api https://api.ng.bluemix.net
$ cf login

7. Create the Compose for PostgreSQL service in Bluemix.

Note : The Compose for PostgreSQL service does not offer a free plan. For details of pricing, see the Pricing Plans section of the Compose for PostgreSQL service in Bluemix.

$ cf create-service compose-for-postgresql Standard my-compose-for-postgresql-service

8. Bind the service to the application.

$ cf bind-service compose-postgresql-helloworld-nodejs my-compose-for-postgresql-service

9. Push the app to Bluemix.

$ cf push

Now when you visit <host>.mybluemix.net/ you will be able to view and add words to the words table.

The app uses a PUT and a GET operation:

• PUT

  • takes user input from main.js
  • uses the client.query method to add the user input to the words table

• GET

  • uses client.query method to retrieve the contents of the words table
  • returns the response of the database command to main.js

The sample web application includes code to track deployments to Bluemix and other Cloud Foundry platforms. The following information is sent to a Deployment Tracker service on each deployment:

• Application Name (application_name)
• Space ID (space_id)
• Application Version (application_version)
• Application URIs (application_uris)

This data is collected from the VCAP_APPLICATION environment variable in IBM Bluemix and other Cloud Foundry platforms. This data is used by IBM to track metrics around deployments of sample applications to IBM Bluemix. Only deployments of sample applications that include code to ping the Deployment Tracker service will be tracked.

Deployment tracking can be disabled by removing require("cf-deployment-tracker-client").track(); from the beginning of the server.js file.