advent-2021-sql

Advent of Code 2021 using SQL (PostgreSQL-flavored)

Data & Databases

Explore on GitHub Read Hacker News discussions

3Distinct people

3Mentions

0Explicit recommenders

441GitHub stars

REPOSITORY AT A GLANCE

What to know before exploring

What it is

Advent of Code 2021 using SQL (PostgreSQL-flavored)

GitHub

Where it is used

No documented product use has been verified yet.

What people are saying

No recommendation phrase was found in the indexed comments.

No classified warning is attached to this page. Read the discussions before treating silence as approval.

Also in these discussions

No other repository is repeatedly linked in the same discussions.

This week on Hacker News

Nov 7–Nov 14 UTC · Direct repository links and separately labeled related project stories. Indexed through 11/14/2026, 1:49:46 PM UTC.

No direct repository links were found in the indexed HN discussions over the past seven days. Older discussions are available below.

Mentions over time

HN mentions by hour3 dated mentions

Observed mentions: 2021-12-07 00:28:53 UTC to 2021-12-07 13:32:58 UTC.

Counts come from the repository’s dated source evidence. Index cutoff: 2026-11-02 08:16:59 UTC.

View mention counts and date ranges

UTC ranges include their start and exclude their end. Select a period to filter the source evidence.
Period	Start (UTC)	End (exclusive, UTC)	Mentions	Submissions	Comments
Dec 7, 00:00	2021-12-07 00:00:00 UTC	2021-12-07 01:00:00 UTC	1	1	0
Dec 7, 01:00	2021-12-07 01:00:00 UTC	2021-12-07 02:00:00 UTC	0	0	0
Dec 7, 02:00	2021-12-07 02:00:00 UTC	2021-12-07 03:00:00 UTC	0	0	0
Dec 7, 03:00	2021-12-07 03:00:00 UTC	2021-12-07 04:00:00 UTC	0	0	0
Dec 7, 04:00	2021-12-07 04:00:00 UTC	2021-12-07 05:00:00 UTC	0	0	0
Dec 7, 05:00	2021-12-07 05:00:00 UTC	2021-12-07 06:00:00 UTC	0	0	0
Dec 7, 06:00	2021-12-07 06:00:00 UTC	2021-12-07 07:00:00 UTC	0	0	0
Dec 7, 07:00	2021-12-07 07:00:00 UTC	2021-12-07 08:00:00 UTC	0	0	0
Dec 7, 08:00	2021-12-07 08:00:00 UTC	2021-12-07 09:00:00 UTC	0	0	0
Dec 7, 09:00	2021-12-07 09:00:00 UTC	2021-12-07 10:00:00 UTC	1	0	1
Dec 7, 10:00	2021-12-07 10:00:00 UTC	2021-12-07 11:00:00 UTC	0	0	0
Dec 7, 11:00	2021-12-07 11:00:00 UTC	2021-12-07 12:00:00 UTC	0	0	0
Dec 7, 12:00	2021-12-07 12:00:00 UTC	2021-12-07 13:00:00 UTC	0	0	0
Dec 7, 13:00	2021-12-07 13:00:00 UTC	2021-12-07 14:00:00 UTC	1	0	1

What Hacker News says

3 sources

qwesda·Dec 7, 2021

Your repo comes up a lot in the reddit threads. Day 4/1 was particularly great! When AOC 2021 is done I hope I will find the time to compile the different approaches for each day and compare them. My current list of repos is this: - https://gitlab.com/autra/adventofcode - https://gitlab.com/feike/adventofcode - https://github.com/dflss/advent-of-code-2021 - https://github.com/mitchellh/advent-2021-sql - https://github.com/qwesda/AOC2021-postgresql - https://github.com/WilliamLP/AdventOfCode - https://github.com/xocolatl/advent-of-code - https://github.com/zr40/adventofcode

In Advent of Code 2021 with PostgreSQL

aembleton·Dec 7, 2021

Where's the answer for day 1, part 2? Here's day 1 - https://github.com/mitchellh/advent-2021-sql/blob/main/day01... I can't see where it is creating a window of three results to compare against. I guess, you might just be able to change the offset to 3, as the offsets of 1 and 2 will be included in your current window so don't need to be compared.

In Advent of Code 2021 with PostgreSQL

craigkerstiens·Dec 7, 2021Submission

Advent of Code 2021 with PostgreSQL

210 points · Open discussion