“Poli is an easy-to-use SQL reporting application built for SQL lovers!” Poli isn’t a fully fledged BI tool. In my experience Poli is enough for sizeable chunk of BI users. I often find alot of features in sophisticated BI tools are not used. Poli is simple to get started. Within a couple of hours you…Continue readingInstall Poli As service using Systemd
Category: SQL
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
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
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
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