postgres

PostgreSQL Tools for the Visually Inclined

I started my career on the Microsoft stack building forms and websites using drag and drop tools. Over time that became a punchline, which...
Rob Conery
8 min read

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

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

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

PostgreSQL Document API Part 3: Finding Things

In parts 1 and 2 of this little series I showed various ways to save a document and then update its search field. I...
Rob Conery
5 min read

PostgreSQL Document API Part 2: Full Text Search and…

In part 1 of this series I setup a nice save function, as well as another function to create an opinionated document storage table...
Rob Conery
4 min read

Designing a PostgreSQL Document API

PostgreSQL as many know, supports JSON as a storage type and with the release of 9.4, Postgres now supports storing JSON as jsonb –...
Rob Conery
4 min read

Membership In a Box with PG-Auth

I mentioned in a previous post that I threw together some ideas one weekend on how to do membership completely within Postgres (users, roles,...
Rob Conery
3 min read