Kelvin Wangonya

Senior Data Engineer at Jenga

07/26 BigQuery time travel is pretty neat
05/26 We're here on Earth to fart around
04/26 An album for every year of my life
04/26 Handling missing dict keys, revisited
10/25 On Disabling Javascript
05/25 Handling NULL values for "not equal" checks in SQL
11/24 Be careful with join type typos
10/24 with statements don't create scope
09/24 Spotify Cleaner
09/24 man pages have sections!
08/24 Learning touch typing
03/24 On embracing asynchronous communication
03/24 Pydantic validators don't raise validation errors immediately
09/23 Trying out Ubuntu 23.04
08/23 Python __slots__
07/23 Incron
06/23 Taking notes
06/23 Adding anything to i3blocks
08/22 mysql-dump specific tables
05/22 Grokking algorithms notes
04/22 Checking string contains substring
02/22 Handling missing dict keys
12/21 Kadane's algorithm
11/21 Running multiple programs in parallel from a bash script
11/21 Processing iterators in parallel
10/21 Getting the Python version at runtime
10/21 You can use your database as a simple calculator
10/21 Setting up PostgreSQL on Arch Linux
10/21 Setting up MariaDB on Arch Linux
07/21 Getting the running Go version
04/21 Writing DRYer tests using pytest parametrize
12/20 What happens when you run PSQL slash commands?
11/20 Working with celery signals
06/20 Shallow & deep copying in Python
06/20 Variables & mutability in Rust
01/20 When to use Python's enumerate() instead of range() in loops
09/19 difflib - finding close matches of strings from a list
09/19 HTML to JSX compiler
09/19 Python 'is' vs '=='
08/19 Making your SMART goals smarter with stretch goals
08/19 Automatically counting and numbering HTML elements with CSS counters
08/19 Publishing your Python packages on TestPyPi before publishing on PyPi
08/19 Testing Click applications with pytest
08/19 Performing CRUD operations with a CLI app using Firebase
08/19 Prompting users for input
08/19 Adding arguments to CLI commands
08/19 Adding options to CLI commands
08/19 Using setuptools to package your Python app
08/19 Setting up your Python environment for Click
06/19 Fibonacci sequence with Python recursion and memoization
04/19 Creating a simple ToDo API with Django
03/19 Caring for your health as a developer
03/19 Lexical variable scoping with Javascript
03/19 Javascript arithmetic cheat sheet
02/19 Difference between a Python module and a package
02/19 Displaying a css spinner on ajax calls with fetch api
01/19 Skipping tests
01/19 Capturing print statements while debugging
01/19 Asserting exceptions with pytest
01/19 Getting started with pytest
12/18 Python's heapq module
11/18 Sorting algorithms with Javascript (Part 2)
10/18 Sorting algorithms with Javascript (Part 1)
08/18 Javascript lookaheads and lookbehinds
08/18 Javascript array iteration with some() and every()
08/18 'this' and arrow functions
08/18 Finding an element in the array (the ES5, ES6 and ES7 way)