Postgres

Spinning Up a PostgreSQL Database on Azure Using Bash

Running PostgreSQL on Azure was always a bit of a sideshow. One of the reasons I returned to Microsoft, however, is that they are...
Rob Conery
7 min read

Transactional Data Operations in PostgreSQL Using Common Table Expressions

Working with Common Table Expressions in PostgreSQL is easy and straightforward. You can insert, update and delete data easily, all in one operation, within...
Rob Conery
5 min read

Simple Monthly Reports in PostgreSQL Using generate_series

Working with dates and series of dates is easy in PostgreSQL, especially using generate_series.
Rob Conery
3 min read

Setting Up a Fast, Comprehensive Search Routine With PostgreSQL

One of the joys of working with PostgreSQL is the ability to run full-text searches right out of the box. But how do you...
Rob Conery
5 min read

A Pure PostgreSQL Document Database API

Another day, another database project in my repo! This time it's a pure PostgreSQL JSONB document storage API that you can drop in and...
Rob Conery
3 min read

Interview On .NET Rocks About A Curious Moon

I was interviewed on .NET Rocks! while at NDC London.
Rob Conery
18 sec read

My New Book About PostgreSQL, Data and Saturn: A…

I just released a new book about PostgreSQL, Saturn, and Cassini! Quite possibly the most fun I've had writing about data and databases.
Rob Conery
2 min read

My Writing Process (This Week)

Writing a book is fun and can easily consume you. Just like writing software, however, if the tools get in your way, writing becomes...
Rob Conery
3 min read

JSONB and PostgreSQL: Work Faster By Ditching Migrations

I am not a fan of migrations - never have been and probably never will be. They were interesting when Rails first came out,...
Rob Conery
2 min read

PostgreSQL Document API Part 4: Complex Queries

Storing documents in PostgreSQL is a little easier, now that we have some solid save routines, a way to run Full Text searches, and...
Rob Conery
4 min read