Sometimes, you just need to get a list of posts, that contain a specific piece of metadata and output them as a list. Instead of getting a list of each post and then looping over all the posts and checking for metadata, it’s a relatively simple SQL statement. If you had a list of product […]
The way WordPress decided to deal with adding custom pieces of data is both cumbersome and elegant. Because it stores ALL metadata in one table, it can be painful to try to figure out what a data object looks like. Things like adding Foreign keys and enforcing certain relationships can not be done easily. Your […]
When you construct a database, you often have to make decisions based on incomplete information. Oftentimes you’re given a small subset of data and you have to decide what kind of datatype goes where, how entities naturally link to each other and when to denormalize.
There’s one debate when it comes to building out tables for databases and that’s what do you use as the key.