zchtodd articles - 25 total
#SQL30 Day 16: Dev Badges
Welcome to the SQL showdown series! What is this and how does it work? I'm committing t...
#SQL30 Day 15: Fuzzy Matching
Welcome to the SQL showdown series! What is this and how does it work? I'm committing t...
#SQL30 Day 14: UFO Sightings
Welcome to the SQL showdown series! What is this and how does it work? I'm committing t...
#SQL30 Day 13: Permutations
Welcome to the SQL showdown series! What is this and how does it work? I'm committing t...
#SQL30 Day 12: Greatest Discount
Welcome to the SQL showdown series! What is this and how does it work? I'm committing t...
#SQL30 Day 11: Soft Deletes
Welcome to the SQL showdown series! What is this and how does it work? I'm committing t...
#SQL30 Day 10: Random Sampling
Welcome to the SQL showdown series! What is this and how does it work? I'm committing t...
#SQL30 Day 9: Longest Span
Welcome to the SQL showdown series! What is this and how does it work? I'm committing to...
#SQL30 Day 8: Deleting Duplicates
Welcome to the SQL showdown series! What is this and how does it work? I'm committing t...
#SQL30 Day 7: Grouping Sets
Welcome to the SQL showdown series! What is this and how does it work? I'm committing t...
What database do you use?
I'm curious what databases people are using for their projects, and why you might have decided on tha...
Building parsers for fun and profit with Pyparsing
I sometimes need to either create a domain specific language, or at least be able to parse a subset o...
#SQL30 Day 6: Supermarket Sales
Welcome to the SQL showdown series! What is this and how does it work? I'm committing t...
Creating a resizable/draggable component in Angular2
This post covers how to create a resizable and draggable component in Angular2. The resizing is mo...
#SQL30 Day 5: Hierarchies
Welcome to the SQL showdown series! What is this and how does it work? I'm committing t...
#SQL30 Day 4: Video Game Sales
Welcome to the SQL showdown series! What is this and how does it work? I'm committing t...
#SQL30 Day 3: Weather Data
Welcome to the SQL showdown series! What is this and how does it work? I'm committing t...
#SQL30 Day 2: Stock Price Variance
Welcome to the SQL showdown series! What is this and how does it work? I'm committing t...
#SQL30 Day 1: Wildfires
Welcome to the SQL showdown series! What is this and how does it work? I'm committing t...
SQLAlchemy Cascading Deletes
I thought I’d do a quick write up of something that I’ve found confusing for a while now, but never t...
PostgreSQL Foreign Data Wrappers
In this article I will go through the process of developing and installing a simple foreign data wrap...
Binary Tree Interview Questions
If you're a web developer like me, you might know about tree data structures, but the need to write y...
JavaScript Data Structures & Algorithms: Arrays
There are a lot of places online to learn about arrays. I want to take a different approach to showin...
SQLAlchemy Performance Anti-Patterns and Their Fixes
An ORM makes life easier for application developers. SQLAlchemy offers a mature ORM that brings with...
I built a tool to help people understand recursion!
Recursion is one of those topics where I think a lot of people have a hard time going from reading ab...