Time to say goodbye to yet another series. But before we do so, let’s once again ask the question: “how can I make Django database queries faster?” Today I’m going to show another aspect of this problem, namely leveraging the hardware architecture for optimizing Django queries. Let’s create a read replica and set up the […]
Optimizing Django Database Queries – Part 3
In the last 2 parts I mostly talked about proper indexing. But indexing is not everything. Sure, it might be helpful in some situations, but today I’d like to show you a situation where a search can be improved without them. Disclaimer: I failed to write queries returning proper results. I have no idea why […]
Optimizing Django Database Queries – Part 2
In the previous post about optimizing Django database queries I showed how to detect and improper use of indexes and what Django creates by default. Today I’d like to show a better usage of indexing on a potentially expensive operation which is text searching. Task: Search an Author By Name As you might remember the […]
Optimizing Django Database Queries
Before we move on to the topic, I’d like to apologize for the irregular updates, but I’m going through a few courses that take a lot of time. On the other hand, from time to time they result in inspirations for new posts. One of such a case is a course focused on working with […]
How to Manage Project Dependencies with GitLab – Part 2.
In the previous post I’ve talked about creating and installing own Python packages using GitLab’s tools. Today I’d like to focus a bit more on the topic and show how you can make this process even better. We’re going to use GitLab’s CI to build the PyPi packages automatically. Problems Let’s imagine an average Cathy, […]
Hardware upgrades!
I’ve finally managed to upgrade my setup. I was hoping that I would be able to write a regular article, but due to the fact that I needed to return the monitor and waited for a week for another one, I still haven’t started writing it. Nonetheless I’d like to share with you what I’ve […]
How to Manage Project Dependencies with GitLab
Sometimes when we have a bigger project or a set of projects we want to extract some code in order to make it reusable. When integrating it with project we run into a question: how do I manage such dependencies (in GitLab)? Submodules and other Git Features One of the common approaches is using submodules. […]
What is Staging Area in Git?
If you’re a software developer, you’re likely using Git on everyday basis. It’s a very useful tool that hardly anyone learns to use properly. I’d say it’s a little bit like with driving cars: we learn for a moment, pass an exam, then we don’t do anything to boost our skills. Sure, with time we […]
Black Sheep Suspends
I hoped it wouldn’t happen, but looking back at last few months I must say I can’t meet the goals I’ve set for myself. I don’t have time to learn new things, last few posts have either been publishing materials I prepared earlier for a different occasion, or things that didn’t require much effort. This […]
Metasploitable Walk-through 1 – Reconnaissance
Welcome to the new series, which is going to be a tutorial-like walk-through of a popular metasploitable project. The main reason is that for some time I’ve been lacking ideas about how to learn and I decided to do something systematic, even if simple. For some time I was loosing interest in the topic, I […]