Getting WP Post and Postmeta in Single Rows

WordPress uses wp_posts to store post, page, and Custom Post Type (CPT) data the wp_postmeta table for Custom Metabox data. To retrieve this data you have to read for the post plus multiple linked postmeta rows. In this post, we conquer postmeta with subqueries.

Read More »

Most Popular:

Forms and CPTs and Tables, Oh My!

There are several ways to collect, store, and use data in a Wordpress website. In this article, I’ll discuss and compare three of them: Forms, Custom Post Types (CPTs) and custom database tables.

Read More »

Balancing Front-end vs. Back-end Development

Development tools like Angular.js and now React.js and (my personal favorite) Vue.js have transformed front-end website/web application development. It’s actually possible to write whole applications in JavaScript now in a cohesive, management manner. The real question is: should you? The answer is, of course… it depends.

Read More »

ORM vs. Direct SQL

ORM, or Object-Relational Mapping, is a technique for interacting with a relational database without directly writing SQL statements. Is that a handy shorthand that makes coding easier? Or just another layer that gets in the way? Let’s explore both possibilities.

Read More »

Join our Mailing list!

Get all latest news, exclusive deals and service updates.