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
Importing a CSV Into PostgreSQL Like a Pro
Postgres

Importing a CSV Into PostgreSQL Like a Pro

Importing data into PostgreSQL can be time consuming and painful – unless you toss the GUI tools and use scripts.

· Rob Conery

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

It's Time To Get Over That Stored Procedure Aversion You Have
Databases

It's Time To Get Over That Stored Procedure Aversion You Have

There is a lot of opinion about stored procedures out there that are just...

· Rob Conery