Open in app

Sign In

Write

Sign In

Haki Benita
Haki Benita

2.8K Followers

Home

About

Mar 23

Practical Data Analysis with SQL

SQL 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 manipulate data quickly and efficiently. …

Sql

3 min read

Practical Data Analysis with SQL
Practical Data Analysis with SQL
Sql

3 min read


Mar 3, 2021

Exciting New Features in Django 3.2

Django 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!), but this time many features were added to the ORM, so I find it especially interesting! Check out the full article on hakibenita.com >> Originally published at https://hakibenita.com on March 3, 2021.

Django

1 min read

Django

1 min read


Feb 1, 2021

The Unexpected Find That Freed 20GB of Unused Index Space

Every 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 more storage and forget about it, but this time we were under quarantine, and the system in question was under less load than…

Database

1 min read

The Unexpected Find That Freed 20GB of Unused Index Space
The Unexpected Find That Freed 20GB of Unused Index Space
Database

1 min read


Jan 11, 2021

Re-Introducing Hash Indexes in PostgreSQL

If you work with databases you are probably familiar with B-Tree indexes. They are used to enforce unique and primary-key constraints, and are the default index type in most database engines. If you work with text, geography or other complex types in PostgreSQL, you may have dipped your toes into…

Postgres

1 min read

Re-Introducing Hash Indexes in PostgreSQL
Re-Introducing Hash Indexes in PostgreSQL
Postgres

1 min read


Sep 21, 2020

Simple Anomaly Detection Using Plain SQL

Many developers think that having a critical bug in their code is the worst thing that can happen. Well, there is something much worse than that: Having a critical bug in your code and not knowing about it! To make sure I get notified about critical bugs as soon as possible, I started looking for ways to find anomalies in my data. I quickly found that information about these subjects tend to get very complicated, and involve a lot of ad-hoc tools and dependencies.

Sql

1 min read

Simple Anomaly Detection Using Plain SQL
Simple Anomaly Detection Using Plain SQL
Sql

1 min read


Jul 27, 2020

Some SQL Tricks of an Application DBA

When 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 services, there were two types of DBAs: The Infrastructure DBA was in charge of setting up the database, configuring the storage and taking…

Database

2 min read

Some SQL Tricks of an Application DBA
Some SQL Tricks of an Application DBA
Database

2 min read


Jun 1, 2020

Stop Using datetime.now!

Practical Dependency Injection in Python — One of my favorite job interview questions is this: Write a function that returns tomorrow’s date This looks innocent enough for someone to suggest this as a solution: This will work, but there is a followup question: How would you test this function? Before you move on…. take a second to think about your answer. Keep reading this article on my personal blog >>>

Python

1 min read

Stop Using datetime.now!
Stop Using datetime.now!
Python

1 min read


May 6, 2020

How to Move a Django Model to Another App

In my latest article for RealPython I share three ways to tackle one of the most challenging tasks involving Django migrations: moving a model from one Django app to another. The article covers some exotic migration operations and many of the built-in migration CLI commands such sqlmigrate, showmigrations and sqlsequencereset. In the article I also demonstrate important migrations concepts such as reversible migrations, migration plans and introspection.

Django

1 min read

How to Move a Django Model to Another App
How to Move a Django Model to Another App
Django

1 min read


May 1, 2020

Testing an Interactive Voice Response System With Python and Pytest

Following my previous article on how to build an Interactive Voice Response (IVR) system with Twilio, Python and Django, in this follow-up tutorial I show how to write automated tests for this system. It can be very challenging to test a system that rely heavily on a third party service such as Twilio. In this article, I show how to organize your code in a way that would isolate your bushiness logic and make it easier to test separately. The article demonstrate useful testing patterns using Django’s RequestFactory, unittest.mock, Pytest fixtures, build-in django-pytest and many more.

Coding

1 min read

Testing an Interactive Voice Response System With Python and Pytest
Testing an Interactive Voice Response System With Python and Pytest
Coding

1 min read


Mar 30, 2020

Using Markdown in Django

Originally published at https://hakibenita.com on February 11, 2020. Read this article on by blog with proper syntax highlighting. As developers, we rely on static analysis tools to check, lint and transform our code. We use these tools to help us be more productive and produce better code. …

Writing

12 min read

Using Markdown in Django
Using Markdown in Django
Writing

12 min read

Haki Benita

Haki Benita

2.8K Followers

Full Stack Developer, Team Leader, Independent. More from me at https://hakibenita.com

Following
  • Netflix Technology Blog

    Netflix Technology Blog

  • Franck Pachot

    Franck Pachot

  • Gajus Kuizinas

    Gajus Kuizinas

  • Instagram Engineering

    Instagram Engineering

  • Dan Abramov

    Dan Abramov

See all (14)

Help

Status

Writers

Blog

Careers

Privacy

Terms

About

Text to speech

Teams