Chidiebere Ogujeiofor articles - 15 total
Scenario 2: Mastering Backfilling for New dB Columns – Update Like a Pro!
Cover Photo Credit: Pixels Introduction One of the most interesting challenges I’ve...
Scenario 1: When You Need to Update Multiple Rows with Different Values – The Smart Way!
Here's an improved version of the introduction for Scenario 1: Updating multiple rows in a database...
Turbocharge Your App: Slash DB Calls with Raw SQL Magic!
Introduction In my experience building backend applications, one of the key factors in...
Crunch the frontend
In the previous article, I talked about the different things that I tried and how I came up with an...
Journey of a thousand miles
I recently started working on a personal project whose aim is to help users remember their birthdays,...
Automatically notify your team when you deploy new changes in a Python project
Photo from ThisisEngineeringPexels Introduction One of the things that I love about the...
Methods of Data Storage in Data Science You Should Know
Photo by Art Wall - Kittenprint on Unsplash Introduction We live in extraordinary times...
Relative calculations 1: LAG and LEAD
In this post, we are going to continue our discussion by looking at calculations that involve getting...
Comparing aggregated data to unaggregated data in SQL
Depending on the type of questions we want to answer there might be times when we need to compare agg...
Watch OVER your WINDOW of opportunities
Howdy! From the very first time I heard of SQL Window Functions, I have always been amazed at how po...
Eager Loading VS Lazy Loading in SQLAlchemy
I have heard of eager loading data relationships a lot in the past, but it was only recently that I b...
Simplifying SQLAlchemy models by creating a BaseModel
SQLAlchemy's approach of making all requests a transaction and requiring you to constantly add things...
Whats WITH CTE
This is sort of a continuation of this SQL Subqueries in acti...
SQL Subqueries in action
I have recently been helping out my brother on a very exciting project that requires managing student...
Just in CASE
I recently implemented a feature that required using the SQL CASE statement. Thus, I decided to write...