/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.
You are here

 abelvm.github.io
Some little known PostgreSQL/PostGIS tips & tricks - Intronautics 101
| | michaelerasm.us
Window Functions in Redshift
7.2 parsecs away

Travel
| | One of the coolest things I learned about in my Redshift journey has been Window Functions. Although Window functions aren’t a novel feature and exists in other SQL databases, they are a ...
| | hakibenita.com
How to Get the First or Last Value in a Group Using Group By in SQL | Haki Benita
6.3 parsecs away

Travel
| | Getting the last value of a group in an aggregated query in PostgreSQL is a challenging task. In this article we present a simple way to get the first or last value of a group using group by.
| | boringsql.com
Gentle Introduction to Window Functions in PostgreSQL | boringSQL
6.6 parsecs away

Travel
| | Unlock powerful data analysis in PostgreSQL with window functions. Go beyond aggregates to rank, calculate running totals, and compare rows directly within your queries.
| | benhoyt.com
Mugo, a toy compiler for a subset of Go that can compile itself
36.4 parsecs away

Travel
| Mugo is a single-pass compiler for a tiny subset of the Go programming language - just enough to compile itself.