TSQLServer *db = TSQLServer::Connect("sqlite://root_download_stats.sqlite", "", "");

const char *rootPlatform = "SELECT Platform FROM accesslog;";

TSQLResult *rootPlatformRes = db->Query(rootPlatform);

TH1F *hrootPlatform = new TH1F("hrootPlatform", "Platform Distribution", 7, 0, -1);
TH1F *shorthrootPlatform = new TH1F("shorthrootPlatform", "Short Platform Distribution", 7, 0, -1);

while (TSQLRow *row = rootPlatformRes->Next()) {
   TString rowPlatform(row->GetField(0));
   TString Platform(rowPlatform);
   TString Platform_0(rowPlatform(0,5));
   TString Platform_1(rowPlatform(0,6));
   TString Platform_2(rowPlatform(0,8));
   if ( rowPlatform.Contains("win32") ){
      shorthrootPlatform->Fill(Platform_0,1);
   } else if ( rowPlatform.Contains("Linux") ){
      shorthrootPlatform->Fill(Platform_0,1);
   } else if ( rowPlatform.Contains("source") ){
      shorthrootPlatform->Fill(Platform_1,1);
   } else if ( rowPlatform.Contains("macosx64") ){
      shorthrootPlatform->Fill(Platform_2,1);
   } else if ( rowPlatform.Contains("IRIX64") ){
      shorthrootPlatform->Fill(Platform_1,1);
   }

   hrootPlatform->Fill(Platform,1);

   delete row;
}

TCanvas *PlatformDistributionHistogram = new TCanvas();

hrootPlatform->GetXaxis()->LabelsOption("a");
hrootPlatform->LabelsDeflate("X");
hrootPlatform->Draw();

TCanvas *shortPlatformDistributionHistogram = new TCanvas();

shorthrootPlatform->GetXaxis()->LabelsOption("a");
shorthrootPlatform->LabelsDeflate("X");
shorthrootPlatform->Draw();

%jsroot on
gROOT->GetListOfCanvases()->Draw()