All Posts
Latest
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
CS Theory
Featured
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
Databases
Simple Monthly Reports in PostgreSQL
Working with dates and series of dates is easy in PostgreSQL, especially using generate_series
· Rob Conery