How to Let Google Know of Other Languages in Your Django Site
If you have a public facing Django site in multiple languages, you probably want to let Google and other search engines know about it.
-
-
- 1 minutes
- Django, ORM, PostgreSQL, SQL
How to Create an Index in Django Without Downtime
If you ever had to maintain a traffic heavy Django site, you probably had to deal with graceful migrations. In the article I explain what atomic and reversible migrations are, how to execute "raw" SQL in migrations the right way, and how using a little known migration command we can completely alter the Django migrations built-in behavior.
-
- 7 minutes
- Django, ORM, SQL, Performance
How to Use Grouping Sets in Django
How we cut a heavy admin dashboard response time in half with advanced SQL and some Django hackery. I recently had the pleasure of optimizing an old dashboard. The solution we came up with required some advanced SQL that Django does not support out of the box. In this article I present the solution, how we got to it, and a word of caution.
-
- 6 minutes
- Meta
It's Time to Own My Own Content
I started writing about two years ago. Back then, I used to read a lot on Medium. When I finally felt the urge to write something, it made sense to publish there as well. Medium provided me with a platform, an audience, and constant reinforcements in the form of stats, likes and comments. It motivated me to keep writing. Despite it's many advantages, I feel Medium is lacking in some areas.
-
Modeling Polymorphism in Django
Modeling polymorphism in relational databases is a challenging task. In this article, we present several modeling techniques to represent polymorphic objects in a relational database using the Django object-relational mapping (ORM).
-
- 4 minutes
- PostgreSQL, SQL, Performance
How We Solved a Storage Problem in PostgreSQL Without Adding a Single Byte of Storage
A while back we started getting alerts in the middle of the night on low disk space. A quick investigation led us to one of our ETL tasks. Every night the task was fired to eliminate duplicate dumps, and free up some space. This is a short story about how we found our silver bullet and solved the issue without adding a single byte of storage.
-
- 5 minutes
- Django, Django Admin, Performance
Optimizing the Django Admin Paginator
I often talk about making Django scale but what does it actually mean? It means getting consistent performance regardless of the amount of data. In this article we tackle The last nail in Django admin's scalability coffin - the paginator.
-
- 4 minutes
- PostgreSQL, SQL, Performance
Be Careful With CTE in PostgreSQL
Common table expressions, also known as the WITH clause, are a very useful feature. They help break down big queries into smaller pieces which makes it easier to read and understand. But, when used incorrectly they can cause a significant performance hit.
-
- 7 minutes
- Django, Productivity
Automating the Boring Stuff in Django Using the Check Framework
Every team has a unique development style. Some teams implement localization and require translations. Some teams are more sensitive to database issues and require more careful handling of indexes and constraints. In this article we describe how we enforce our own development style using the Django check framework, the inspect and the ast modules from the Python standard library.
-
- 10 minutes
- Django, ORM, PostgreSQL, SQL, Performance
9 Django Tips for Working with Databases
ORMs offer great utility for developers but abstracting access to the database has its costs. Developers who are willing to poke around the database and change some defaults often find that great improvements can be made.