Advent of Code 2021 using SQL (PostgreSQL-flavored)

• advent-2021-sql

  9 435 0.0 PLpgSQL

  Advent of Code 2021 using SQL (PostgreSQL-flavored)

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.

• adventofcode

  8 - -

- No schema needed

https://gitlab.com/feike/adventofcode/-/tree/master/2021

Some others doing sql based solutions:

https://github.com/xocolatl/advent-of-code

• InfluxDB

  www.influxdata.com featured

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

• adventofcode

  2 1 8.3 Rust

• advent-of-code

  3 87 5.5 PLpgSQL

  https://adventofcode.com/ (by xocolatl)

- No schema needed

https://gitlab.com/feike/adventofcode/-/tree/master/2021

Some others doing sql based solutions:

https://github.com/xocolatl/advent-of-code

• adventofcode

  2 0 0.0 Python

  Yearly advent coding challenge at https://adventofcode.com/ (by emilbratt)

I have completed day 1 to day 4 with 0 if statements. https://github.com/emilbratt/adventofcode/tree/main/2021

• advent_of_code

  8 6 0.0 Elixir

  All of my :star: Advent of Code solutions - using Elixir (by wasi0013)

• Elixir

  133 23,401 9.8 Elixir

  Elixir is a dynamic, functional language for building scalable and maintainable applications

  

So far, I'm loving it! The source code is available on GitHub [1]

The repository also contains couple of mix tasks to generate boilerplate codes for each solve. And update the readme automatically on each commit to list the problems that I've solved so far.

[0] Elixir: https://elixir-lang.org/

• SaaSHub

  www.saashub.com featured

  SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

  

• livebooks

  4 178 5.4

  My collection of Livebooks

Oh! I almost forgot it is worth mentioning the creator of Elixir Language "José Valim" also solves these problems and streams them on twitch [0].

Those are helpful to learn different approaches to solving these problems.

[0] Github: https://github.com/josevalim/aoc

[1] Twitch: https://www.twitch.tv/collections/k_DLnk2tvBa-fQ

• advent-of-code

  4 1 8.6 Python

  Python implementations for Advent Of Code (by jarshwah)

Heh I wondered the same thing, but the README says he may not complete every challenge. I actually did the first problem in SQL, and learned a bit about window functions and bounding the range it covers:

https://github.com/jarshwah/advent-of-code/blob/main/sql/202...

Though now I know you can ignore the window and just compare against the 3rd offset, the first solution just needs a `LEAD(depth, 3)` to complete the second question.

Still - I learned about `RANGE BETWEEN` so I'm calling it a win.

• adventofcode

  10 - -

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

• advent-of-code-2021

  2 1 3.2

  https://adventofcode.com/2021 (by dflss)

• AOC2021-postgresql

  4 2 4.5

  Advent of Code 2021 done with vanilla postgresql.

• AdventOfCode

  15 2 0.0 Python

  Advent of code daily challenge (by WilliamLP)

Suggest a related project