This post is a part of a series on Lambda Architecture consisting of: Introduction to Lambda Architecture Implementing Data Ingestion using Apache Kafka, Tweepy Implementing Batch Layer usi...
This post is a part of a series on Lambda Architecture consisting of: Introduction to Lambda Architecture Implementing Data Ingestion using Apache Kafka, Tweepy Implementing Batch Layer usi...
1. Setting up postgresql on Mac OS Install postgresql: brew install postgresql Start postgres: brew services start postgresql Login to postgres shell to create user: /usr/local/bin/psql -d...
Window functions are an advanced and powerful feature of the T-SQL language. I will give a few tips on how to use and examples on the AdventureWorks2014 OLTP database. Here I will give some notes ...
As part of my application for the cBioPortal Google Summer of Code position I made this Jupyter notebook in which I demonstrated how different studies (RDBMS equivalent of a table) could be cluster...
Logins and users basics There are two main levels of security in SQL Server. Access to the server Access to a database (* there are also schemas on a database/table level but I will not co...
Intro Apache Spark is quickly becoming one of the best open source data analysis platforms. With the continuous improvement of Apache Spark, especially the SQL engine and emergence of related pro...
This post will outline all of my weekly blog posts related to my Google Summer of Code 2017 project. GSoc Community Bonding Week 1 GSoc Community Bonding Week 2 GSoc Community Bonding Week 3 GSoc...
This is a summary of my Google Summer of Code project containing the definition of the initial task, the implemented solution and references to show the work I have done. GOAL In this project I a...
This was the final weekend of Google summer of code. I am glad that we managed to deploy the application onto the server without any issues. I have also worked on writing good documentation and a p...