Practical Data Analysis with SQLSQL databases have been around since the 1970s. Some of the smartest people in the world worked on making it easy to slice, dice, fetch and…Mar 23, 20231Mar 23, 20231
Exciting New Features in Django 3.2Django 3.2 is just around the corner and it’s packed with new features. Django versions are usually not that exciting (it’s a good thing!)…Mar 3, 2021Mar 3, 2021
The Unexpected Find That Freed 20GB of Unused Index SpaceEvery few months we get an alert from our database monitoring to warn us that we are about to run out of space. Usually we just provision…Feb 1, 2021Feb 1, 2021
Re-Introducing Hash Indexes in PostgreSQLIf you work with databases you are probably familiar with B-Tree indexes. They are used to enforce unique and primary-key constraints, and…Jan 11, 2021Jan 11, 2021
Simple Anomaly Detection Using Plain SQLMany developers think that having a critical bug in their code is the worst thing that can happen. Well, there is something much worse…Sep 21, 2020Sep 21, 2020
Some SQL Tricks of an Application DBAWhen I started my career in development, my first job was a DBA. Back then, before AWS RDS, Azure, Google Cloud and the rest of them cloud…Jul 27, 2020Jul 27, 2020
How to Move a Django Model to Another AppIn my latest article for RealPython I share three ways to tackle one of the most challenging tasks involving Django migrations: moving a…May 6, 2020May 6, 2020
Testing an Interactive Voice Response System With Python and PytestFollowing my previous article on how to build an Interactive Voice Response (IVR) system with Twilio, Python and Django, in this follow-up…May 1, 2020May 1, 2020
Using Markdown in DjangoOriginally published at https://hakibenita.com on February 11, 2020. Read this article on by blog with proper syntax highlighting.Mar 30, 2020Mar 30, 2020