Utilizing BigQuery as a Data Warehouse in a Distributed Application
When it comes to storing data, a robust and reliable solution to store data from various sources is the most important factor. In this article, we will see how to centralize data collection in a distributed application with Google BigQuery.
Set Up Django with Postgres, Nginx, and Gunicorn on Ubuntu 20.04
In this post, we will install Django in a Python virtual environment using PostgreSQL. We will then install and configure Gunicorn to serve applications. Next, we will use Nginx as a reverse proxy to the Gunicorn application server.
Build Twitter Heat Maps with Tweepy, Django and Arctype
Have you ever wanted to track your tweet activity on Twitter? Then this article is for you. I love how Django’s ORM makes it easy to model a database and modify it with views (i.e., the app’s functional back-end).
Streaming Data with PostgreSQL + Kafka + Debezium: Part 1
In this guide, we will use Postgres, Kafka, Kafka Connect, Debezium, and ZooKeeper to create a small API that keeps track of your stock & crypto purchases over time.
Use MySQL Window Functions to Get More out of Your Data
MySQL introduced Window functions in their release of MySQL version 8.0. to target groups of rows without collapsing them. In this article, we will explore example implementations of the most versatile window functions MySQL has to offer.