Skip to main content

All Posts

This is all of it! You can scroll through here and wander through all of the videos I've made or, if you're looking for something in particular, try searching!

Latest
Virtual, Computed Columns in PostgreSQL 12
Databases

Virtual, Computed Columns in PostgreSQL 12

PostgreSQL 12 introduced a feature I've long wished for: computed columns that are indexable and stored on disk! They're amazing and in this post I'll show you how they work and how things kind of go...

· Rob Conery

Mod and Remainder Are Not The Same
CS Theory

Mod and Remainder Are Not The Same

A remainder and a modulus look so very similar, but they are not the same thing and worse, are treated differently by different programming languages. Do you know how your language handles mod?

· Rob Conery

Simple Monthly Reports in PostgreSQL
Databases

Simple Monthly Reports in PostgreSQL

Working with dates and series of dates is easy in PostgreSQL, especially using generate_series

· Rob Conery