After 10 years using Drupal as my blogging platform, I have decided switch to Hugo, a static site generator. I don’t have the time to maintain a VPS server and keep Drupal updated and secure. I decided that I want to focus on writing and less on maintenance of the architecture powering my blog. Drupal…Continue readingFrom Drupal to Hugo
Having already created Drupal views on external data, I felt the next step was to use a cloud database as the data source for a Drupal view. In this post, part of a series on using Drupal as a data platform, I describe the steps I followed to use an Amazon RDS instance as the…Continue readingDrupal View on Steroids. Using a Cloud Database as View Data Source.
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
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
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