Database Normalization is crucial for optimizing the usage of system storage and resources. This article explains the differences between DBMS normal forms (2NF and 3NF) with a simple example.
During my work tenure, I got a chance to work with MySQL databases with as many as 700 million rows. This post will emphasize how to index and optimize your MySQL queries for indexes.
By
Akhil Mathew
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.
As a business expands, the need to ethically leverage data is not a luxury anymore but a necessity.
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.
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).
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.
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.
