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).
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.
MySQL Schema Design: Back to The Future?
Once developers find themselves in the MySQL world, they will almost certainly hear some advice on how they should go about designing database schemas in MySQL. This blog post will provide insight into what you should consider when dealing with database schemas in MySQL.
Monitor PostgreSQL Performance Using a Database Health Dashboard
A PostgreSQL database health dashboard allows us to monitor the database in real-time and helps us to more fully understand some features which are unique to PostgreSQL.