Rob Conery
  • Blog
  • About
  • Publications
  • Podcasts

Category - Postgres

  • Database
  • Postgres
  • Syndication

Fine Tuning Full Text Search with PostgreSQL 12

1 month ago
15 Comments

Full Text Indexing in PostgreSQL is easy... and it's not. It's not difficult to do simple keyword searches, but fine-tuning your index with weighting and parsing rules takes some effort.

  • Database
  • Postgres
  • Syndication

Virtual, Computed Columns in PostgreSQL 12

1 month ago
9 Comments

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...

  • Postgres
  • Syndication

PostgreSQL Tools for the Visually Inclined

9 months ago
9 Comments

I started my career on the Microsoft stack building forms and websites using drag and drop tools. Over time that became a punchline, which is unfortunate because honestly, the productivity was insane...

  • Azure
  • Open Source
  • Postgres
  • Syndication

Spinning Up a PostgreSQL Database on Azure Using Bash

1 year ago
5 Comments

Running PostgreSQL on Azure was always a bit of a sideshow. One of the reasons I returned to Microsoft, however, is that they are now taking it seriously. *Very* seriously.

  • Database
  • Postgres
  • Syndication

Transactional Data Operations in PostgreSQL Using Common Table Expressions

1 year ago
1 Comment

Working with Common Table Expressions in PostgreSQL is easy and straightforward. You can insert, update and delete data easily, all in one operation, within a single transaction.

  • Database
  • Postgres

Simple Monthly Reports in PostgreSQL Using generate_series

1 year ago

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

  • Database
  • Postgres
  • Syndication

Setting Up a Fast, Comprehensive Search Routine With PostgreSQL

1 year ago

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 set this up? Better yet: when should you use full-text indexing and how would...

  • Postgres
  • Syndication

A Pure PostgreSQL Document Database API

1 year ago

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 get going with right away!

  • Postgres
  • Syndication

Interview On .NET Rocks About A Curious Moon

2 years ago

I was interviewed on .NET Rocks! while at NDC London.

  • Postgres
  • Syndication
  • Writing

My New Book About PostgreSQL, Data and Saturn: A Curious Moon

2 years ago

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

1 2 3 Next

Most Discussed

  • Fine Tuning Full Text Search with PostgreSQL 12
  • Virtual, Computed Columns in PostgreSQL 12
  • PostgreSQL Tools for the Visually Inclined
  • Creating a Massively Scalable WordPress Site on...
  • Random Travel Hacks

Self-taught Programmer Like Me?

Don’t have a CS degree? Neither do I! That’s why I wrote this book: to fill the gaps in my career. The result? 700+ pages of essentials skills and ideas every developer should know.

The Imposter's Handbook

Featured Posts

  • Imposter’s Handbook, Season 2 is Released
  • A Pure PostgreSQL Document Database API
Copyright © 2018 Rob Conery.
>