Categories
Drupal

Connecting phpMyAdmin to Amazon RDS

I wanted to try out Amazon Aurora RDS so I signed up for the free tier account. This post gives the steps I followed to configure phpMyAdmin running on a different VPS to connect to my Amazon Aurora RDS instance. I wrote this up because I struggled as most of the pages I found were…Continue readingConnecting phpMyAdmin to Amazon RDS

Categories
Drupal

Creating Drupal Charts on External Views Data

This is a continuation of my series of posts on using Drupal as a data platform. In this post I show that you can create charts on data external to Drupal. I picked three modules to illustrate my point from a longer list of available contributed Drupal charting modules. There are two documentation pages that…Continue readingCreating Drupal Charts on External Views Data

Categories
Drupal SQL

Using SQL in Drupal Views Fields

SQL is a powerful data manipulation language (DML) that can be used to perform complex calculations and format data within your database. The Views Raw SQL module enables you to use SQL on your fields in your Drupal view. This is useful when using Drupal as a data platform for reports and data analysis from…Continue readingUsing SQL in Drupal Views Fields

Categories
Drupal

Conditional Formatting of Data In Drupal Views

A few years ago then Google CEO Eric Schmidt was quoted as saying, “There was 5 exabytes of information created between the dawn of civilization through 2003, but that much information is now created every 2 days, and the pace is increasing”. The great volumes of data available for analysis have necessitated the development of…Continue readingConditional Formatting of Data In Drupal Views

Categories
Drupal

Defining Drill Downs in Drupal Views

The logical way to analyse data is to start by looking at summarised data before looking at the detail. This is referred to as drilling down. In this post I demonstrate how to define drill down functionality between two Drupal Views. This is a continuation on my series of posts showing how Drupal can be…Continue readingDefining Drill Downs in Drupal Views