Logo

Who is talking?

Archive

Effective Shell Part 3: Getting Help

almost 2 years ago | Dave Kerr: dwmkerr.com

In this article I'll show you how to quickly get help when working with tools in the shell, without disrupting your flow!

Looking Inside Postgres at a GiST Index

almost 2 years ago | Pat Shaughnessy: Pat Shaughnessy

What do Postgres GiST indexes look like? How are they similar or different from standard Postgres indexes? In the last few posts in this series (http://patshaughnessy.net/2017/12/11/trying-to-represe

Manipulating Trees Using SQL and the Postgres LTREE Extension

almost 2 years ago | Pat Shaughnessy: Pat Shaughnessy

Yesterday, I used the LTREE extension to save a tree data structure

Saving a Tree in Postgres Using LTREE

almost 2 years ago | Pat Shaughnessy: Pat Shaughnessy

In my last post, I showed you how to install and enable a Postgres extension called https://www.postgresql.org/docs/current/stati

Installing the Postgres LTREE Extension

almost 2 years ago | Pat Shaughnessy: Pat Shaughnessy

Hidden inside of your Postgres server is code that provides special SQL operators and functions designed to support tree operations. It’s called the LTREE exte

Trying to Represent a Tree Structure Using Postgres

almost 2 years ago | Pat Shaughnessy: Pat Shaughnessy

Suppose you had a hierarchical data structure in your application - how would you save it in a database? How would you represent a complex tree structure using flat rows and columns? There are a few different, equally valid