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 SQL

Drupal: Using Views Database Connector (VDC) To Display Data in External Database

Apart from Drupal most organisations may have many systems such as a CRM, HR and e-commerce system. The field of Business Intelligence (BI) deals with bringing disparate data sources into a single data warehouse(DW). If you wanted to display data from your DW using Drupal, the Views module is a good place to start. Before…Continue readingDrupal: Using Views Database Connector (VDC) To Display Data in External Database

Categories
Business Intelligence SQL

Simplifying Lengthy SQL Scripts

Some of the scripts I have inherited or had to work on have been written by people who separate every logical step into a separate SQL statement and temp table. The longest script I have had to work on was over 20 000 lines which I managed to simplify to couple hundred lines. I frequently…Continue readingSimplifying Lengthy SQL Scripts

Categories
Open Source Software SQL

KDE Kate Text Editor, a Distraction Free SQL Client

Background I have been using Linux to host my Drupal based web applications for close to ten years now. Only in the last few years have I started using Linux exclusively as my desktop operating system(OS) on all my home computers. I still spend most of the time on MS Windows at work. Like a…Continue readingKDE Kate Text Editor, a Distraction Free SQL Client

Categories
SQL Web

Online SQL Tools I Use

Background Whilst I do most of my SQL editing using using an Open Source SQL editing tool, there are some online tools I use for SQL related tasks. I always keep privacy in mind so I never use these tools with sensitive data. Reasons for using these tools include: When I am not working on…Continue readingOnline SQL Tools I Use