Logo

Who is talking?

Archive

Effective Shell Part 3: Getting Help

8 months 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

8 months 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-repres

Saving a Tree in Postgres Using LTREE

8 months 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/stat

Installing the Postgres LTREE Extension

8 months 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 exten

Trying to Represent a Tree Structure Using Postgres

8 months 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, equal