Pat Shaughnessy

Rails Developer at McKinsey & Co.

Waltham, US

Joined Nov 2011

About

Pat Shaughnessy is a Ruby developer working at a global management consulting firm during the day, but who also enjoys writing in his spare time. Pat lives in Boston, but is fluent in Spanish and spends a lot of time in Asturias, Spain with his wife and two kids. Pat also writes in-depth articles at patshaughnessy.net, some of which have been featured on the Ruby Weekly newsletter, the Ruby5 podcast and the Ruby Show. His twitter is @pat_shaughnessy

Stats

Reputation:	305
Pageviews:	273.3K
Articles:	7
Comments:	2

Articles
Comments

Articles

Looking Inside Postgres at a GiST Index

What does the GiST API do? And what does it mean to extend Postgres’s indexing system, exactly? Read on to find out!

December 19, 2017

· 11,212 Views · 5 Likes

Saving a Tree in Postgres Using LTREE

Trees are natural, haphazard, and branching; database tables are man-made rectangles full of numbers and text. How can you possibly save a beautiful tree structure into an boring DB table?

December 18, 2017

· 13,715 Views · 2 Likes

Manipulating Trees Using SQL and the Postgres LTREE Extension

Today, I'll show you how to delete, move, and copy branches from one place to another in your tree using @> in combination with other LTREE functions.

December 17, 2017

· 21,796 Views · 5 Likes

Installing the Postgres LTREE Extension

Learn how to get the Postgres LTREE extension installed and enabled so that you can access special SQL operators and functions designed to support tree operations.

December 14, 2017

· 11,018 Views · 4 Likes

Trying to Represent a Tree Structure Using Postgres

I'll be publishing a series of blog posts on the Postgres LTREE extension. I'll get started today by trying to insert a tree structure into a Postgres table using standard SQL.

December 12, 2017

· 17,283 Views · 4 Likes

Is Your Postgres Query Starved for Memory?

Why not use all your server’s available memory to run all your SQL statements as fast as possible, all the time? This result seems too easy, too good to be true. And it is.

September 19, 2017

· 43,433 Views · 9 Likes

Learning to Read x86 Assembly Language

How does your code talk to the machine? Assembly doesn't have to be only for debugging, but its syntax can be hard to wrap your head around.

January 23, 2017

· 12,414 Views · 2 Likes

Comments

Manipulating Trees Using SQL and the Postgres LTREE Extension

Dec 20, 2017 · Sarah Davis

Sounds interesting... I'd like to hear more about that. Would you mind moving the conversation over here to my site? http://patshaughnessy.net/2017/12/14/manipulating-trees-using-sql-and-the-postgres-ltree-extension? Probably no one will see these comments here.

Manipulating Trees Using SQL and the Postgres LTREE Extension

Dec 17, 2017 · Sarah Davis

Thanks for reading, Oleg... and for all your work on LTREE! I wrote about some of the gist indexing implementation of LTREE here:: http://patshaughnessy.net/2017/12/15/looking-inside-postgres-at-a-gist-index