How to Set Up PostgreSQL High Availability with Patroni
Create a Postgres High Availability cluster with Patroni, etcd, and HAProxy on Ubuntu
SQL Injection vs. Your Applications in the Modern Age
SQL injection attacks traditionally represent one of the largest threats to database security. This article explains what they are and how you can prevent them.
Indexing MySQL For High Performance: A High-level Overview
Some MySQL engineers might call them the cornerstone of improving performance in MySQL: indexes are data structures that are frequently used to quickly find rows matching a given query.
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.